Question: Insert the data into the tables you created in Problem
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