Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To convert the given table into BoyceCodd Normal Form BCNF we need to follow these steps Step 1 Iden...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
