Questions from Database Systems

Q: Write a query to display the vendor ID, vendor name,

Write a query to display the vendor ID, vendor name, brand name, and number of products of each brand supplied by each vendor. Sort the output by vendor name and then by brand name. FIGURE P7. 60 Num...

Q: Write a query to display the employee number, last name,

Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by first name....

Q: Write a query to display the largest average product price of any

Write a query to display the largest average product price of any brand. FIGURE P7. 62 Largest average brand price

Q: Write a query to display the brand ID, brand name,

Write a query to display the brand ID, brand name, brand type, and average price of products for the brand that has the largest average product price. FIGURE P7. 63 Brand with highest average price...

Q: Update the VID_STATUS attribute of the VIDEO table using a

Update the VID_STATUS attribute of the VIDEO table using a subquery to set the VID_STATUS to “OUT” for all videos that have a null value in the DETAIL_RETURNDATE attribute of the DETAILRENTAL table.

Q: Alter the PRICE table to include an attribute named PRICE_RENTDAYS

Alter the PRICE table to include an attribute named PRICE_RENTDAYS to store integers up to 2 digits. The attribute should not accept null values, and should have a default value of 3.

Q: Update the PRICE table to place the values shown in the following

Update the PRICE table to place the values shown in the following table in the PRICE_RENTDAYS attribute. PRICE_CODE PRICE_RENTDAYS  1 5  2 3  3 5  4 7  

Q: Create a trigger named trg_late_return that will write

Create a trigger named trg_late_return that will write the correct value to DETAIL_DAYSLATE in the DETAILRENTAL table whenever a video is returned. The trigger should execute as a BEFORE trigger when...

Q: Create a trigger named trg_mem_balance that will maintain

Create a trigger named trg_mem_balance that will maintain the correct value in the membership balance in the MEMBERSHIP table when videos are returned late. The trigger should execute as an AFTER tri...

Q: Create a sequence named rent_num_seq to start with

Create a sequence named rent_num_seq to start with 1100, increment by 1, and not cache any values.