create table student(regno varchar(10) primary key,name varchar(15),major varchar(6),bdate date);

create table course(courseno int primary key,cname varchar(10),dept varchar(7));

create table enroll(regno varchar(10),courseno int,sem int,primary key(regno,courseno,sem),mar
ks int,foreign key (regno) references student(regno),foreign key (courseno) references course(course
no));

create table text(book_isbn int,book_title varchar(10),publisher varchar(10),author varchar(10
));

create table book_adoption(courseno int,sem int,book_isbn int,primary key(courseno,sem,book_is
bn),foreign key (courseno) references course(courseno),foreign key (sem) references enroll(sem),foreign key (book_isbn) references book_adopt
ion(book_isbn));

create table book_adoption
(courseno int
,sem int
,book_isbn int
,primary key(courseno,sem,book_isbn)
,foreign key (courseno) references course(courseno)
,foreign key (sem) references enroll(sem)
,foreign key (book_isbn) references book_adoption(book_isbn));