Use the contents of Figure 2.1 to work on this problem. Given the business rule(s) you wrote
Question:
Given the business rule(s) you wrote in Problem 1, create the basic Crows Foot ERD.
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: 60% (10 reviews)
The Crows Foot ERD is shown in Figure P22a Figure P22a For discus...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ 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. Write the business rule(s) that governs the relationship between AGENT and CUSTOMER. FIGURE 2.1 Table name: AGENT (first Six attribute AGENT...
-
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...
-
Given the business rule(s) you wrote in Problem 1, create the basic Crows Foot ERD.
-
Measure each amount given in Problems 1721. a. Container C in ounces b. Container C in milliliters mL 500- 400- 300 200- 100 cups 2 1 -16-ez -14 oz -12 oz -110 oz 8 oz -16 oz -4 oz 2 oz Container C...
-
Slovak Plumbing Company pays its support staff weekly and its plumbers on a semi-monthly basis. The following support staff payroll information is available for the week ended May 12, 2015: The...
-
Laser Delivery Services, Inc. (LDS) was incorporated January 1. The following transactions occurred during the year: a. Received $ 40,000 cash from the companys founders in exchange for common stock....
-
Determine the illuminances (sun, sky, and ground-reflected) on a vertical, south-facing window at solar noon at \(36^{\circ} \mathrm{N}\) latitude on June 21 and December 21 for (a) a clear day (b)...
-
(S. Sridhar, adapted) Southwick Company uses normal costing in its job-costing system. Partially completed T-accounts and additional information for Southwick for 2014 are as follows: Additional...
-
Five relevant types of power include: coercive, legitimate, reward, referent, and expert. What power do you think you would find most motivating in the workplace? Why? Include an example in your...
-
During the Plan Order Phase, the hours for the Receive Order phase (marked with an *) are actual times, as this work has already been performed. In addition to these internal labors costs, the...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
An ordinary glass is filled to the brim with 350.0mL of water at 100.0oC. If the temperature decreased to 20.0oC, how much water could be added to the glass?
-
Wayne Management Ltd acquired all assets and liabilities of Felix Ltd on 30 June 2020. The carrying amount and fair value of assets and liabilities taken over are as follows: Assets Carrying amount...
-
The leading cause of death in adolescence, actuallyuntil we are 26 years old, is accidents. In adolescents andyoung adults this is automotive accidents. What are some ofthe reasons adolescents and...
-
Troy, a publicly-traded company, acquired 10 acres of land from Trojan. Troy gave Trojan 10,000 shares of Troy's $1 par value common stock in exchange for the land. At the time of the acquisition,...
-
Consider a bond with the following features and a hypothetical settlement date of 10 October 2019. Annual Coupon 5% Coupon Payment Frequency Semiannual Interest Payment Dates 30 December and 30 June...
-
Weaver, Inc. has budgeted direct materials purchases of P150,000 in March and P240,000 in April. Past experience indicates that the company pays for 70% of its purchases in the month of purchase and...
-
In analyzing data from over 700 games in the National Football League, economist David Romer identified 1068 fourth-down situations in which, based on his analysis, the right call would have been to...
-
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....
-
Discuss the importance of data modeling.
-
Discuss the importance of data modeling.
-
What is a business rule, and what is its purpose in data modeling?
-
Explain by giving examples the causes of the differences between taxable income and accounting income ( 5 Marks ) b . Dolphin Company Limited has results of its operations for the year 2 0 1 4 as...
-
Navkar Corporation Limited showed the inventory stock on S ptember 3 0 , 2 0 1 7 , is R$ 7 5 , 0 0 0 . From September 1 5 to September 3 0 , the gross sales of the company were R$ 1 2 5 , 0 0 0 ;...
-
Discuss the process of creating a flexible budget. What are the key steps involved, and how does it differ from the process of developing a static budget?
Study smarter with the SolutionInn App