Chapter 5, Problem 8RQ

Which of the following types of restrictions can be viewed with the DESCRIBE command? NOT NULL FOREIGN KEY UNIQUE CHECK

write and execute the command to retrieve the reservation id, trip id, trip date, and customer last name for every reservation in the reservation _ customer view with a trip date of September 11,2016.

Write and execute the command to retrieve the reservation ID, trip ID, trip date, and customer last name for every reservation in the RESERVATION_CUSTOMER view with a trip date of September 11, 2016.

Create a list of all of the customers' purchases, using the output from the previous command as a reference. Sort the results by invoice number, customer code, and product description. You'll need to sign up for INVOICE, LINE, and PRODUCT?

Fill in the blank question- Only answer needed without explanation Q. To view superblock information __________ command is used.

(a) Which command makes updates permanent?(b) Which command reverses updates?  (c) Which updates are reversed?

What is the difference between DELETE and TRUNCATE commands?

Write and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100. I have been trying this solution and it is incorrect:  SELECT i.item_id, i.description, l.invoice_num, l.quoted_priceFROM item iINNER JOIN invoice_line l ON i.item_id = l.item_idWHERE i.item_id IN (           SELECT item_id FROM item_invoice            WHERE quoted_price > 100);

weite the commands to insert the given data.