Entity/Relationship Model → Relational Schema
Example
 |
create table Artist(
name varchar not null primary key,
website varchar
);
create table Label(
name varchar not null primary key,
website varchar
);
create table Album(
title varchar not null,
artist_name varchar not null references Artist,
year int not null,
label_name varchar not null references Label,
primary key(title, artist_name)
);
|
|
|