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.
