Answered step by step
Verified Expert Solution
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 NF 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 NF; show your work. For each resulting schema, give its candidate keys and its complete set of nontrivial functional dependencies. You must explain in detail why EACH of your resulting schemas is in NF
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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