Normalize the Denormalize table

Student Table

Course Table

Department Table

Project Table

Scholarship Table

ExtracurricularActivities Table

Advisor Table

Attendance Table

Tables Relationship

• I normalized this table by breaking a one student table to multiple tables like course table, department table, project table, scholarship table, extracurricularactivities table, advisor table and attendance table in which makes the data more efficient and easy to maintain.

• Also i used lucid chart to create one to many relationship for the student table and other tables.

Link for the lucid chart tables

https://lucid.app/lucidchart/da67b260-7ee7-4186-8768-4f396e9dcfab/edit?viewport_loc=-106%2C-342%2C2766%2C1824%2C0_0&invitationId=inv_caffc44b-522e-4467-9867-e465cd1a85b6