Question: to 3 NF . - Draw an ER ( entity - relationship ) diagram for the information in the spreadsheet, using the notation employed in

to 3NF.
- Draw an ER (entity-relationship) 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 3 or 4 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 1st normal form or not? Give a reason for your answer.
- Is your relation scheme in 3rd normal form or not? Give a reason for your answer.
to 3 NF . - Draw an ER ( entity - relationship )

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!