Question: For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary

For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship. Based on your description for this example, do you think it is always clear simply from an E-R diagram what the business rule is that results in certain cardinalities? Justify your answer.

Figure 2-12a

Is Married To Stands After Manages PERSON EMPLOYEE TEAM One-to-one One-to-many One-to-one

Step by Step Solution

★★★★★

3.33 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Presently the cardinality is onetomany One possible scenario is an employe... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1588).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

The file FdiCBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The Pivot- Table should group the...

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...

The Is Married To relationship in Figure 2-12a would seem to have an obvious answer in Problem and Exercise 2-33dthat is, until time plays a role in modeling data. Draw a data model for the PERSON...

Describe customer relationship management (CRM) and its role in supporting business operations.

For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship. Based on your description for...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

This chapter presents students and early career executives with a sound understanding of theory. Theory is explored in terms of both anatomy (parts of the whole) and physiology (relationships with...

MGT 3090 Prof. Si Ahn Mehng Conflict Styles Inventory Instructions: The Conflict Styles Inventory consists of eight common community conflict situations. After reading each situation, you will need...

What are the types and purpose of service level agreements?

If $200 is deposited in a savings account at the beginning of each of 15 years, and the account draws interest at 7% per year, how much will be in the account at the end of 15 years?

Question 2 A t which point i s the following linear programming problem minimized Minimize: z = 4 x + 3 y Subject t o : , x + y 1 0 3 x + 2 y 2 4 x 0 , y 0 ( 2 , 6 ) ( 0 , 1 0 ) ( 5 , 0 ) ( 4 , 6 )

The Windshield People repair chips in car windshields in the companys home county. Rocky Chip, the owner, incurred the following operating costs for the month of February 2012: Salaries and wages . ....

Natalia Wallace is the new controller for Smart Software, Inc., which develops and sells education software. Shortly before the December 31 fiscal year-end, James Cauvet, the company president, asks...

What are some differences between financial and managerial accounting?

Figure gives the magnetization curve for a paramagnetic material. The vertical axis scale is set by a = 0.15, and the horizontal axis scale is set by b = 0.2 T/K. Let sam be the measured net...

Write down the expression for the radial distribution function of a 3p electron in a hydrogenic atom and determine the radius at which the electron is most likely to be found.

The 2000s were a period of low rainfall in eastern Australia. One report (The Economist 2003) described how the mouth of the Murray River, Australias main river, had dried up for only the second time...

Visit www.teradatauniversitynetwork.com and use the various business intelligence software products available on this site. Compare the different products based on the types of business intelligence...

What is the role of YARN in the management of highly distributed systems?

Describe and explain the two main components of MapReduce.

The following three defense stocks are to be combined into a stock index in January 2013 (perhaps a portfolio manager believes these stocks are an appropriate benchmark for his or her performance):...

Given the following demand data, Perlod Demand 1 56 52 56 51 5 57 Book a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for...

Enter the Current and Long - Term portions of the following loan Loan Received a $ 3 6 , 0 0 0 loan payable in equal ( i ) Incorrect. Try again. SUBMIT instalments over the next 3 years.