# data[].attributes.headline
Emailkan Laporan Projek Database Design dan Senarai Team Member

# data[].attributes.subject
Emailkan Laporan Projek Database Design dan Senarai Team Member

# data[].attributes.body
1. Perodua Car Service Maintenance System (PCSMS),
2. Catering Booking System,
3. SMK Tengku Mahkota Library Management System,
4. Manage Kelab Belia Bersatu.
Segera. CD yang dihantar kosong, tiada data. Terima kasih.

# data[].attributes.body
Due to programming contest preparation, the lab on Friday, 9 Dec 2016 will be cancelled. Please be kindly informed.

# data[].attributes.body
Muhammad Bin Sapardi

# data[].attributes.body
MUHAMMAD FIKRI ARIF BIN MOHD AMRAN
S2G2

# data[].attributes.body
Mohammad Amir Naim Bin Ibrahim

# data[].attributes.headline
Nurul Hidayah binti Nursimin (D031410116)

# data[].attributes.subject
Nurul Hidayah binti Nursimin (D031410116)

# data[].attributes.body
LABTEST

# data[].attributes.body
LabTest

# data[].attributes.body
Mohamad Luqman Nul-Hakim bin Zamri D031410175

# data[].attributes.body
MUHAMMAD WAFI BIN ISMAIL D031410009

# data[].attributes.body
D031410054 Muhammad Firdaus Bin Zakaria

# data[].attributes.body
muhamad ibrahim bin mortadza

# data[].attributes.body
not finish yet

# data[].attributes.body
D031410238

# data[].attributes.body
MUHAMMAD WAFI BIN ISMAIL
D031410009

# data[].attributes.body
D031410054

# data[].attributes.body
ERD Diagram

# data[].attributes.body
A. Draw a complete Entity Relationship Diagram (ERD) that models a town’s Public Works Department.

The relevant information is as follows:
1. Each employee has a name, phone, address, city, state, and zip.
2. There are both regular and temporary employees.
3. For regular employees, we keep track of their date hired and yearly salary. For temporary employees, we keep track of the length of their current contract and their hourly wage.
4. We keep track of each job the Public Works Department does. We keep track of the date a job starts, the date a job finished, and the location of the job.
5. We also keep track of which employees have been assigned to the job. An employee can be assigned to many jobs, and each job can have many employees assigned to it.
6. We also keep track of the supervisor of each job. A supervisor must be a regular employee. Not all regular employees have been supervisors. A regular employee can supervise many jobs. Each job has exactly one supervisor.
7. We also keep track of the residents of the town – we keep track of their names and addresses.
8. We keep track of the complaints that residents make about the jobs. Not all residents make complaints, but some make many complaints. Not all jobs generate complaints, but some generate many complaints. For each complaint, we keep track of the date and the content of the complaint.

# data[].attributes.body
QUIZ DITP 3313 DATABASE DESIGN

1. What is Distributed Database? [3 marks]

2. What is Distributed DBMS? [3 marks]

3. List FOUR advantages of DDBMSs. [4 marks]

# data[].attributes.body
1. Database system development lifecycle
2. Enhanced Entity Relationship (EER) diagram using UML Notation
3. Normalization: Third normal form (3NF)

# data[].attributes.body
Dear Students,

The Lab will be scheduled as follows:
Date: Thursday, 3rd Nov 2016
Time: 08.00 - 10.00
Venue:  Makmal Pengaturcaraan 4 FTMK - Third Floor.
Please be kindly informed.

If you have any questions, you can contact me
through this number +60 16 640 6954.

Thank you.

# data[].attributes.body
Muhd fikri ariff bin mohd amran (D031410238)

Muhd amir naim bin ibrahim (D031410152)

Muhammad bin sapardi (D031410187)

Muhd faizal bin ayub (D031410124)

Muhd ibrahim bin mortadza (D031410234)

Presentation1 4th Nov 2016
1. ERD: available
8 tables.
2. Interface design: available

# data[].attributes.body
Yap Chui Xian D031410162

Nur Hanisah binti Jailani D031410178

Nur Husnazahirah binti Zakaria D031410215

Mohamad Luqman Nul-Hakim bin Zamri D031410175

Presentation-1: 3 Nov 2016
1. Database design (ERD) : List of query.
ada beberapa kesilapan di erd.
2. Application Design: available.

# data[].attributes.body
1. Muhammad Firdaus Bin Zakaria D031410054
2. Muhammad Wafi Bin Ismail D031410009
3. Khairil Azmir Bin Khairul D031410222
4. Nurul Hidayah Binti Nursimin D031410116
5. Nur Syazila Binti Hamzah D031410242

Presentation-1: 3 Nov 2016
1. Database design (ERD) : no list of query
2. Application Design: Avilble with design error. Tiada interface untuk insert new cocu

