DATABASE DESIGN: Normalization - Exercises staffNo dentistName patientNo patientName appointment surgeryNo date time 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

          DATABASE DESIGN:
Normalization - Exercises
staffNo
dentistName
patientNo patientName
appointment
surgeryNo
date
time
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

DATABASE DESIGN:
Normalization - Exercises
staffNo
dentistName
patientNo patientName
appointment
surgeryNo
date
time
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

Added by Scott P.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Yujie Wang

Step 1

Looking at the given table, it seems that all the columns already contain atomic values. So, the table is already in 1NF. Second Normal Form (2NF): To achieve 2NF, we need to ensure that the table is in 1NF and that all non-key attributes are fully dependent on Show more…

Show all steps

Thanks for your feedback!

Q1: Create First Normal Form, Second Normal Form, Third Normal Form from this table. Please help. DATABASE DESIGN: Normalization Exercises staffNo dentistName patientNo patientName appointmentDate appointmentTime surgeryNo S1011 Tony Smith P100 Tony Smith P105 Helen Pearson P105 Gillian White 12-Aug-03 10:00 13-Aug-03 12:00 12-Sep-03 10:00 24-Sep-03 10:00 1-Oct-03 16:30 S10 S1011 Jill Bell S15 S1024 Ian MacKay S10 S1024 Helen Pearson P105 S10 S1032 Robin Plevin P105 Jill Bell S15 Robin Plevin P110 John Walker 15-Oct-03 18:00 S13