Activity 8: Normalize the Denormalize table

Normalize the Table

You are tasked with breaking down this denormalized table into multiple related tables to reduce redundancy and improve database management.

Original Table

Student Table

This table will contain the fundamental information for each student.

Course Table

This table will store all course-related information.

Department Table

This table will provide information regarding departments.

Project Table

This table will feature information regarding student projects.

Scholarship Table

This table will contain scholarship-related data.

ExtracurricularActivities Table

This table will be used to oversee after-school events.

Advisor Table

Advisor data will be tracked in this table.

Attendance Table

This table will store student attendance records.

Relationships

  • Student Table to Course Table: Many-to-One (a student can enroll in multiple courses).
  • Course Table to Department Table: Many-to-One (a course belongs to one department).

  • Student Table to Project Table: One-to-Many (a student can have multiple projects).

  • Student Table to Scholarship Table: One-to-Many (a student can have multiple scholarships).

  • Student Table to ExtracurricularActivities Table: One-to-Many (a student can participate in multiple activities).

  • Student Table to Attendance Table: One-to-Many (a student has multiple attendance records).

  • Advisor Table can have a relationship with the Student Table if needed (e.g., by adding an advisorId in the Student Table).