Consider Figure 8.20. a. Write a domain integrity rule for Balance. b. Write a triggering operation for
Question:
Consider Figure 8.20.
a. Write a domain integrity rule for Balance.
b. Write a triggering operation for the Balance attribute for the event of inserting a new.
Figure 8.20
Transcribed Image Text:
ACCOUNT Account Number Balance (al (bl (c) HH Is_for Uniqueness: Must be unique Null support: Non-null WITHDRAWAL Date Time Amount Name: Account Number Name: Amount Meaning: Customer account number in bank Meaning: Dollar amount of transaction Data type: Character Format: nnn-nnnn Data type: Numeric Format: 2 decimal places Range: 0-10,000 Uniqueness: Nonunique Null support: Non-null User rule: WITHDRAWAL Amount may not exceed ACCOUNT Balance Event: Insert Entity Name: WITHDRAWAL Condition: WITHDRAWAL Amount > ACCOUNT Balance Action: Reject the insert transaction
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (6 reviews)
a Write a domain integrity rule for Balance The domain integrity rule for the Balance attribute in F...View the full answer
Answered By
OTIENO OBADO
I have a vast experience in teaching, mentoring and tutoring. I handle student concerns diligently and my academic background is undeniably aesthetic
4.30+
3+ Reviews
10+ Question Solved
Related Book For
Modern Systems Analysis And Design
ISBN: 9781292351629
9th Global Edition
Authors: Joe Valacich, Joey George
Question Posted:
Students also viewed these Computer science questions
-
Consider Figure 8.20. a. Write a domain integrity rule for Balance. b. Write a triggering operation for the Balance attribute for the event of inserting a new ACCOUNT. Figure 8.20 ACCOUNT Account...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...
-
How to respond to the following? Cycle stock, pipeline inventory, buffer stock, and in-transit inventory all have associated carrying costs. Interest rates on inventory values, warehousing expenses,...
-
The intangible assets section of Whitley Company at December 31, 2013, is presented below. Patents ($100,000 cost less $10,000 amortization) ......... $ 90,000 Copyrights ($80,000 cost less $32,000...
-
When does a company record an asset retirement obligation?
-
Verify the algebra leading to Eq. (19.22) for radiation exchange between two plates facing each other. 1 21 -(Eb1 - Eb2) (19.22) 1/1 + 1/62-1
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Suppose you have $1,000.00 and face two alternatives: 1. Put the money in an interest-bearing account that pays 0.5% monthly. This account is secured against bank failure. 2. Hold the money in cash....
-
Martin is working to develop a preliminary costbenefit analysis for a new client-server system. He has identified a number of cost factors and values for the new system, summarized in the following...
-
Discuss with a systems analyst the role of conceptual data modeling in the overall systems analysis and design of information systems at their company. How, and by whom, is conceptual data modeling...
-
Why are data flow diagrams important for the development of conceptual data modeling?
-
Symon Meats is looking at a new sausage system with an installed cost of $267,000. This cost will be depreciated straight-line to zero over the projects five-year life, at the end of which the...
-
In a sale on approval, the risk of loss passes to the buyer as soon as the buyer takes possession. (True/False)
-
Russo contracts with Playlist, Inc., to create a website through which users can post and share movies, music, and other forms of digital entertainment. Russo goes to work. Before the site is online,...
-
A buyer can acquire valid title to stolen goods if the buyer does not know that the goods are stolen. (True/False)
-
On June 1, Mel, the owner of Fresco Organico, asks Ray to deliver Frescos menu items to customers on State Universitys campus until June 15, which is the final day of the spring semester. Ray says...
-
Price-Cut Markets ordered strawberries, blueberries, and raspberries from Driscoll County Harvest Distribution Cooperative. Driscoll employees designated the berries for Price-Cut, loaded them onto a...
-
Main Line Auto Distributor is an auto parts supplier to local garage shops. None of its customers have the space or capital to store all of the possible parts they might need so they order parts from...
-
Catherine (aged 42) and Johnson (aged 45) have been married for 12 years. Johnson is a project manager of an event company at a monthly salary of $55,000 with an additional one-month salary of...
-
Compare Figures 1-2 and 1-4. Can you match steps in Figure 1-4 with phases in Figure 1-2? How might you explain the differences between the two figures? Figure 1-2 Figure 1-4 U.S. Department of...
-
Compare Figures 1-2 and 1-3. What similarities and differences do you see? Figures 1-2 Figure 1-3 Design Implementation Go/No Go Axis Analysis Maintenance Planning
-
Compare Figures 1-2 and 1-3. What similarities and differences do you see? Figures 1-2 Figure 1-3 Design Implementation Go/No Go Axis Analysis Maintenance Planning
-
With the following data, determine the statement of retained earnings and market ratios: Statement of retained earnings Initial retained income 790,000 Operating income 1,480,000 Interest expenses...
-
Hansen bought his primary residence on 1/1/2010 for $400,000. He put $50,000 of his own money as the down payment, and borrowed $350,000 from a bank for the remainder of the purchase price. On...
-
Why do you think cognitive ability factor has a significant influence on learning ?
Study smarter with the SolutionInn App