Get startedGet started for free

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.

This exercise is part of the course

Creating PostgreSQL Databases

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Add new columns to the borrower table
ALTER TABLE borrower
ADD COLUMN ___ VARCHAR (50) NOT NULL,
ADD COLUMN ___ VARCHAR (50) NOT NULL;

-- Remove column from borrower table to satisfy 1NF
ALTER TABLE borrower
DROP COLUMN ___;
Edit and Run Code