Latest Questions & Answers

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 all rows in the PATRON table.

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

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: 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_char_hours that will automatically

Create a trigger named trg_char_hours that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF...

Q: Modify the PILOT table to add the attribute shown in the following

Modify the PILOT table to add the attribute shown in the following table. Table P8.40 The New Attribute for the PILOT Table Attribute name Attribute Description Attribute type  PIL_PIC_HRS Pilot...

Q: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07

Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database (see Figure P7.1), write the SQL code that will produce the results shown in Figure P7.16. Figure P7.1 Structure and conte...

Q: Write the query that will generate a combined list of customers to

Write the query that will generate a combined list of customers to include the duplicate customer records. (Figure P8.4) Figure P8.4 Combined list of customers with duplicates

Q: Write the command required to update the CHAR_TOT_CHG

Write the command required to update the CHAR_TOT_CHG attribute values in the CHARTER table. Table P8.34 Attribute name Attribute Description Attribute type  CHAR_WAIT_CHG Waiting charge for eac...

Q: Write the command required to update the CHAR_TAX_CHG

Write the command required to update the CHAR_TAX_CHG attribute values in the CHARTER table. Table P8.34 Attribute name Attribute Description Attribute type  CHAR_WAIT_CHG Waiting charge for eac...