Question

TABLE: SUBJECT_REGISTRATION
StudID StudName Gender CourseID Course StaffNo StaffName StaffSection DateRegister
5202151 Sarah F ITD22403 Database 321320 Sufiyan Info Systems 03/01/2020
IDB24200 Web Design 321530 Razalina Multimedia 03/01/2020
IMD20210 Multimedia
Design 321509 Zailan Multimedia 09/01/2020
IMD21240 Game
Design 321532 Amirah Multimedia 10/01/2020
5203001 Alex
M
ITD22403 Database 321208 Jaslina Info Systems 17/06/2020
ITD22103 Programming in Java 321009 Farhah Software
Engineering 21/06/2020

(a) What is the normal form of the SUBJECT_REGISTRATION table above?
(1 mark) (b) Produce a First Normal Form of the SUBJECT_REGISTRATION table above. Select an appropriate primary key.
(3 marks)
(c) Draw a complete Functional Dependency Diagram with all the correct dependencies labelled.
(6 marks) (d) Based on the Functional Dependency Diagram produced in (c), normalize the table into Second Normal Form.
(4 marks) (e) Based on the Functional Dependency Diagram produced in (c), normalize the table into Third Normal Form.
(6 marks)
(f) Based on the Third Normal Form produced in (e), draw the Entity Relationship Diagram derived from the relational schema.

Answer 1

Answer:

k ..........

Explanation:

please follow me and mark me the brainliest

Answer 2

Answer:

yeh kya hai kuch bhi likh diya bhai ek kaam karna mujhe brainlist bana dena pls