Question: to 3 NF . - Draw an ER ( entity - relationship ) diagram for the information in the spreadsheet, using the notation employed in
to NF
Draw an ER entityrelationship diagram for the information in the spreadsheet, using the notation employed in this course. If necessary, state any assumptions you had to make when modeling this college data, and explain any modeling decisions taken.
Represent your ERD as a logical design showing relation schemas of this data. Choose or rows from the spreadsheet and show how that data would be stored in your database. Briefly describe any design decisions taken and any limitations of your schema.
Give any one functional dependency that holds for this information, and state in simple words what your functional dependency tells us about the data.
Is your relation scheme in st normal form or not? Give a reason for your answer.
Is your relation scheme in rd normal form or not? Give a reason for your answer.
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
