Insert the data into the tables you created in Problem1.
Answer to relevant QuestionsWrite the query that will show only the duplicate customer records.Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is entered. (Assume that the sale is a credit sale.) Test the trigger using the following new INVOICE record:8005, 1001, ...LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last name, full address, ...Create a stored procedure named prc_return_video enter data about the return of videos that had been rented. The procedure should satisfy the following requirements.a. The video number will be provided as a parameter.b. ...What is the data dictionary's function in database design?
Post your question