# data[].attributes.body
Nama Ahli Kumpulan:
1. Siti Sofia Binti Shukor (D031410153)
2. Nurul Fatin Binti Bakar (D031410109)
3. Shahira Nur Amira Binti Shahran (D031410249)
4. Nazarul Azham Bin Ibrahim(D031410247)

Presentation-1: 4th Nov 2016
1. ERD:
five tables.
2. Interface Design
Available,
Interface for return tools is not available.

# data[].attributes.body
EER DIAGRAM

# data[].attributes.body
MUHAMMAD FIKRI ARIF BIN MOHD AMRAN
D031410238
EER DIAGRAM

# data[].attributes.body
D031410124
Muhammad Faizal bin Ayub

# data[].attributes.body
D031410247
Nazarul Azham bin Ibrahim

# data[].attributes.body
D031410187
Muhammad bin Sapardi

# data[].attributes.body
D031410152
Mohammad Amir Naim bin Ibrahim

# data[].attributes.body
D031410234
Muhamad Ibrahim bin Mortadza

# data[].attributes.body
EER-Modeling

# data[].attributes.headline
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.subject
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.headline
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.subject
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.body
Muhammad Wafi Bin Ismail

# data[].attributes.headline
Muhammad Firdaus Bin Zakaria D031410054 lab 

# data[].attributes.subject
Muhammad Firdaus Bin Zakaria D031410054 lab 

# data[].attributes.body
Muhammad Wafi Bin Ismail

# data[].attributes.headline
Muhammad Firdaus Bin Zakaria D031410054 lab 4

# data[].attributes.subject
Muhammad Firdaus Bin Zakaria D031410054 lab 4

# data[].attributes.body
Muhammad Wafi Bin Ismail

# data[].attributes.body
crowfoot notation

# data[].attributes.body
D031410124
Muhamad Faizal bin Ayub

# data[].attributes.body
D031410234
Muhamad ibrahim bin Mortadza

# data[].attributes.body
D031410152

# data[].attributes.body
D031410187

# data[].attributes.body
Mohamad Luqman Nul-Hakim b Zamri D031410175

# data[].attributes.body
MUHAMMAD FIKRI ARIF BIN MOHD AMRAN
D031410238

# data[].attributes.headline
Nur Husnazahirah binti Zakaria (D031410215)

# data[].attributes.subject
Nur Husnazahirah binti Zakaria (D031410215)

# data[].attributes.body
D031410109 - NURUL FATIN BINTI BAKAR

# data[].attributes.body
ERD

# data[].attributes.headline
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.subject
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.body
The lab will be scheduled as follows:
Day/Date: Thursday, 22 Sep 2016
Time : 08.00 - 10.00
Lab: MPD2
Please be kindly informed.

# data[].attributes.headline
Mohammad Amir Naim Bin Ibrahim D031410152

# data[].attributes.subject
Mohammad Amir Naim Bin Ibrahim D031410152

# data[].attributes.attachment_link.readable_text
Yap Chui Xian D031410162

Business Rules:
Student may enroll many subjects or not.
Subject is registered by one or many students.

DDL:

1.
create table subject(
subject_code varchar(10) primary key,
subject_name varchar(200)
);

2.
create table student(
student_id varchar(15) primary key,
student_name varchar(100),
student_ic number,
student_email varchar(100)
);

3.
create table enrollment(
subject_code varchar(10),
student_id varchar(15),
session varchar(10),
constraint pk_enrollment primary key (subject_code, student_id, session),
FOREIGN KEY (subject_code) REFERENCES subject(subject_code),
FOREIGN KEY (student_id) REFERENCES student(student_id)
);

# data[].attributes.headline
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.subject
Nurul Hidayah Binti Nursimin (D031410116)

# data[].attributes.attachment_link.readable_text
Business Rules:

1) Student may or not enroll many subjects and subject can be enrolled by one or many students.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

DDL: 

create table student
	(
		student_id varchar2 (20) not null primary key,
		first_name varchar2 (30),
		last_name varchar2 (30),
		address varchar2 (100),
		phone_number varchar2 (15)
	);


create table subject
	(
		subject_code varchar2 (20) not null primary key,
		subject_name varchar2 (20)
	);


create table enrollment
	(
		student_id varchar2 (20) not null,
		subject_code varchar2 (20) not null,
		constraint pk_enroll primary key (student_id, subject_code)
		constraint fk_student_id foreign key (student_id) references student (student_id),
		constraint fk_subject_code foreign key (subject_code) references subject (subject_code) 
	);




# data[].attributes.headline
Nur Husnazahirah binti Zakaria (D031410215)

# data[].attributes.subject
Nur Husnazahirah binti Zakaria (D031410215)

