CONNECT TO SE3DB3; --CREATE COURSE TABLE create table course( course_id varchar (8) not null, title varchar (50), dept_name varchar (20), credits integer check (credits > 0), primary key (course_id) ); --CREATE STUDENT TABLE create table student( id varchar (5) not null, name varchar (20) not null, dept_name varchar (20), tot_cred integer, primary key (id) ); --CREATE TAKES TABLE create table takes( id varchar (5) not null, course_id varchar (8) not null, semester varchar (6) not null, year integer not null, grade varchar (2), primary key (id, course_id, semester, year), foreign key (id) references student on delete cascade, foreign key (course_id) references course on delete cascade ); TERMINATE;