drop table student;

drop table professor;

create table professor (pNumber int, pName varchar (10), address varchar (10),
constraint profPK PRIMARY KEY (pNumber));

create table student(sNumber int,
sName varchar (10), address varchar (10), professor int,
constraint studentPK PRIMARY KEY (sNumber));

insert into professor values (1, 'MM', '235FL');
insert into professor values (2, 'ER', '241FL');

insert into student values (1, 'Dave', '320FL', 1);
insert into student values (2, 'Greg', '320Fl', 1);
insert into student values (3, 'Matt', '320Fl', 2);
