Entity/Relationship Model → Relational Schema
One-to-many Relationship, no attributes
 |
create table Department(
dept_id int not null primary key,
location varchar not null,
...
);
create table Employee(
emp_id int not null primary key,
name varchar not null,
...
);
|