before everyone makes comments-yes this is part of an assignment but i do not want YOU to complete it for me.
the rules we have been given for normalisation are as follows:
UNF
Review all company documents, identify possible field names.
List them in one column making sure duplicate fields are removed. Companies may have two different names for the same piece of data.
Group like data together, put brackets around each separate repeating group or tab the group.
Give the list an overall unique identifier, underline it.
UNF to 1NF
Remove any repeating groups into separate group/table.
Identify a new unique key in each group/table, also carry over into each group/table a copy of the primary key from the original group/table.
If the new combination of keys are not unique add an extra field until it is unique.
All fields that are left over move into a new group/table in 1NF
1NF to 2NF
If the key to any group/table contains only one field this is said to already be in 2NF,move that group/table straight into 2NF.
We are looking for part key dependencies.
If a none-key has a dependency on only part of the key (one field) then the key with the dependency and the part-key are moved to a separate group/table.
Leave a copy of the part-key in the original group/table, this now becomes a foreign key.
All fields that are left over move into a new group/table in 2NF.
2NF to 3NF
Disregard any primary/foreign keys.
We are looking for a none-key dependency, that is a relationship between two none-key fields.
If we find a dependency/relationship we move them to a new group/table along with any other related fields.
We create a new primary key in this group/table, leaving a copy of the primary key in the original table which becomes a foreign-key.
All fields that are left over, move into an new group/table in 3NF
and for the first task i have done this (I Think) can someone just confirm this is correct (Below) before i do the rest of the assignment bold represents primary keys and @ represents foreign keys...thank you in advance
UNF
Student ID
Student Name
Lec Interviewer ID
Lec Interviewer Name
(Course ID)
(Course Title)
(Course Cost)
1NF
Student ID
Student Name
Lec Interviewer ID
Lec Interviewer Name
Student ID @
Course ID
Course Title
Course Cost
2NF
Student ID
Student Name
Lec Interviewer ID@
Student ID @
Course ID
Course Title
Course Cost
Lec Interviewer ID
Lec Interviewer Name
3NF
Student ID
Student Name
Lec Interviewer ID@
Student ID @
Course ID @
Lec Interviewer ID
Lec Interviewer Name
Course ID
Course Title
Course Cost
the rules we have been given for normalisation are as follows:
UNF
Review all company documents, identify possible field names.
List them in one column making sure duplicate fields are removed. Companies may have two different names for the same piece of data.
Group like data together, put brackets around each separate repeating group or tab the group.
Give the list an overall unique identifier, underline it.
UNF to 1NF
Remove any repeating groups into separate group/table.
Identify a new unique key in each group/table, also carry over into each group/table a copy of the primary key from the original group/table.
If the new combination of keys are not unique add an extra field until it is unique.
All fields that are left over move into a new group/table in 1NF
1NF to 2NF
If the key to any group/table contains only one field this is said to already be in 2NF,move that group/table straight into 2NF.
We are looking for part key dependencies.
If a none-key has a dependency on only part of the key (one field) then the key with the dependency and the part-key are moved to a separate group/table.
Leave a copy of the part-key in the original group/table, this now becomes a foreign key.
All fields that are left over move into a new group/table in 2NF.
2NF to 3NF
Disregard any primary/foreign keys.
We are looking for a none-key dependency, that is a relationship between two none-key fields.
If we find a dependency/relationship we move them to a new group/table along with any other related fields.
We create a new primary key in this group/table, leaving a copy of the primary key in the original table which becomes a foreign-key.
All fields that are left over, move into an new group/table in 3NF
and for the first task i have done this (I Think) can someone just confirm this is correct (Below) before i do the rest of the assignment bold represents primary keys and @ represents foreign keys...thank you in advance
UNF
Student ID
Student Name
Lec Interviewer ID
Lec Interviewer Name
(Course ID)
(Course Title)
(Course Cost)
1NF
Student ID
Student Name
Lec Interviewer ID
Lec Interviewer Name
Student ID @
Course ID
Course Title
Course Cost
2NF
Student ID
Student Name
Lec Interviewer ID@
Student ID @
Course ID
Course Title
Course Cost
Lec Interviewer ID
Lec Interviewer Name
3NF
Student ID
Student Name
Lec Interviewer ID@
Student ID @
Course ID @
Lec Interviewer ID
Lec Interviewer Name
Course ID
Course Title
Course Cost
