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).