Question Description
I’m trying to learn for my Computer Science class and I’m stuck. Can you help?
answer the following questions in the world documentations feel free to ask when it is not clear.
thanks
Unformatted Attachment Preview
Purchase answer to see full attachment

Final Answer

Attached.
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
{propertyNo, iDate}
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...
