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.

Este ejercicio forma parte del curso

Creating PostgreSQL Databases

Ver curso

Instrucciones del ejercicio

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

Ejercicio interactivo práctico

Prueba este ejercicio completando el código de muestra.

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

Editar y ejecutar código