1. Learn
    2. /
  2. Courses
    3. /
  3. Creating PostgreSQL Databases

Exercise

Working through the normalization process

Table normalization is an important action to undertake prior to creation of a new database to ensure that data redundancy is reduced and the integrity of your data is properly managed.

In this exercise, you will have an opportunity to practice normalizing database tables related to the Small Business Association loan program:

  • a borrower table will be altered to satisfy the requirements for 1st Normal Form (1NF)
  • a bank and a loan table will be altered to satisfy the requirements for 2nd Normal Form (2NF)
  • the loan table will be altered again to satisfy the requirements for 3rd Normal Form (3NF)

After completing this exercise, you should feel more confident in your ability to normalize database tables.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • The borrower table is not in 1NF. 
CREATE TABLE borrower (
    id serial PRIMARY KEY,
    full_name VARCHAR (100) NOT NULL
);

Add first_name and last_name columns. Remove the full_name column to satisfy 1NF for this table.