Figure 1-21 shows an enterprise data model for a pet store. a. What is the relationship between
Question:
Figure 1-21 shows an enterprise data model for a pet store.
a. What is the relationship between Pet and Store (one-toone, many-to-many, or one-to-many)?
b. What is the relationship between Customer and Pet?
c. Do you think there should be a relationship between Customer and Store?
Transcribed Image Text:
STORE Has Sold By CUSTOMER PET Buys Purchased By
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 83% (12 reviews)
a Onetomany b Onetomany c There could be a ...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
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
Figure 1-21 shows an enterprise data model for a music store. a. What is the relationship between Album and Store (one-to-one, many-to-many, or one-to-many)? b. What is the relationship between...
-
List three additional entities that might appear in an enterprise data model for Pine Valley Furniture Company (Figure 1-3a). CUSTOMER Places Is Placed By ORDER Contains Is Contained In PRODUCT
-
Explain the differences between an enterprise data model and a conceptual data model. How many databases does each represent? What scope of the organization does each address? What are other salient...
-
You are the assistant vice president in charge of production for a firm that produces computers. Your firm's production function is f(L,K) = min (L,K) Where L and K are the quantities of the two...
-
A cheetah is hunting. Its prey runs for 3.0 s at a constant velocity of 19.0 m/s. Starting from rest, what constant acceleration must the cheetah maintain in order to run the same distance as its...
-
Heat is added in the amount of 300 Btu/lbm of air to a diesel cycle, with a compression ratio of 22 and a cutoff ratio of 2. Air enters the engine at 14.7 psia and 77F. Determine, using a cold-air...
-
Use the PewHealth dataset to run a regression that contrasts whites with the other racial groups on the Health Conditions Index. How much variation do these variables explain? Which groups...
-
The stock of Quail Corporation is held as follows: 85% by Pheasant Corporation and 15% by Gisela, an individual. Quail Corporation is liquidated in December of the current year pursuant to a plan...
-
LO 2 3 E 2 - 2 9 B . ( Learning Objectives 2 , 3 : nderstanding how accounting works; journalizing transactions ) Green Tree Cellular, Inc., completed the following transactions during April 2 0 X 6...
-
Prepare a risk assessment summary to the Audit Partner identifying ten (10) risks faced by MCC Use the format below to present your findings For each risk identified, clearly describe the risk using...
-
Great Lakes Insurance would like to implement a relational database for both its in-house and outside agents. The outside agents will use notebook computers to keep track of customers and policy...
-
Consider Figure 1-12, which depicts a hypothetical threetiered database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise...
-
Explain why the brown colour of bromine disappears when it is mixed with cyclohexene.
-
8. [1.5 pts] We want to design a plastic bottle. It will have inner diameter d1 and outer diameter d2 so that the thickness becomes t=(d2-d1)/2. The inner diameter is determined as 10 cm. The...
-
The perimeter of the rectangle below is 106 units. Find the value of y. 3y+3 2y | y-0
-
1 . Ameya made 4 0 % of investment in personal business, 2 0 % in stocks and the rest in mutual funds. There are 2 0 % , 1 0 % and 1 5 % of chances in obtaining profit in personal business, stocks...
-
4. We are given the following joint distribution over the random variables A, B, C, and D. Please answer the following questions. Show the necessary tables. You can (and should) share computations...
-
(f) It is hypothesized that for t> 400 s the relation between t and h is of the form where k and n are constants. h=kt (i) Outline how, using a graphical technique, you would verify this hypothesis.
-
The purpose of limiting your scope when planning a writing project is to a. Make your job easier. b. Reduce the number of things you need to think about. c. Make sure your memos are never longer than...
-
Figure displays a 12.0 V battery 3 four uncharged capacitors of capacitances C1 = 4.00F, C2 = 6.00F, and C3 = 3.00F. The switch is thrown to the left side until capacitor 1 is fully charged. Then the...
-
Provide the type and hexadecimal representation of following instruction: sw $t1, 32($t2)
-
Provide the type, assembly language instruction, and binary representation of instruction described by the following MIPS fields: op = 0, rs = 3, rt = 2, rd = 3, shamt = 0, funct = 34
-
Provide the type, assembly language instruction, and binary representation of instruction described by the following MIPS fields: op = 0 x 23, rs = 1, rt = 2, const = 0 x 4
-
explain in excel please For a particular product the price per unit is $6. Calculate Revenue if sales in current period is 200 units. Conduct a data analysis, on revenue by changing the number of...
-
Hall Company sells merchandise with a one-year warranty. In the current year, sales consist of 35,000 units. It is estimated that warranty repairs will average $10 per unit sold and 30% of the...
-
Q 4- Crane Corporation, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost $ 167,270 and have an estimated useful life of 7 years. It can be sold for $...
Study smarter with the SolutionInn App