Table definitions for 3rd Normal Form
Recall the definition of the school
table from the previous exercise:
CREATE TABLE school (
id serial PRIMARY KEY,
name VARCHAR(100) NOT NULL,
street_address VARCHAR(100) NOT NULL,
city VARCHAR(50) NOT NULL,
state VARCHAR(50) NOT NULL,
zip_code INTEGER NOT NULL
)
We can define a new table called zip
to help satisfy 3rd Normal Form.
This exercise is part of the course
Creating PostgreSQL Databases
Exercise instructions
- Add a
PRIMARY KEY
namedcode
to complete the definition of thezip
table. - Update the definition of
school
to satisfy 3NF.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Complete the definition of the table for zip codes
CREATE TABLE zip (
___ INTEGER ___ ___,
city VARCHAR(50) NOT NULL,
state VARCHAR(50) NOT NULL
);
-- Complete the definition of the "zip_code" column
CREATE TABLE school (
id serial PRIMARY KEY,
name VARCHAR(100) NOT NULL,
street_address VARCHAR(100) NOT NULL,
zip_code INTEGER REFERENCES ___(___)
);