Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is

Question:

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, ’27-APR-14’, 225.40

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database Systems Design Implementation and Management

ISBN: 978-1285196145

11th edition

Authors: Carlos Coronel, Steven Morris

See More Books

Question Posted: Dec 03, 2014 08:57 AM

See More Questions

Write a procedure to add a new invoice record to the INVOICE table. Use the following values in the new record: 8006, 1000, 30-APR-14, 301.72
Apr 15Declared a 40 stock dividend to stockholders of record on May 1 to be issued May 10 The current market value is 15 per common share Prepare necessary journal entries to record the events of...
Assume that Table 10-15 lists test scores for four people, where the x score is from a test of memory and the y score is from a test of reasoning. Test the claim that both sets of scores are normally...
Jilmar Company acquired a delivery truck and made payment of P2,870,000 analyzed as follows: Price of truck - P2,500,000 Charge for extra equipment - P150,000 Value added tax (recoverable) -...
Julie and Toni consume two goods with the following utility functions: UJulie = (x + y)2, MUJuliex = 2(x + y), MUJuliey = 2(x + y) UToni = x + y, MUTonix = 1, MUToniy = 1 a) Graph an indifference...
Consider the molecule AsF 3 . (a) Draw the dot diagram. (b) Draw the molecules three-dimensional shape, and label the numeric value of all bond angles. (c) What is the shape of this molecule? (d)...
How would Colgate-Palmolive vary its marketing strategies for product lines in low-income, emerging markets? Discuss using each of the elements of the marketing mix.
Amalgamated Corporation, organized under the laws of State S, sends several traveling salespersons into State M to solicit orders, which are accepted only at the home office of Amalgamated...
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.55 million. The fixed asset will be depreciated straight-line over its...
Nikos borrowed $6000 for 24 months from his bank using an discount note. (a) How much interest did Nikos pay the bank for the use of the money? (b) How much did he receive from the bank? (c) What was...
Assuming you completed problem 10, write the query that will list the names and ages of your customers.
Write a procedure to add a new customer to the CUSTOMER table. Use the following values in the new record: 1002, Rauthor, Peter, 0.00
The London Stock Exchange (LSE) provides a list of companies listed on the exchange on its Web site (www.londonstockexchange.com) under "Statistics" and "List of Companies." Required: a. Determine...
Medical Helicopters In a study of helicopter usage and patient survival, results were obtained from 47,637 patients transported by helicopter and 111,874 patients transported by ground (based on data...
On January 1, 20X1, Laketown Company (the user) leased a truck for a seven-year period under a FINANCE LEASE and agreed to pay an annual lease payment of $6,000 at the end of each year. The interest...
ces Shouldice Hospital in Canada is widely known for one thing-hernia repair! In fact, that is the only operation it performs, and it performs a great many of them. Over the past two decades this...
2. An Annual General Meeting (AGM) is a meeting conducted annually where the members of an organization gather to discuss and vote on key issues. Public companies hold annual general meetings for...
The 3 P's of Sustainability refers to: O The groups of people that environmental efforts effect. O People, Planet, Profit O Population, Productivity, Principled None of the Above. Question 21 2...
CMA Adapted A major disadvantage of distributed data processing is a. the increased time between job request and job completion. b. the potential for hardware and software incompatibility among...
The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...
Air enters the compressor of a simple gas turbine at a pressure of $1 \mathrm{bar}$ and a temperature of $25{ }^{\circ} \mathrm{C}$. The compressor has a pressure ratio of 15 , and an isentropic...
Explain what is meant by repetition of information and inability to represent information. Explain why each of these properties may indicate a bad relational database design.
Suppose that we decompose the schema R = (A, B, C, D, E) into (A, B, C) (A, D, E). Show that this decomposition is a loss less-join decomposition if the following set F of functional dependencies...
Why certain functional dependencies are called trivial functional dependencies?
When credit terms for a sale are 2/15, n/40, the customer saves by paying early. What percent (rounded) would this savings amount to on an annual basis
An industrial robot that is depreciated by the MACRS method has B = $60,000 and a 5-year depreciable life. If the depreciation charge in year 3 is $8,640, the salvage value that was used in the...
What determines a firm's beta? Should firm management make changes to its beta? Be sure to consider the implications for the firm's investors using CAPM.

Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is

Question:

Step by Step Answer:

Name the trigger trgupdatecustbalance CREATE OR REPLACE TRIGGER TRGUPD...View the full answer

Database Systems Design Implementation and Management

Students also viewed these Computer Sciences questions