drop table if exists Apply;
drop table if exists Student;
drop table if exists Campus;

create table Student(ID char(3), name varchar(15), GPA float, sizeHS integer) engine = innodb;
create table Campus(location varchar(15), enrollment integer, rank integer) engine = innodb;
create table Apply(ID char(3), location varchar(15), major varchar(15), decision char(1)) engine = innodb;