Reference no: EM131960435

Q1) Write SQL DDL corresponding to the following schema. Make any reasonable assumptions about data types and be sure to declare primary and foreign keys.

Author (Author_ID, FIRST_NAME, LAST_NAME)

Book_authors_books (ISBN, Author_ID)

Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages)

Q2) Using the following relations to write SQL statement that follows:

Author (Author_ID, FIRST_NAME, LAST_NAME)

Book_authors_books (ISBN, Author_ID)

Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages)

1. Retrieve all the books that cost less than 35.

2. Retrieve all the authors in alphabetical order(A-Z).

3. Retrieve all the possible information about the most expensive book that published by "New Math" publisher (the data should include authors).

4. Increase price value by 10% of all books that published in 2015 (use update).