A school teacher creates a table to track her student attendance. Some rows of the table are shown as follows:

S_ID	Matric	Date	Time	Sub_ID	Sub_Name	Stu_Name	Gender	Status
S001	112231	1-Oct-16	9-11 am	ENG001	English	Ali	Male	Present
S002	112231	8-Oct-16	9-11 am	ENG001	English	Ali	Male	Absent
S003	112231	1-Oct-16	2-4 pm	COM001	Computer	Ali	Male	Present
S004	112231	8-Oct-16	2-4 pm	COM001	Computer	Ali	Male	Present
S001	112233	1-Oct-16	9-11 am	ENG001	English	Fatimah	Female	Absent
S002	112234	8-Oct-16	9-11 am	ENG001	English	Fatimah	Female	Absent
S003	112235	1-Oct-16	2-4 pm	COM001	Computer	Fatimah	Female	Present
S004	112236	8-Oct-16	2-4 pm	COM001	Computer	Fatimah	Female	Present

S_ID : Session ID

Date : Session date

Time : Session time

Sub_ID : Subject ID

Sub_Name : Subject name

Matric : Matric number

Stu_Name : Students name

Gender : Students gender (Female or Male)

Status : Attendance status (Present or Absent)

1. Based on the table above, draw a dependency diagram. Ensure that each of the dependency is correctly identified and labelled.

Berdasarkan jadual di atas, lukiskan satu gambar rajah bersandaran.

Pastikan setiap kebersandaran itu dikenal pasti dan dilabel dengan betul.

2. Based on the dependency diagram which you created in 4(a)(i), describe and illustrate the process of normalizing the above table to 3NF. List down any assumptions you make about the data shown in the table.

Berdasarkan gambar rajah bersandaran yang dihasilkan dalam 4(a)(i), terangkan dan gambarkan proses penormalan jadual di atas kepada 3NF. Senaraikan sebarang andaian yang dibuat atas data yang ditunjuk dalam jadual.

(10/100)