$6$

$.$

$$Using MySQL but without returning all the rows themselves, how many rows would be returned by the product of the customer table, the rep table, and invoices table in the KimTay database.

$7$

$.$

$$Kimtay wants to set a

$$

Payment Due

$$

$$date for all invoices. Create a query that includes the customer number, last name, invoice number, invoice date and a payment due date which is

$3$

$0$

$$days after the invoice date.

$8$

$.$

$$List the owner number, first name and last name of all the residents in the StayWell database. The first name should appear in all lowercase letters and the last name should appear in all uppercase letters.

$9$

$.$

$$StayWell is offering a monthly discount for owners who pay their monthly rent on a quarterly basis. The discount is

$5$

$.$

$5$

$$percent of the monthly fee. For each property, list the office, property number, owner number, owner's last name, monthly, and discount amount. The identifying numbers

$($

office

$,$

$$property$,$ owner

$)$

$$should be displayed as a single field with a dash between each of the three numbers. The discount should be rounded to the nearest dollar.

$1$

$0$

$.$

$$In the Kimtay database, add the customer number as a foreign key to the invoices table. Afterwards, attempt to delete the one invoice from the invoice table. Show the results.

$$

$1$

$1$

$.$

$$Create a KimTay customer invoice view. It should consist of the customer number, customer name, balance, invoice number and invoice date for all orders a customer may have placed. Query the view. Can you update the invoices for a customer via the view? Why or why not? If you can update the view, add an additional invoice for one of the customers. Query the view again to show the change.

$1$

$2$

$.$

$$Using the customer invoice view you created above, can you add a new customer via the view? Why or why not? If you can add a new customer through view, add an additional customer. Query the view again to show the change.

$1$

$3$

$.$

$$Using the MySQL system tables, list the column names and data types of all the columns

$/$

attributes of the customer table in the KimTay database

$1$

$4$

$.$

$$Write a query that lists the owner

$\_$

num, last

$\_$

name, and state for all owners in Washington state. Run "Explain" against this query. Now create an index on the state. Re

$-$

run your query and the "Explain" Are there differences in the Explain results? Why or why not?

$1$

$5$

$.$

$$Remove the customer invoice view you created earlier. Demonstrate that the view is gone.