Question: Create a stored procedure named prc inv amounts to update the INV SUBTOTAL
Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8%), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.
Answer to relevant QuestionsCreate a procedure named prc_cus_balance_update that will take the invoice number as a parameter and update the customer balance.Create a stored procedure named prc_new_detail to insert new rows in the DETAILRENTAL table. The procedure should satisfy the following requirements.a. The video number will be provided as a parameter.b. Verify the video ...What are business rules? Why are they important to a database designer?What does the acronym SDLC mean, and what does an SDLC portray?The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give an example.
Post your question