LibreOffice Base - Group 14

Normalizing

We start off by talking about what is normalizing a database (reducing redundant data) why we should normalize our tables (To have the data in one place and to reduce the file size) Then we create a separate Group table to normalize the Group Data.

We create a separate department table and we add a contact person to the department (and a relationship for the contact person)

We rename the original employees table and copy the information into a new employees table with new constraints then we review and create relationships for the new employee table.