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...
-
Calibrated manufacturing makes an electronic component that is in great demand. The component sells for $20 each. Calibrated's current capacity is 10,000 units per week. For the last few months,...
-
Which of the following events would be an extraordinary loss? a. Loss due to an earthquake b. Loss on the sale of equipment c. Loss on discontinued operations d. All of the above are extraordinary...
-
McTaggart-Hicks transactions as operating (O), investing (I), financing (F), non-cash investing and financing (NIF), or a transaction that is not reported on the statement of cash flows (N). Indicate...
-
Hall Company entered into the following transactions involving short-term liabilities. Note: Use 360 days a year. Year 1 April 20 Purchased $47,250 of merchandise on credit from Collins, terms n/30....
-
A work sheet for Juanita's Consulting is shown on the following page. There were no additional investments made by the owner during the month. REQUIRED 1. Prepare an income statement. 2. Prepare a...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
During 2014, Cobalt Co. borrowed cash from Azores Enterprises by issuing notes payable as follows: 1. March 31, 2014, issued a one-year, 4% note for $100,000. Interest is payable quarterly, on June...
-
1. What is the syntax for the while statement? 2. When using a while loop to read data from a user, what is a sentinel value? 3. When reading data from a user in the "general form", or the pumping...
-
Old Country Links, Incorporated, produces sausages in three production departments Mixing , Casing and Curing, and Packaging. In the Mixing Department, meats are prepared and ground and then mixed...
-
Input Validation The idea of input validation means that we want to be sure that the input the user provides is actually valid for use in our program. If it is, we know that we can use it safely in...
-
Oslo Company prepared the following contribution format income statement based on a sales volume of 1 , 0 0 0 units ( the relevant range of production is 5 0 0 units to 1 , 5 0 0 units ) : Sales $ 9...
-
At the end of 2022, Sunland Co. has accounts receivable of $713,600 and an allowance for doubtful accounts of $56,000. On January 24, 2023, the company learns that its receivable from Megan Gray is...
-
Calculate I o in the circuit of Fig. 2.119. 700 2 400 2 200 2 100 V 1.7 k2 800 2 400 2 +1)
-
Rewrite the code of Figure 7.3 in Ada, Java, or C#. Figure 7.3: template class queue { item items [max_items]; int next_free, next_full, num_items; public: queue () : next_free (0), next_full(0),...
-
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?
-
If cluster membership is determined by examining the squared distance of each respondent's position from the initial cluster centers, list the respondents assigned to initial Cluster#1 (5 points) ...
-
A tall pitot-static tube is mounted through and 1.5-mabove the roof of a performance car such that it senses thefreestream flow. Estimate the static, stagnation, and dynamicpressure sensed at 325 kph...
-
How does the perception of organizational justice affect employee motivation and job satisfaction, and what can organizations do to promote a sense of fairness and equity ?
Study smarter with the SolutionInn App