Write sql ddl corresponding to the following schema make


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

2. Using the following relations to write SQL statement that follows:

Author (Author_ID, FIRST_NAME, LAST_NAME)

Book_authors_books (ISBNAuthor_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).

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Write sql ddl corresponding to the following schema make
Reference No:- TGS02749835

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)