Database Normalization

Problem

You discover that an employee's address is stored in 5 different tables. When they move, someone always forgets to update one of them, causing billing issues. You propose breaking the data into related tables. Write a query that outputs a column goal with the value: "Normalization reduces data redundancy and improves data integrity by organizing data into related tables."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution