If you find these tutorials useful, Please consider making a donation.


LibreOffice Base - Group 14


Video 37 - Normalizing - Part 1

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.

Video 38 - Normalizing - Part 2

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

Video 39 - Normalizing - Part 3

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.