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 3NF normalized relations (or tables) given the sample data/form 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 1NF (no multi-valued attributes and has good PK).
In the 1NF relations, determine all the dependencies.
i. Proceed with 2NF and 3NF
ii. Determine the dependencies at each step.
iii. Or determine the dependencies in the 1NF table using A->B notation and write out all the tables in 3NF.
No need to draw and ERD, use the relational schema format:
i.3NF TABLE_NAME (Attribute1, Attribute2,.....) 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
Create a set of 3 NF normalized relations ( or

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!