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.
This exercise is part of the course
Creating PostgreSQL Databases
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
