create table student(
    snum INT primary key,
    sname varchar(30),
    major varchar(25),
    standing varchar(2),
    age INT
    );
create table faculty(
    fid INT primary key,
    fname varchar(30),
    deptid INT
    );
create table class(
    name varchar(40) primary key,
    meets_at varchar(20),
    room varchar(10),
    fid INT,
    foreign key(fid) references faculty
    );
create table enrolled(
    snum INT,
    cname varchar(40),
    primary key(snum,cname),
    foreign key(snum) references student,
    foreign key(cname) references class(name)
    );