Book (ISBN, Category, BTitle, Quantity,CID) Sales (SalesNo, Month_Year, TotalSales, ISBN) Shop (RegNo, Location, SalesNo) Customer (CID, CName, TelNo, Age) (ii)What was the title and category of the...


Book (ISBN, Category, BTitle, Quantity,CID)


Sales (SalesNo, Month_Year, TotalSales, ISBN)


Shop (RegNo, Location, SalesNo)


Customer (CID, CName, TelNo, Age)



(ii)What was the title and category of the book that the customer Emekabought?


(iii)Who purchased the book in the Coding category,or the quantity is greater than two?


(iv)What isthe total sales and location of the shop with the registration number "REG KL 100" in the month ofApril 2021?


(v)Display the identification number, name, age together with the total salesof the customers who purchasedthe Computer Fundamentals title book.



Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here