1 Normalisation - Inspection Example Consider the following relation INSPECTION held at the MyHome real estate agency, in which PropertyNo, Date is the primary key: No Address Date Time StaffNo StaffName CameraID PR4 PR16 PR4 PR16 6 Masson St 18-Oct-11 10:00 S137 8 Berry St 22-Apr-12 09:00S114 Sue Wang 6 Masson St 01-Oct-13 12:00 S114 Mike Jenk C211 St 21-Apr-12 13:00 S114 ang C323 A set of FDs for representing the business rules of INSPECTION is as follows: . {Property-No} {Address); (StaffNo+(StaffName PropertyNo, Date - [StaffNo, Time; . StaffNo, Date} {Camera!D); (StaffNo. Date, Time) {PropertyNo): . [Date, Time, CameralD - {PropertyNo) (1) Find all the keys and prime attributes w.r.t. (2) Is the given set of FDs minimal? If not, give a minimal cover (3) Is INsPECTION in SNF w.r.t. 2? If not, determine a lossless and dependency preserving 3NF decomposition. Are the relation schemas you have obtained in the de- composition in BCNF? Justify your answers