The database we will be working with in this tutorial is for Codey’s Construction company (Codey is a helpful coding bot that works with you in the course mentioned earlier). As you can see from the schema above, the database contains the tables projects, job_orders, employees, and project_employees. Recently, the customers table was added to store customer data.

Unfortunately, this table has not designed in a way that satisfies the three forms of normalization… Let’s fix that!

View Answer here: