Question: Assume the Branch table contains a column called TotalValue that represents the total price for all books at that branch. Following the style shown in

Assume the Branch table contains a column called TotalValue that represents the total price for all books at that branch. Following the style shown in the text, write the code for the following triggers.
a. When inserting a row in the Copy table, add the price to the total value for the appropriate branch.
b. When updating a row in the Copy table, add the difference between the new price and the old price to the total value for the appropriate branch.
c. When deleting a row from the Copy table, subtract the price on the record being deleted from the total value for the appropriate branch.

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a DELIMITER CREATE TRIGGERAddTotalValue AFTER INSERT ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

671-CS-DB (988).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

One of the objects (groups) that can be managed is the ip group with the object identifier (1.3.6.1.2.1.4) in which (1.3.6.1.2.1) is the identifier of MIB-2 and (4) defines the ip group. In an agent,...

If you are using Access 2010, complete the following steps. a. Add the TotalValue field to the Branch table. Create and run a query on the Copy table to determine the appropriate values for this...

This is to be written in SQL for MS Access. Question) 12 11. What command would you use to delete the Books table trom the Henry Books database! (o Book table.) . How would 12. Write a stored...

A Guide to SQL (9th Edition) Chapter 8, Problem 8SCG Assume the OWNER table contains a column named TOTAL_FEES that represents the total monthly condo fee for all condos owned by that owner. Write...

Using SQL complete Exercise 8 SQL Functions and Procedures 8. Assume the TRIP table contains a column named TOTAL PERSONS that represents the total number of persons for that trip. Following the...

1. Spam Calls Part 1: 781 Fun Yanay gets a lot of spam calls. An area code is defined to be a three digit number from 200-999 inclusive. In reality, many of these area codes are not in use, but for...

SQL code 1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a...

This is to be written in SQL for MS Access. Questions) 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12 I keep getting syntax errors and I cannot figure out why. 1. Create a view named PenguinBooks. It consists of...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Lanahan Enterprises agrees to lease equipment to Benjamin Corporation on June 30, 2018. Both Lanahan and Benjamin use ASPE. The following information relates to the lease agreement. 1.The lease term...

GSK is a large pharmaceutical business involved in the research and development of viable new drugs. It commenced initial investigation into the viability of a new drug on 1 February 20X5 at a cost...

How can variance analysis help management make informed financial decisions, and what are some key areas where this tool proves most valuable? What types of variances ( e . g . , material, labor,...

The following are stages of the customer journey, which one is not ? a. Evaluation b. Intent c. Awareness d. Conversion .

What is the primary purpose of creating an index? a. Documenting relationships b. Identifying integrity issues c. Adding event trigger functionality to tables d. Improving the speed by which data is...

Using Access, open the Relationships window and identify all of the one-to-many relationships in the database as well as the field used in both tables to make the connection using the following...

Why doesnt Access SQL provide for the SQL CREATE VIEW statement? a. In Access, queries function as views. b. Access SQL needs to be compiled outside of the database in order to run all statements. c....

Jiminy's Cricket Farm issued a 30-year, 7.4 percent semiannual bond 7 years ago. The bond currently sells for 89 percent of its face value. The book value of this debt issue is $100 million. In...

In the "Walingo Nutrition" article, Which of the following comparisons using the independent samples t-test were NOT significant? Group of answer choices breakfast protein lunch energy breakfast...

Your car dealer is willing to lease you a new car for $319 a month for 60 months. Payments are due on the first day of each month starting with the day you sign the lease contract. If your cost of...