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,
);
create table Track(
album_id int not null references Album,
track int not null,
title varchar not null,
...
primary key(album_id, track)
);
|
|