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...
-
A pump is being used to transfer water from an open tank to one that has air at 500 kPa above the water, as shown in Fig. 7.17. If 2250 L/min is being pumped, calculate the power delivered by the...
-
Your product is clearly not as good as the competition. The customer has been loyal to your company for years, but you will not come out with a replacement of your existing equipment for at least a...
-
Brandon Manufacturing makes carrying cases for portable electronic devices. Its costing records yield the following information: Requirements 1. Which type of costing system is Brandon using? What...
-
Greenwood Company manufactures two products-13,000 units of Product Y and 5,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering...
-
Kramer Corporation enters a contract to sell 100 custom-made iron pipes to a customer for $300,000 on December 31, 2016, and the customer pays the full amount on that date. The sales contract...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
A parachutist has a terminal velocity of -176 feet per second. That is, no matter how long a person falls, his or her speed will not exceed 176 feet per second, but it will get arbitrarily close to...
-
Implement the method size() for BST.
-
Apply the scientific method to develop and validate a hypothesis about the order of growth of the running time of each of the following two code fragments as a function of \(n\). String s = for (int...
-
Write a filter that reads text from an input stream and prints it to an output stream, removing any lines that consist only of whitespace.
-
Draw the BST that results when you insert the keys E A S Y QUE S T I O N in that order into an initially empty tree. What is the height of the resulting BST?
-
Provide client methods that return the current hour, minute, and second, as well as toString (), equals(), and hashCode()methods. Develop two implementations: one that keeps the time as a single int...
-
How are an organization's values reflected in its business practices?
-
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...
-
Develop a 3-year financial projection for your proposed cancer tele-genetics program . State any and all assumptions you make in creating your estimates. Please consider the following in creating...
-
Lets assume that we have project L, which has a 40% chance of turning out good. The company Raises $7,000, 50% from bondholders demanding a 6% interest rate and 50% from stockholders, which becomes...
-
Please assist in the filling out the above and below table. I have provided all information that has been provided to me. Company Shares Outstanding Latest Share Price MVE Total Debt W d W e a b c =...
Study smarter with the SolutionInn App