Entity/Relationship Model → Relational Schema
Depdendent Entities
 |
create table Artist(
artist_id int not null primary key,
name varchar not null,
...
);
create table Album(
album_id int not null primary key,
artist_id int not null references Artist,
title varchar not null,
...
primary key(artist_id, title)
);
create table Track(-- THIS IS BROKEN AND WILL NOT EXECUTE
album_id int not null references Album,
track int not null,
title varchar not null,
...
primary key(album_id, track)
);
|
|