Use the contents of Figure 2.1 to work on this problem. Write the business rule(s) that governs
Question:
Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.
FIGURE 2.1
Transcribed Image Text:
Table name: AGENT (first Six attribute AGENT CODE AGENT LNAME AGENT_FNAME AGENT NTIAL AGENT AREACODE AGENT_PHONE 501 Alby Alex 713 228-1249 502 Hahn Lesh 615 882-1244 503 Okon John 615 123-5589 Link through AGENT_CODE Table name: CUSTOMER CUS CODE CUS LNAME CUS FNAME CUS_INITIAL CUS AREACODE CUS PHONE CUS INSURE TYPE CUS_INSURE AMT CUS_RENEW_DATE AGENT CODE 615 844-2573 T1 100.00 10010 Ramas Alfred 05-Apr-2012 502 501 502 502 713 894-1238 T1 250 00 10011 Dunne 16Jun-2012 Leona 615 894-2285 S2 150.00 300.00 100.00 Kathy 29-Jan-2013 10012 Smith 10013 Olowski 10014 Orlando 10015 OBrian 10016 Brown 10017 Wiliams 615 894-2180 S1 14-Oct 2012 28-Dec-2013 Paul 222-1672 T1 615 501 Myron 442-3381 T2 S1 850.00 713 22-Sep-2012 25-Mar 2013 503 502 503 501 503 Amy 297-1228 120.00 615 James George 290-2556 $1 250.00 615 17-Ju-2012 382-7185 T2 100.00 03-Dec-2012 713 10018 Farriss 10019 Smith Anne 297-3809 $2 500.00 615 14-Mar 2013 K. Olette
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 68% (19 reviews)
Given the data in the two tables you can see that an AGENT through AGENTCODE ...View the full answer
Answered By
Gabriela Rosalía Castro
I have worked with very different types of students, from little kids to bussines men and women. I have thaught at universities, schools, but mostly in private sessions for specialized purpuses. Sometimes I tutored kids that needed help with their classes at school, some others were high school or college students that needed to prepare for an exam to study abroud. Currently I'm teaching bussiness English for people in bussiness positions that want to improve their skills, and preparing and ex-student to pass a standarized test to study in the UK.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Question Posted:
Students also viewed these Computer science questions
-
Use the contents of Figure 2.1 to work on this problem. Given the business rule(s) you wrote in Problem 1, create the basic Crows Foot ERD. Table name: AGENT (first Six attribute AGENT CODE AGENT...
-
Consider the example of a breadth-first traversal given in Figure 8.15. Using the annotated numbers from that figure, describe the contents of the queue before each pass of the while loop in Code...
-
Using a table similar to that shown in Figure 3.10, calculate 74 divided by 21 using the hardware described in Figure 3.11. You should show the contents of each register on each step. Assume A and B...
-
What is the capacity for each of the containers in Problems 4754? (Give answers in the U.S. system to the nearest tenth of a gallon or in metric to the nearest tenth of a liter.) Orange 25 cm Juice...
-
On January 1, 2017, the ledger of Edmiston Software Company contains the following liability accounts: Accounts Payable..................$42,500 GST Payable...........................5,800 Unearned...
-
Kohers Inc. is considering a leasing arrangement to finance some manufacturing tools that it needs for the next 3 years. The tools will be obsolete and worthless after 3 years. The firm has the...
-
What is the most widely followed statistic in business? a. Gross profit b. Earnings per share c. Retained earnings d. Dividends
-
The shareholders' equity section of the balance sheet of TNL Systems Inc. included the following accounts at December 31, 2010: Required: 1. During 2011, TNL Systems reacquired shares of its common...
-
24) Find the maturity value of a note dated April 20 if it bears interest at 9% and matures on June 25. The face value is $2,240. On February 2, 2000 (a leap year), Karl Kruger borrowed $4,280 at 9%....
-
Two slender rods of negligible weight are pin-connected at C and attached to blocks A and B, each of weight W. Knowing that P = 1.260W and that the coefficient of static friction between the blocks...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
Your division is considering two investment projects, each of which requires an upfront expenditure of $15 million. You estimate that the investments will produce the following net cash flows: a....
-
PART 1 - What do you believe are the advantages and disadvantages of learning about a specific culture if you plan to live or work abroad for a year? Explain the reasons for your answer and provide...
-
What are the architectural principles and mechanisms underlying in-memory databases (IMDBs), and how do they compare to traditional disk-based database systems in terms of performance, durability,...
-
Pharoah Construction Company has entered into a contract beginning January 1 , 2 0 2 5 , to build a parking complex. It has been estimated that the complex will cost $ 6 0 0 , 0 0 0 and will take 3...
-
Sims Company began operations on January 1. Its cost and sales information for this year follow Direct materials Direct labor Variable overhead Fixed overhead Variable selling and administrative...
-
In the realm of NoSQL databases, what are the distinctive characteristics and use cases of key-value stores, document stores, column-family stores, and graph databases, and how do they address the...
-
Consider the circuit in Fig. 2.118 . Find the equivalent resistance at terminals: (a) a-b, (b) c-d. 450 2 10 2 300 2 300 2 450 2 60 2
-
Access the Federation of Tax Administrators Internet site at www. taxadmin.org/state-tax-forms and indicate the titles of the following state tax forms and publications: a. Minnesota Form M-100 b....
-
Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure. (The file is meant to be used as a teacher class assignment schedule. One of the many...
-
Given the file structure shown in Figure, what problem(s) might you encounter if building KOM weredeleted? BUILDING KOM KOM LDB KOM _CODE ROOM CODE TEACHER LNAME TEACHER FNAME TEACHER NITIAL...
-
Given the file structure shown in Figure, what problem(s) might you encounter if building KOM weredeleted? BUILDING KOM KOM LDB KOM _CODE ROOM CODE TEACHER LNAME TEACHER FNAME TEACHER NITIAL...
-
Find Find lim x - sin x limx In x +0x Evaluate fre'dx
-
Required Compute variances for the following items and indicate whether each variance is favorable (F) or unfavorable (U): Note: Select "None" if there is no effect (i.e., zero variance). Item Sales...
-
A company uses the periodic inventory system and had the following activity. Nov1 Beginning inventory of 100 units at $20 each. Nov5 Purchased 100 units at $22 each. Nov8 Purchased 50 units at $23...
Study smarter with the SolutionInn App