Question: Customer _ RentalTable table [ [ Customer _ No , CName,Property _ No , PAddress,RentStart,RentFinish,Rent,Owner _ No , OName ] , [ CR 7

Customer_RentalTable
\table[[Customer_No,CName,Property_No,PAddress,RentStart,RentFinish,Rent,Owner_No,OName],[CR76,\table[[John],[Katy]],\table[[\table[[PG4],[PG16]]]],\table[[6 Lawrence],[St, Glasgow],[5 Novar Dr,],[Glasgow]],\table[[\table[[1-Jul-94],[1-Sep-96]]]],\table[[\table[[31-Aug-96],[1-Sep-98]]]],\table[[\table[[350],[450]]]],\table[[\table[[CO40],[CO93]]]],\table[[Tina Murphy],[Tony Shaw]]],[\table[[CR56]],\table[[Aline],[Stewart]],\table[[\table[[PG4],[PG36],[PG16]]]],\table[[6 Lawrence],[St, Glasgow],[2 Manor Rd,],[Glasgow],[5 Novar Dr,],[Glasgow]],\table[[\table[[1-Sep-92],[10-Oct-94],[1-Jan-96]]]],\table[[\table[[10-June-94],[1-Dec-95],[10-Aug-96]]]],\table[[\table[[350],[375],[450]]]],\table[[CO40],[CO93],[CO93]],\table[[Tina Murphy],[Tony Shaw],[Tony Shaw]]]]
For the table above, what is its highest level of normal form?
a. UNF
b.1NF
c.2 NF
d.3 NF (copilot)
e. BCNF
f.4 NF
Customer _ RentalTable \ table [ [ Customer _ No

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 Programming Questions!