|< < 20 > >|

Entity/Relationship Model → Relational Schema

One-to-many Relationship, no attributes

create table Department( -- one side dept_id int not null primary key, location varchar not null, ... ); create table Employee( -- many side emp_id int not null primary key, name varchar not null, dept_id int not null references Department, ... );

|< < 20 > >|