Normalization Exercise
Uploaded by
cumei8073Normalization Exercise
Uploaded by
cumei80731
2
3
Exercises:
1) The table below is associated with events in various venues in a town.
Split the above table into FOUR (4) third normal form relations. You do not have to show data or the steps that
you took to normalise the table.
1NF
VenueCode
Venue Name
VenueCode*
Event
EventTypeCode
EventTypeDescription
4
2NF
VenueCode
Venue Name
VenueCode*
Event*
Event
EventTypeCode
EventTypeDescription
3NF
VenueCode
VenueName
VenueCode*
Event*
Event
EventTypeCode*
EventTypeCode
EventTypeDesc
5
UNF 1NF 2NF 3NF
Venue Code 1 VenueCode VenueCode VenueCode
VenueName 1 VenueName VenueName VenueName
Event 2
EventTypeCode 2 VenueCode* VenueCode* VenueCode*
EventTypeDesc 2 Event Event* Event*
EventTypeCode
EventTypeDesc Event Event
EventTypeCode EventTypeCode*
EventTypeDesc
EventTypeCode
EventTypeDesc
2) The following set of data is from a manual record of a computer sales shop.
Normalise this set of data to transform it into a set of third normal form relations. You should show each of the
steps in the normalisation.
6
3) The following unnormalised table holds data for a library system.
Identify THREE (3) normalized relational database tables that should be derived from the above unnormalized
table. Specify the primary keys and foreign keys for the normalized tables you have identified.
UNF 1NF 2NF Final Answer
BorrowerID 1 BorrowerID BorrowerID Borrower
BorrowerName 1 BorrowerName BorrowerName BorrowerID (PK)
TitledBorrowed 2
DateofReturn 2 BorrowerID*
TitledBorrowed BorrowerID* RentingRecord (Or)
DateofReturn TitledBorrowed* Record
DateofReturn BorrowerID(PK)(FK)
TitledBorrowed(PK)(FK)
TitledBorrowed BookInfo
TitledBorrowed (PK)
7
4) The following unnormalised table holds data for students, the modules they have taken and the
grades achieved on those modules.
Show how this table could be split into THREE (3) normalised relational database tables.
5) The table below is associated with customers and the products they have purchased.
Split the table into FOUR (4) third normal form (3NF) relations. You do not have to show data or the steps that
you took to normalise the table.