<code> create table department(dept_name varchar(20) not null primary key, building varchar(20),budget numeric(12,2)); create table instructor( ID varchar(5), name varchar(20), dept_name varchar(20), salary numeric(12,1));create table course( course_id varchar(8), title varchar(50), dept_name varchar(20) references department, credits numeric(2,0), primary key (course_id) #foreign key constraints can be here too : #foreign key (dept_name) references department);
create table section( course_id varchar(8), sec_id varchar(8), semster varchar(6), year numeric(4,0), building varchar(15), room_number varchar(7), time_sloth_id varchar(4), primary key(course_id,semster,year), foreign key (course_id) references course);create table teach( ID varchar(5), course_id varchar(8), semster varchar(6), year numeric(4,0), primary key (ID,course_id,semster, year), foreign key (ID) references instructor, foreign key (course_id, semster, year) references section);</code>