Activity 8: Normalize the Denormalize table

Denormalized student table contains various details, leading to data redundancy and inconsistency

Normalization Process

To normalize the table, we can break it down into the following related tables.

Create Normalized Tables

Each entity was converted into a separate table:

Student Table

Course Table

Department Table

Project Table

Scholarship Table

ExtracurricularActivities Table

Advisor Table

Attendance Table

Create Relationships

Established relationships between the tables using foreign keys, ensuring that data integrity is maintained. For instance, each student can be linked to courses, projects, scholarships, extracurricular activities, and advisors without redundancy.

LINK:

https://lucid.app/lucidchart/9768e787-e1de-4c00-bf8d-11417f9860f7/edit?view_items=O1veOeMtOOx9&invitationId=inv_5b2e03e9-cb9a-45a4-b1e6-3469cbfa5bd3