Questions from Database Systems

Q: Write a query to display the subject and the number of books

Write a query to display the subject and the number of books in each subject. Sort the results by the number of books in descending order, then by subject name in ascending order (See Figure P7.93). F...

Q: Write a query to display the author ID and the number of

Write a query to display the author ID and the number of books written by that author. Sort the results in descending order by number of books, then in ascending order by author ID (See Figure P7.94)....

Q: Write a query to display the total value of all books in

Write a query to display the total value of all books in the library (See Figure P7.95). FIGURE P7. 95 Total of All Books

Q: Write the SQL code to create the table structures for the entities

Write the SQL code to create the table structures for the entities shown in Figure P7.96. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate...

Q: The following tables provide a very small portion of the data that

The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands nece...

Q: Write the SQL command to save the rows inserted in Problem 97

Write the SQL command to save the rows inserted in Problem 97.

Q: Write a query that displays the first and last name of every

Write a query that displays the first and last name of every patron (See Figure P7.66). (50 rows) FIGURE P7. 66 All Patron Names

Q: Write the SQL command to change the movie year for movie number

Write the SQL command to change the movie year for movie number 1245 to 2010.

Q: Write a query to display the checkout number, check out date

Write a query to display the checkout number, check out date, and due date for every book that has been checked out (See Figure P7.67). (68 rows) FIGURE P7. 67 All Checkouts

Q: Alter the DETAILRENTAL table to include a derived attribute named DETAIL_

Alter the DETAILRENTAL table to include a derived attribute named DETAIL_DAYSLATE to store integers up to 3 digits. The attribute should accept null values.