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: 63% (11 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...
-
The current ratio provides information to users of financial statements regarding: a. Ability to pay for existing assets with day-to-day obligations b. Ability to pay day-to-day obligations with...
-
What is the probability that we roll a sum less 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, 4...
-
Determine the magnitudes of F1, F2 and F3 for equilibrium of the particle F = {- 9i - 8j - 5k}. Units Used: kN = 103 N Given: F = (-9 -8 -5) kN a = 4 m b = 2 m c = 4 m θ1 = 30 deg θ2 = 60...
-
Use the given points to answer the following questions. A(-4, 0, -2), B(3, 2, -4), C(2, 4, 6) Which of the points is closest to the yz-plane? A B C Which point lies in the xz-plane? OA B
-
Overview The milestone for Project One involves applying accounting principles and methods to long-term liabilities and equity. You will also evaluate these financial statement components for...
-
What is a relationship, and what three types of relationships exist?
-
Create the basic Crows Foot ERD for Tiny College.
-
Consider the assets (in millions) of two banks, A and B. Both banks are funded by $120 million in deposits and $20 million in equity. Which bank has a stronger liquidity position? Which bank probably...
-
An auditor would most likely develop customized software rather than using GAS in which of the following situations? a. The client utilizes a database management system for inventory. b. The clients...
-
Which of the following would not be an appropriate use of IDEA software? a. Developing an aging report of accounts receivable. b. Reading a complete master file for an overall integrity review. c....
-
A significant advantage of the ITF over the test data approach is that the ITF a. Tests the operation of manual controls that are contained in an accounting application. b. Tests transactions...
-
A concurrent audit technique such as tagging and tracing would be effective in addressing all of the following audit objectives except: a. Ensuring that submitted transactions have been fully...
-
The tagging and tracing approach would most likely be considered for implementation when: a. The auditor wishes to select actual transactions to be printed out to an audit file for subsequent audit...
-
A projectile launched from the ground with an initial speed of 20 m/s and a launch angle u follows a trajectory approximated by x = (20 cos )t, y = -4.9t 2 + (20 sin )t, where x and y are the...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
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?
-
Good afternoon, is my assignment instructions and required columns/rows of data. This 'ask your question' box will not allow me to attach the actual Excel file that has my formulas and calculations,...
-
Con los conocimientos adquiridos en la unidad y las orientaciones del facilitador: Evala la eficiencia del proceso de produccin en una empresa de manufacturera y refiere, si este se apega a lo...
-
Clothing Company has two service departments purchasing and maintenance, and two production departments fabrication and assembly. The distribution of each service department's efforts to the other...
Study smarter with the SolutionInn App