create table students(id integer, name char(30), address varchar(100), status char(10), primary key (id));

create table transcripts(studid integer, crscode char(10), semester char(12), grage char(1), primary key (studid, crscode, semester), foreign key (studid) references students(id));
