Questions from Database Systems

Q: Create a trigger named trg_pic_hours that will automatically

Create a trigger named trg_pic_hours that will automatically update the PILOT table when a new CREW row is added and the CREW table uses a ‘pilot’ CREW_JOB entry. Use the CHARTER table’s CHAR_HOURS_FL...

Q: Create a trigger named trg_cust_balance that will automatically

Create a trigger named trg_cust_balance that will automatically update the CUSTOMER table’s CUST_BALANCE when a new CHARTER row is added. Use the CHARTER table’s CHAR_TOT_CHG as the update source (Ass...

Q: Write a query to display all rows in the PATRON table.

Write a query to display all rows in the PATRON table. Figure P8.44 Ch08_FACT ERD

Q: Write a query to display the patron ID, book number,

Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is the difference from the date on which the book is returned to...

Q: Write a query to display the patron ID, patron full name

Write a query to display the patron ID, patron full name, and patron type for each patron. (Figure P8.46) Figure P8.46 Patron and patron type

Q: Write a query to display the book number, title with year

Write a query to display the book number, title with year, and subject for each book. (Figure P8.47) Figure P8.47 Book title with year

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

Write a query to display the author last name, author first name, and book number for each book written by that author. (Figure P8.48) Figure P8.48 Books written by author

Q: Write a query to display the author ID, book number,

Write a query to display the author ID, book number, title, and year for each book. (Figure P8.49) Figure P8.49 Authors of books

Q: Write the SQL code that will produce a virtual table named REP

Write the SQL code that will produce a virtual table named REP_1. The virtual table should contain the same information that was shown in Problem 16. Details from Problem 16: Figure P7.16 The query re...

Q: Write the query that will show only the duplicate customer records.

Write the query that will show only the duplicate customer records. (Figure P8.5) Figure P8.5 Duplicate customer records