CREATE TABLE Student (sName varchar (10) PRIMARY KEY, major varchar (10), advisor varchar (10));

CREATE TABLE Professor (pName varchar (10) PRIMARY KEY, dept varchar (10), salary integer);
