the following relational database schema


The following relational database schema represents part of a simplified database used by a library:

tblBook (BookID, Title, PublisherID, Category,Price)
tblPublisher (PublisherID, PublisherName,PublisherCity)
tblAuthor (AuthorID, AuthorName, AuthorCity)
tblBookAuthor (BookID, AuthorID)

a) Draw an ERD for the above relational schema.

b) Write SQL statements to perform the following queries.

i) List the title and price of all books with category 'Database' sorted in alphabetical order of title and ascending order of price
ii) List the categories and the average price of a book in each category.
iii) List the title and category of the most expensive book.
iv) List the title and price of all 'Internet' books published by 'McGraw-Hill'.
v) List the author who has written the most expensive book.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: the following relational database schema
Reference No:- TGS0359145

Expected delivery within 24 Hours