Identify the normal form the table is in and convert it to BCNF.
staffNo dentistName patientNo patientName appointment date surgeryNo
S1011 Tony Smith P100 Gillian White 12-Aug-03 10.00 S10
S1011 Tony Smith P105 Jill Bell 13-Aug-03 12.00 S15
S1024 Helen Pearson P108 Ian MacKay 12-Sept-03 10.00 S10
S1024 Helen Pearson P108 Ian MacKay 14-Sept-03 10.00 S10
S1032 Robin Plevin P105 Jill Bell 14-Oct-03 16.30 S15
S1032 Robin Plevin P110 John Walker 15-Oct-03 18.00 S13
 

Answer rating: 100% (QA)

To convert the given table into BoyceCodd Normal Form BCNF we need to follow these steps Step 1 Iden... View the full answer