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