Normalize following table up to 3rd NF.
In this example we extend the Property Inspection database to include property inspection by
members of staff. When staffs are required to undertake the inspections, they are allocated a company
car for use on the day of the inspections. However, a car may be allocated to several members of staff
as required throughout the working day. A member of staff may inspect several properties on a given
date, but a property is only inspected once on a given date.
The primary key
a) Find all the functional dependencies. FD represent functional dependency
Property Inspection (property, no iTime, pAdress, comments, staffNo, sName, carReg)
b) Get the first normal form
c) Get the second normal form
In 2NF we remove partial dependency to have the following;
d) Get the third normal form
Here we remove the transitive dependency to obtain...
15 Million Students Helped!
Sign up to view the full answer