Identify the degree and cardinalities of the relationship

Assignment Help Operation Management

Reference no: EM131039551

For each of the following descriptions:

a. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists.

b. A vendor builds multiple types of tablet computers. Each hs a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.

perform the following tasks:

1. Identify the degree and cardinalities of the relationship.

2. Express the relationships graphically with an E-R diagram.

Document your work into a single, well-organized, well-written word document and submit no later than due date.

Reference no: EM131039551

Questions Cloud

Develop to assist hiring managers in the interview process : As a Human Resources (HR) manager, you have noted an extremely low number of women currently at any level of management within the company. What actions could you take to increase the number of female new hires? What specific programs/initiatives cou..

Principles of economy-of-scale and economy-of-distance : Compare and contrast the transport principles of economy-of-scale and economy-of-distance. Illustrate how they combine to create efficient transportation. Discuss and illustrate the economic justification for establishing a warehouse. When is most su..

Service times are exponentially distributed : A department store has a candy counter with one employee. Customers arrive at the counter at the rate of 40 per hour according to a Poisson distribution. The employee can handle 45 customers per hour and service times are exponentially distributed. T..

Ethics and decision making : Isabel Arnett was promoted to chief executive officer (CEO) of Tamik, Ic., a pharmaceutical company that manufactures a vaccine called Kafluk, which supposedly provides some defense against bird flu. The company began marketing Kafluk throughout Asia..

Identify the degree and cardinalities of the relationship : A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. Identify the..

Discuss the importance of integrating sales and operations : Discuss the importance of integrating sales and operations. This idea of integrated management is indeed a key tenet of supply chain and operations management practices today. Summarize the ways through which sales and operations planning can be inte..

How many units will he need to sell to breakeven : Jay White sells handmade decorations. He had to purchase specialized equipment for $4000 and buy a retail license for $1000. It cost Jay $125 in time and materials to make each item. He expects to sell each decoration for $150. How many units will he..

Promises to pay claims from covered risks : An insurance policy, for an up-front fee, promises to pay claims from covered risks, if loss occurs within a specified time. The policyholder must notify the insurer for the policy to pay. The policy is subject to a deductible and a limit.

Which of the big five personality traits commonly : Report on relevant organizational design issues and get specific examples of how managers implement oB in their organization. Which of the Big Five personality traits commonly used by modern managers? Which of the Big Five personality traits do you c..

User Account

All Pages