Questions from Database Systems

Q: Write a query to display the checkout number, book number,

Write a query to display the checkout number, book number, patron ID, check out date, and due date for all checkouts that have not yet been returned. Sort the results by book number (See Figure P7.85...

Q: Write a query to display the author ID, first name,

Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name (See...

Q: Write a query to display the number of books in the FACT

Write a query to display the number of books in the FACT system (See Figure P7.87). FIGURE P7. 87 Number of Books

Q: Write a query to display the number of different book subjects in

Write a query to display the number of different book subjects in the FACT system (See Figure P7.88). FIGURE P7. 88 Number of Different Subjects

Q: Write a query to display the number of books that are available

Write a query to display the number of books that are available (not currently checked out) (See Figure P7.89). FIGURE P7. 89 Number of Books not Currently Checked Out

Q: Write a query that displays the book title, cost and year

Write a query that displays the book title, cost and year of publication for every book in the system. FIGURE P7. 65 The Ch07_FACT ERD

Q: What basic database design strategies exist, and how are such strategies

What basic database design strategies exist, and how are such strategies executed?

Q: Write a query to display the highest book cost in the system

Write a query to display the highest book cost in the system (See Figure P7.90). FIGURE P7. 90 Most Expensive Book Price

Q: Write a query to display the lowest book cost in the system

Write a query to display the lowest book cost in the system (See Figure P7.91). FIGURE P7. 91 Least Expensive Book Price

Q: Write a query to display the number of different patrons who have

Write a query to display the number of different patrons who have ever checked out a book (See Figure P7.92). FIGURE P7. 92 Different Patrons to Checkout a Book