Question: Please give me the correct answer! Normalize following table up to BCNF. In this example we extend the PropertyInspection database to include property inspection by

 Please give me the correct answer! Normalize following table up to

Please give me the correct answer!

Normalize following table up to BCNF. In this example we extend the PropertyInspection database to include property inspection by members of staff. When staffs are required to undertake the inspections, a company car is allocated for them to 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. StaffPropertylnspection propertyNo iDate iTime pAddress comments staffNo sName carReg PG4 18-Oct-00 10.00 6 Lawrence St, Need to replace crockery SG37 Ann Beech M231 JGR Glasgow 22-Apr-01 09.006 Lawrence St, In good order PG4 Glasgow Glasgow Glasgow Glasgow SG14 David Ford M533 HDR SG14 David Ford SG14 David For SG37 Ann Beech N721 HFR PG4 1-Oct-0 22-Apr-0113.00 5 Novar Dr, Replace living room 24-Oct-01 14.00 5 Novar Dr, Good condition 2.006 Lawrence St, Damp rot in bathroom N721 HFR PG16 d M533 HDR carpet PG16 a) Find all the candidate keys b) Determine the primary key c) Find all the functional dependencies. d) Get the first normal form e) Get the second normal form f) Get the third normal form g) Get the BCNF normal formm Normalize following table up to BCNF. In this example we extend the PropertyInspection database to include property inspection by members of staff. When staffs are required to undertake the inspections, a company car is allocated for them to 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. StaffPropertylnspection propertyNo iDate iTime pAddress comments staffNo sName carReg PG4 18-Oct-00 10.00 6 Lawrence St, Need to replace crockery SG37 Ann Beech M231 JGR Glasgow 22-Apr-01 09.006 Lawrence St, In good order PG4 Glasgow Glasgow Glasgow Glasgow SG14 David Ford M533 HDR SG14 David Ford SG14 David For SG37 Ann Beech N721 HFR PG4 1-Oct-0 22-Apr-0113.00 5 Novar Dr, Replace living room 24-Oct-01 14.00 5 Novar Dr, Good condition 2.006 Lawrence St, Damp rot in bathroom N721 HFR PG16 d M533 HDR carpet PG16 a) Find all the candidate keys b) Determine the primary key c) Find all the functional dependencies. d) Get the first normal form e) Get the second normal form f) Get the third normal form g) Get the BCNF normal formm

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!