Database Interrogation

profilewostinabin2
DatabaseInterrogationweek6.pdf

Database Interrogation

Week 6

Student name:

Student ID:

Normalize the database below The database stores data on courses taken by students.

1. Explain the structure of the table in the First Normal Form.

2. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown.

3. Develop a set of relations in the Second and Third Normal Forms.

Submit your solution to Database Interrogation Assessment in Canvas before the end your class.