Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relational schema for a book database, the primary keys are underlined. Author(AuthorID, AuthorName, Address, TelephoneNo, PublisherCode) Book (BookID, Name, Release Date,

  

Consider the following relational schema for a book database, the primary keys are underlined. Author(AuthorID, AuthorName, Address, TelephoneNo, PublisherCode) Book (BookID, Name, Release Date, Price, AuthorID) Publisher (PublisherID, Name, Address, AuthorID) Write SQL queries to answer the following: (a) Write queries to show all the book information of all Books in the Book table which includes the name Harry Potter. Sort Descending in Price. (5 marks) (b) Write a query to pick out and show all the details of Authors who released books last year. (6 marks) (c) Write a query to show the number of authors who have written a book. (5 marks) (d) Write a query that will illustrate books and their various Publishers. Group by PublisherID. (5 marks) (e) Write a query to delete the Telephone Number column from the Author table. (4 marks) Total (25 marks)

Step by Step Solution

3.29 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

It appears youre looking for SQL queries to answer a series of questions based on the given relation... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Programming questions

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago