
-- ER-style subclass mapping

create table People (
	ssn         integer,
	name        text not null,
	address     text not null,
	primary key (ssn)
);

create table Employees (
	ssn         integer,
	salary      float not null,
	position    text not null,
	primary key (ssn),
    foreign key (ssn) references People(ssn)
);

create table Managers (
	ssn         integer,
	bonus       float not null,
	primary key (ssn),
    foreign key (ssn) references Employees(ssn)
);
