1. (DML Basic Query) Write the command to display:

a) ISBN of the book and the amount purchased for the book.

b) ID shoppingBasket and number of books for each shopping basket, where the number of books purchased is more than 3 books.

DML Sub Query, Set Operator and Multitable Query.

Write the command:

2.

A. Displays emails of customers who have done shopping, using Sub Query IN and INTERSECT Set Operator

B. Displays ISBN books that have never been borrowed, using the NOT EXISTS and EXCEPT Set Operator Sub Query

3.

A. With Inner Join, to display the name of the Customer who has done shopping and the book title purchased

B. With Outer Join, to display book titles that have not and have been purchased

Author Name varchar(255) N Address varchar(255) N URL varchar(255) N Publisher Name varchar(255) N Address varchar(255) N Phone varchar(255) N URL integer(10) N . Customer Email varchar(255) Name varchar(255) N Phone varchar(255) N Address varchar(255) N Book ISBN varchar(255) PublisherName varchar(255) AuthorName varchar(255) AuthorAddress varchar(255) Year integer(10) N Title varchar(255) N numeric19,0) N Shopping Basket Book Shopping Basketid integer (10) Book ISBN varchar(255) Count integer(10) O ID Shopping Basket Integer (10) Customer Email varchar(255) N Price ce Warehouse Book WarehouseCode integer(10) Book ISBN varchar(255) Count integer(10) + Warehouse Code inte ger(10) Phone varchar(255) N Address varchar(255) N N Source:www.visual-paradigm.com%2Fguide%2Fdata-modeling%2Fwhat-is-entity-relationship-diagram