introduction to Database Management System

Consider the following database that keeps track of student enrollment in courses and the text books adopted (used) in each course. Student ( sNo, sName, major, birthDate) Enroll (sNo, No, semester, grade) 1nn Course ( No, cNmae, department) 100 BookAdoption (cNo, bookID, semester) 40 North 60 East TextBook (bookID, title, publisher, author) North 20 - 0 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr a) [2 pts] Write the relational algebra query given below in SQL. TTCNO Course Ticno semester="1/20072008 BookAdoption ' d) [2 pts] Write the following query in SQL: For each text book which is adopted more than once (by the same course or by different courses), list the book ID, the title, and the publisher