16. Write a procedure named pre_cust_add to add a new customer to the CUSTOMER table. Use the following values in the new record: 1002, 'Rauthor', 'Peter', 0.00 (You should execute the procedure and verify that the new customer was added to ensure your code is correct.) 17. Write a procedure named pre_invoice_add to add a new invoice record to the INVOICE table. Use the following values in the new record: 8006, 1000, 30-APR-18, 301.72 (You should execute the procedure and verify that the new invoice was added to ensure your code is correct.) 18. Write a trigger to update the customer balance when an invoice is deleted. Name the trigger trg_updatecustbalance2. 19. Write a procedure to delete an invoice, giving the invoice number as a parameter. Name the procedure pre_inv_delete. Test the procedure by deleting invoices 8005 and 8006.

16. Write a procedure named pre_cust_add to add a new customer to the CUSTOMER table. Use the following values in the new record: 1002, 'Rauthor', 'Peter', 0.00 (You should execute the procedure and verify that the new customer was added to ensure your code is correct.) 17. Write a procedure named pre_invoice_add to add a new invoice record to the INVOICE table. Use the following values in the new record: 8006, 1000, 30-APR-18, 301.72 (You should execute the procedure and verify that the new invoice was added to ensure your code is correct.) 18. Write a trigger to update the customer balance when an invoice is deleted. Name the trigger trg_updatecustbalance2. 19. Write a procedure to delete an invoice, giving the invoice number as a parameter. Name the procedure pre_inv_delete. Test the procedure by deleting invoices 8005 and 8006.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Using the KNearest code modify it to use the features temperature, luminosity, and absolute…

A: Load the data into the program. Create three separate lists, one for each feature (temperature,…

Q: (l) Using the COUNTIF function, write a formula in cell E53 to calculate the total number of Small…

A: There are no values given in the question,it would be difficult to define the formula as there are…

Q: (d) Write a formula in cell I24 to compute the discount amount on the server. Discount Amount =…

A: D. Apply the formula I24=H24*G24/100

Q: determine whether the date format used in the united states is the most common format

A: here are almost 20 kinds of date formats available on internet. These formats are used as per their…

Q: Draw the following code on the grid provided. Private Sub Form1_Paint(ByVal sender As Object, ByVal…

A: Answer: Red Rectangle, Dimensions are height=108px, width=50px For next for loop, Y=1, X=0 Pixel…

Q: KNearest code modify it to use the features temperature, luminosity, and absolute magnitude to…

A: To modify the KNearest code to use the features temperature, luminosity, and absolute magnitude to…

Q: Given the following maxheap, show the 2nd number in the list after the 1st pop: 49, 43, 41, 23, 33,…

A: I have given an answer in step 2.

Question

From 16 to 19

16. Write a procedure named prc_cust_add to add a new customer to the CUSTOMER table.
Use the following values in the new record:
1002, Rauthor', 'Peter', 0.00
(You should execute the procedure and verify that the new customer was added to ensure
your code is correct.)
17. Write a procedure named prc_invoice_add to add a new invoice record to the INVOICE
table. Use the following values in the new record:
8006, 1000, 30-APR-18', 301.72
(You should execute the procedure and verify that the new invoice was added to ensure
your code is correct.)
18. Write a trigger to update the customer balance when an invoice is deleted. Name the trigger
trg_updatecustbalance2.
19. Write a procedure to delete an invoice, giving the invoice number as a parameter. Name
the procedure pre_inv_delete. Test the procedure by deleting invoices 8005 and 8006.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

16).

17).

18).

19).

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

c) Apply the RSA algorithm with the following data. p= 2, q = 13, M=141903
SOLVE STEP BY STEP IN DIGITAL FORMAT PLEASE 5.- The owners of a house want to convert the front steps into a ramp. The porch is 5 feet above the ground and due to building regulations, the ramp must start 12 feet from the base of the porch. How long will the ramp be?
券 C.
(i) Using the IF function, write a formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 to K41. (j) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. Screenshots attached below thank you!
ascertain if the date format used in the United States is the most often used format
Solve this problem as post fix: 34*27+ 4*2/
find the last three digits of 2^40 + 3^41 + 4^42 with steps
Finding the remainder: -52 mod 6 Respuesta: Finding the quotient: 5 div 11 Respuesta:
Given the following maxheap, show the 3rd number in the list after the 2nd pop: 49, 43, 41, 23, 33, 19, 36, 7, 22, 17, 21, 13, 12, 31, 32
#DATE TIME-TEMPERATURE UNIT HUMIDITY%9/28/2010 15:45:14 22.248900 C 44.7219689/28/2010 16:00:07 22.738900 C 50.5399939/28/2010 16:15:07 23.388900 C 49.3393389/28/2010 16:30:07 23.918900 C 47.5392809/28/2010 16:45:08 23.668900 C 40.700378The first line is just a comment, and is there to help a human understand the data that they are seeing; it should be ignored (hint: any line beginning with '#' ought to be skipped.) Write a program to read the data from the file and produce the average temperature and average humidity for all the records in the file. This is a very large file - it is the actual temperature and humidity data from our server room. You would spend hours trying to do this manually, with a calculator, and you likely would make mistakes along the way. This is where computers are far superior to humans when dealing with boring, repetitive tasks. The output of the program will look like this: Average Temperature (C): NN.NNNNNNNNNNNNNN Average Humidity (%):…
Which of the following matrices corresponds to the graph pictured above? 1 1 0 0 0 1 0 0 0 1 1 1 0 0 0 1 1 1 ГО 1 0 07 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 1 0 0 0 1 1 0 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 1 0 1 1 0 1 0 0 1 0 1 1 1 0 10 1 0 0 1 1 0 0 O - O - O O
ASAP use excel to create an algorithm to check whether the number entered is positive or negative using GoTo Statement