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...

See Answer

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...

See Answer

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

See Answer

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...

See Answer

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

See Answer

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

See Answer

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

See Answer

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

See Answer

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...

See Answer

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

See Answer