Consider the following database of student enrollment in course and books adopted for course 

Student(regno,name,major,bdate)

Course (courseno,cname,dept)

Enroll(regnk,coyrseno,sem,marks)

Book_adoption (courseno,sem,book_isbn)

Text(book_isbn,book_title,publisher,author)

1. Create the above table by properly specifying primary key and foreign key and enter at least5 tuples for each relation 

2. add new text book to database and make this book to be adopted by some department

3. procedure a list of text books (include courseno,book_isbn,book_title) in alphabetical order for courses offered by "cs" department that use more than 2 books

4. list any department that has all its book published by specific publisher 

Answer rating: 100% (QA)

1 CREATE TABLE STUDENT regno varchar10 name varchar10 major varchar10 bdate date constraint spk PRIM... View the full answer