# data[].attributes.attachment_link.readable_text
NUR HUSNAZAHIRAH BINTI ZAKARIA (D031410215)

Business Rules
1. Student can enroll many subject or not and subject can be enroll by one or many student.





create table subject
(
subject_code 		varchar2(10),
subject_name 		varchar2(100),
subject_pre_requisite 	varchar2(100),
subject_credit_hour 	number,
subject_quota 		number,
PRIMARY KEY(subject_id)
);


create table student
(
student_id  		varchar2(10),
student_name 		varchar2(100),
student_email 		varchar2(30),
student_address 	varchar2(100),
student_section 	varchar2(4),
PRIMARY KEY(student_id)
);





create table enrollment
(
subject_id varchar2(10),
subject_code varchar2(10),
PRIMARY KEY(subject_id,subject_code)
constraint fk_student_id FOREIGN KEY(student_id)
REFERENCES student(student_id),
constraint fk_subject_id FOREIGN KEY(subject_id)
REFERENCES subject(subject_id)
);




# data[].attributes.body
MUHAMMAD FIKRI ARIF BIN MOHD AMRAN
D031410238

# data[].attributes.headline
Muhamad Ibrahim bin Mortadza (D031410234)

# data[].attributes.subject
Muhamad Ibrahim bin Mortadza (D031410234)

# data[].attributes.body
Business Rules & DDL

# data[].attributes.attachment_link.readable_text
BUSINESS RULES:
1) STUDENT MAY OR NOT ENROLL MANY SUBJECTS AND SUBJECT CAN BE ENROLLED BY ONE OR MANY STUDENTS



DDL:

1) SUBJECT

CREATE TABLE SUBJECT 
(
SUBJECT_ID VARCHAR2(10) NOT NULL,
SUBJECT_NAME VARCHAR2(60),
SUBJECT_CREDITHOUR NUMBER,
PRIMARY KEY (SUBJECT_ID)
);


2) STUDENT

CREATE TABLE STUDENT 
(
STUDENT_ID VARCHAR2(10) NOT NULL,
STUDENT_FIRSTNAME VARCHAR2(20),
STUDENT_LASTNAME VARCHAR2(20),
STUDENT_SECTION VARCHAR2(10),
PRIMARY KEY (STUDENT_ID)
);


3) ENROLLMENT

CREATE TABLE ENROLLMENT
(
SUBJECT_ID VARCHAR2(10) NOT NULL,
SUBJECT_CODE VARCHAR2(10),
PRIMARY KEY (SUBJECT_ID, SUBJECT_CODE),
CONSTRAINT FK_STUDENT_ID FOREIGN KEY(STUDENT_ID) REFERENCES STUDENT(STUDENT_ID),
CONSTRAINT FK_SUBJECT_ID FOREIGN KEY(SUBJECT_ID) REFERENCES SUBJECT(SUBJECT_ID),
);

# data[].attributes.attachment_link.readable_text
Business Rules:

1. A student can enroll many or none subject.
2. A subject must be enroll at least by a student or more.

DDL:

CREATE TABLE student (
Student_ID VARCHAR2(10) PRIMARY KEY NOT NULL,
Student_Name VARCHAR2(30),
Address VARCHAR2(70),
Phone_Number INT
);

CREATE TABLE subject(
Subject_ID VARCHAR2(10) PRIMARY KEY NOT NULL,
Subject_Name VARCHAR2(15)
);

CREATE TABLE enrollment(
Student_ID VARCHAR2(10) NOT NULL,
Subject_ID VARCHAR2(10) NOT NULL,
CONSTRAINT pk_enroll PRIMARY KEY (Student_ID,Subject_ID),
CONSTRAINT fk_Student_ID FOREIGN KEY (Student_ID)
REFERENCES student(Student_ID),
CONSTRAINT fk_Subject_ID FOREIGN KEY (Subject_ID)
REFERENCES subject(Subject_ID)
);

# data[].attributes.headline
Shahira Nur Amira bt Shahran (D031410249)

# data[].attributes.subject
Shahira Nur Amira bt Shahran (D031410249)

# data[].attributes.attachment_link.readable_text
1. Business Rules

- Student may or not enroll many subjects and
subject can be enrolled by one or many students.


2. DDL

CREATE table student
(
student_id varchar (12) not null PRIMARY KEY,
student_first_name varchar (20),
student_last_name varchar (20),
student_address varchar (50),
phone_number varchar (12),
email varchar (30)
);


CREATE table subject
(
subject_code varchar(15) not null PRIMARY KEY,
subject_name varchar(50)
);


CRAETE table enrollment
(
student_id varchar (12),
subject_code varchar(15),
PRIMARY KEY (student_id), (subject_code),
FOREIGN KEY (student_id) references student (student_id),
FOREIGN KEY (subject_code) references subject (subject_code)
);