create table member(
 lastName varchar(24) default '' not null,
 firstName varchar(24) default '' not null,
 dob date default '' not null,
 degreeType varchar(32) default '' not null,
 major varchar(48) default '' not null,
 gradDate varchar(11) default '' not null,
 password varchar(32) default '' not null,
 email varchar(48) default '' not null,
 primary key(email));

create table contact(
 email varchar(48) default '' not null,
 phone varchar(20) default '' not null,
 street varchar(64) default '' not null,
 city varchar(32) default '' not null,
 state varchar(32) default '' not null,
 zip varchar(16) default '' not null,
 country varchar(48) default '' not null,
 primary key(email));

create table has(
 email varchar(32) default '' not null,
 primary key(email));
