Question: 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

1 Expert Approved Answer

Step: 1 Unlock

It appears youre looking for SQL queries to answer a series of questions based on the given relation... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

The part shown is loaded at point C with 290 N in the positive x direction and at point E with 190 N in the positive y direction. The diameter of the bar ABD is 10 mm. Evaluate the likelihood of...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Key {1, 2, 5, 8, 12, 13, 14, 15, 16, 18} = You wish to send your friend a secret set, Secret = {1, 2, 15, 18, 20}, but you are concerned about agents of the state intercepting the message and...

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

Hi This is a question for those with strong understanding of relational databases and relational algebra. I have already completed homeowrk but would like to compare answers. Could you please provide...

Consider a database schema consisting of the following relational schemes: author_pub (author_id, pub_id, author_position) - Refers to author Publisher author (author_id, last_name, first_name)...

Consider a database schema consisting of the following relational schemes: author_pub (_author_id_, _pub_id_, author_position) -Refers to author Publisher author (_author_id_, last_name, first_name)...

Hi, This is a question for those with strong understanding of relational databases and relational algebra. I have already completed homeowrk but would like to compare answers. Could you please...

Consider the following relational database schema for BRACU Library Management System. [Underlined attributes are primary keys and foreign keys are mentioned separately] Books(Book ISBN, Copy number...

Consider the following relational database for the GBP case. Green Book Publisher (GBP) wants to maintain data about its authors, the books, editorial staff, and their work for the books. Each author...

A company has the following balances brought forward for its equipment: Cost RM655,800 Accumulated depreciation RM132,128 In the second quarter of the year, the company acquired a new equipment with...

Milburn Pierce was the sole proprietor of the Pierce Painting Company, a painting contracting company with two employees in addition to Pierce. Pierce bought workers' compensation insurance for his...

* P l e a s e explain thoroughly how t o solve for the change i n l i m i t s . Determine why i t i s difficult t o integrate i n the order given. Then compute the integrals. ( a ) 0 1 ( y 1 e - x 2...

Google applies overhead to product costs. What account(s) is(are) used to eliminate overapplied or underapplied overhead from the Factory Overhead account, assuming the amount is not material?

What journal entry is recorded when a materials manager receives a materials requisition and then issues materials (both direct and indirect) for use in the factory?

In a job order costing system, what records serve as a subsidiary ledger for Work in Process Inventory? For Finished Goods Inventory?

What information is recorded on a job cost sheet? How do management and employees use job cost sheets?

The following financial statement information is from five separate companies. Required 1. Answer the following questions about Company A. a. What is the amount of equity on December 31, 2016? b....

compare public sport settings to for-profit and non-profit sport settings

The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here's the...

Consider the university database from Exercise 2.3 and the ER diagram you designed. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If...

Consider a relation R that has three attributes ABC. It is decomposed into relations R1 with attributes AB and R2 with attributes BC. 1. State the definition of a lossless-join decomposition with...

Classify the effect of each of the following as (i) a decrease in the demand for fish or (ii) a decrease in the quantity of fish demanded. Illustrate each diagrammatically. a. The government of...

Fill in the blanks to complete the statements about a supply-and-demand model, as applied in the following situations. a. Consider the market for cement in Toronto. If, ceteris paribus, half the...

Economists sometimes make each of the following assumptions when they construct models. Discuss some situations in which each of these assumptions might be a useful simplification in order to think...