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.
Diese Übung ist Teil des Kurses
Creating PostgreSQL Databases
Interaktive Übung
Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um
