I have an unnormalised data, and i would like to know if im normalizing the data correctly. It my homework, and its my first time doing normalisation as its so hard to understand. Thanks in advance.
UNF
Course code
Course title
Student Code
Student Name
Address
DOB
Telephone number
Module code
Module title
Tutor code
Tutor name
1NF
Student Code (Primary key)
Student Name
Address
DOB
Telephone number
-
Student Code( Foreign key)
Course code (Primary key)
Course title
Module code
Module title
Tutor code
Tutor name
2NF
Student Code (Primary key)
Student Name
Address
DOB
Telephone number
-
Course code (Primary key)
Student Code (Foreign key)
Course title
--
Module code (Primary key)
Module title
Tutor code
Tutor name
3NF
Student Code (Primary key)
Student Name
Address
DOB
Telephone number
-
Course code (Primary key)
Student Code (Foreign key)
Course title
Module Code(Primary key)
Student code (Foreign key)
Module title
--
Tutor code
Student code
Tutor name
In addition,
1. each course is taken by one or more studetns
2.each coruse is made up of one or more modules
3.a tutor may be teaching on one or more modules
4.each module must be delivered by one and only one tutor.
help pls..... :( im stuck
No comments:
Post a Comment