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.

Deze oefening maakt deel uit van de cursus

Creating PostgreSQL Databases

Cursus bekijken

Oefeninstructies

Add a PRIMARY KEY named code to complete the definition of the zip table.
Update the definition of school to satisfy 3NF.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- 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 ___(___)
);

Code bewerken en uitvoeren