Identifying transitive dependencies
Imagine that a nation-wide database of schools exists. Someone who is unfamiliar with database normalization proposes the following structure for the school
table:
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
)
Identify the transitive dependency introduced by this table definition.
Este exercício faz parte do curso
Creating PostgreSQL Databases
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
