Uncategorized
Database Interrogation
DatabaseInterrogation
Week 6
Student name:
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.