Normalize the Denormalize table

Cañete,Brandon L.Cañete,Brandon L.
1 min read

Table of contents

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.

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

0
Subscribe to my newsletter

Read articles from Cañete,Brandon L. directly inside your inbox. Subscribe to the newsletter, and don't miss out.

normalizationdenormalizationMySQL

Written by

Cañete,Brandon L.
Cañete,Brandon L.