connect to cs3db3;

create table Person (
	ID integer not null,
	Name varchar(20) not null,
	Email varchar(40) not null,
	primary key (ID)
);

create table Student(
	ID integer not null references Person (ID) on delete cascade,
	Major varchar(30) not null,
	primary key (ID)

);

create table Teacher(
	ID integer not null references Person(ID) on delete cascade,
	Office varchar (30) not null,
	primary key (ID)
);



list tables;