Draw an erd for the above relational schema, Database Management System

Assignment Help:

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.


Related Discussions:- Draw an erd for the above relational schema

ER diagram in database, What is an ER diagram? Why is it used in Database m...

What is an ER diagram? Why is it used in Database management system (DBMS)?

Explain the data access protocol, (a) Explain the three types of potentia...

(a) Explain the three types of potential mistake which could occur if concurrency control is not properly enforced in the database system. Support your answer with appropriate ex

Relational algebra, Relational Algebra is a set of basic operations used to...

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

Mapping, external and internal mapping with examples

external and internal mapping with examples

What are the states of transaction, What are the states of transaction? ...

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

Shared lock or read lock, Shared lock or Read Lock It is requested ...

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

What is key, What is key ? Key - A single attribute or a combination of...

What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

Help, #questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYP...

#questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd