Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the relation below (note that there is a composite primary key in this relation): (PrescriptionNumber, PatientID, Date, Drug, Dosage, PrescriberID, PrescriberName, PatientName) Answer the
Given the relation below (note that there is a composite primary key in this relation):
(PrescriptionNumber, PatientID, Date, Drug, Dosage, PrescriberID, PrescriberName, PatientName)
Answer the following questions:
List the functional dependencies for the relation (refer to page 112 of Harrington (2009) for the notation for functional dependencies).
Depending on your assumption for the relation (for example, assume that the value of PrescriberID can uniquely determine the value of PrescriberName), your answer might be different from your classmates . Then, write down the assumptions you have for the functional dependencies you identify.
Is this relation in at least 3rd normal form? Explain your reasoning.
If your answer to the 2nd question is No, normalize this relation to 3rd normal form (or above). Write down the final relation(s) after normalization. Keep in mind that during normalization, new foreign keys may be introduced to the relation(s).
Specify the relationships between the normalized tables and highlight the foreign keys.
List the functional dependencies for the normalized relation(s).
Help normalized to 3rd normal form
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