数据库英语综合测试题16.docxVIP

Part 3: Questions and Answers Consider the following relational schema： student (student no, _rst name, last name) book (isbn, title, authors, publisher, year) loan (student no, isbn, checkout date, duration) Use SQL to write the following queries： Create the table for the book table appropriate domain and required contraints? Change the data type of the checkout date attribute of the loan table to date? C? Add a constraint into the loan table to make sure the loan duration is no more than 180 days? D. Grant Arvil and Amy select and update authrorization on the book table? What are 6 basic ope