Question: Create a set of 3 NF normalized relations ( or tables ) given the sample data / form below. Do not draw a dependency diagram;
Create a set of NF normalized relations or tables given the sample dataform below. Do not draw a dependency diagram; only the relational schema is needed.
Start with a single table could be in NNF and then proceed to NF no multivalued attributes and has good PK
In the NF relations, determine all the dependencies.
i Proceed with NF and NF
ii Determine the dependencies at each step.
iii. Or determine the dependencies in the NF table using AB notation and write out all the tables in NF
No need to draw and ERD, use the relational schema format:
iNF TABLENAME Attribute Attribute underline the PK
State clearly any reasonable assumptions you may make.
Business Rules:
A patient can only have one surgery per day
A patient can have the same surgery multiple times
At most one drug is administered for each surgery
Each drug can have multiple side effects that
tamenthe
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
