Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the relational schema PATIENTS = ( PatientName , Doctor, DoctorSpecialty, PatientGender, insurance ) where all the attributes are atomic, ( PatientName , Doctor, PatientGender

Given the relational schema
PATIENTS =(PatientName, Doctor, DoctorSpecialty, PatientGender, insurance)
where all the attributes are atomic, (PatientName, Doctor, PatientGender) is the only candidate key of PATIENTS, and Doctor
DoctorSpecialty.
Answer the two following questions (a) and (b):
a) Explain why PATIENTS does not satisfy the third normal form (3NF) with respect to the set of functional dependencies that hold on PATIENTS. Show your work.
b) Use the decomposition algorithm discussed in class to decompose PATIENTS into a set of schemas such that each resulting schema is in 3NF; show your work. For each resulting schema, give its candidate keys and its complete set of non-trivial functional dependencies. You must explain in detail why EACH of your resulting schemas is in 3NF

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions