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...
-
The March 31, 2020, adjusted trial balance for Amusement Park Repair is shown below with accounts in alphabetical order. Required Preparation Component: a. Place an X in the space provided beside...
-
What is the probability that we roll a sum larger than 8 ? We are considering two special 6 -sided dice. Each face is labeled with a number and a letter: the first die has faces \(1 A, 1 B, 2 A, 2 C,...
-
On February 1, 2009, Wild Bill Corporation repurchases 650 shares of its outstanding common stock for $9 per share. On March 1, 2009, Wild Bill sells 150 shares of treasury stock for $12 per share....
-
Let f be a Riemann integrable function on [0, 1]. (i). Let g be in (0, 1). Find lim (ii). Is the answer the same if g S = 0? n g (1+x +x)n f(x)dx.
-
The management of Zigby Manufacturing prepared the following balance sheet for March 31. Cash Accounts receivable Raw materials inventory Assets ZIGBY MANUFACTURING Balance Sheet March 31 Liabilities...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
Returning to Kerry and Megan (Exercise 36), what would their account be worth if their account was compounded monthly? Recall that the formula for interest compounded yearly is \(A=P(1+r)^{t}\),...
-
What is the difference between a strike and a lockout?
-
Curt Flood's name is often associated with free agency. But what other players followed Flood to help create the process of free agency?
-
What is your view of performance appraisals? How can they be improved?
-
How do you feel about the saying that its not what you know but who you know that counts in getting a job? Is using connections to get a job a form of positive discrimination? To reduce...
-
To strengthen control over the custody of heavy mobile equipment, the client would most likely institute a policy requiring a periodic a. Increase in insurance coverage. b. Inspection of equipment...
-
Explain and carry out a method for graphing the curve x = 1 + cos 2 y - sin 2 y using parametric equations and a graphing utility.
-
Reread the discussion leading to the result given in (7). Does the matrix sI - A always have an inverse? Discuss.
-
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...
-
J Saved Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the...
-
Pine Corporation has sales revenue of $530,000 resulting in net operating income of $73,140. Average invested assets total $688,000. Residual income is $27,000. Calculate the new residual income if...
-
Your Corporation started a consulting business on January 1, 2019 by issuing $7,000 of common stock. What was net cash flow from operating activities? Provided services on account, $25,000. Incurred...
Study smarter with the SolutionInn App