What factors were considered for choosing entity-attribute

Assignment Help Operation Management

Reference no: EM131280517

A football club has a name, a stadium with a playing ground, and a team made up of players. A player can play for only one club. Each team is managed by a manager, represented by his name. A player has a registration number, name and age. A club manager also buys players. Each club plays against each other club in the league and matches have a date, stadium venue and score.

a) Draw an ER diagram to represent the case above.

b) Discuss how you managed the following:

What factors were considered for choosing entity, attribute and relationship for the above scenario?

Is a club manager the same as a team manager?

How did you represent the ‘league’ in the diagram?

Reference no: EM131280517

Questions Cloud

Job assignments for high-potential employees are based : In the case of succession planning, job assignments for high-potential employees are based on: An organization may demote an employee to a lower-level position: to increase the employee’s visibility.

Most likely reason behind this step taken by the supervisor : Beatrice works at a power tool distributor company. Most of her colleagues are men. Several of her coworkers hang calendars of partially nude women around the warehouse. The supervisor finally asks everyone to remove such materials permanently. The m..

Industrial chemicals that has six manufacturing facilities : Consider now a producer of industrial chemicals that has six manufacturing facilities S1, S2, …, S6, from which it ships its products to six regions in the country with respective demands D1, D2, …, D6. The supply-demand setting appears to be quite b..

Annual revenues to franchisor annually for advertising : The variable cost of a burger meal is 50 cents, the revenue of a burger meal is $1.00. Your fixed costs are $200,000 a year. You also need to give 5% of your annual revenues to the franchisor annually for national advertising. You need to make 22% an..

What factors were considered for choosing entity-attribute : A football club has a name, a stadium with a playing ground, and a team made up of players. A player can play for only one club. Each team is managed by a manager, represented by his name. What factors were considered for choosing entity, attribute a..

Explain three benefits of decentralized decision making : The traditional way for company to go international is to have centralized headquarters in the home country with hierarchical and often bureaucratic decision making processes. Identify and explain three benefits of decentralized decision making. Disc..

Positive long-term benefits for both a company and society : Explain the concept of CSR and how it can have positive long-term benefits for both a company and society. Is global marketing more challenging than single country marketing? In a brief essay, explain why or why not.

How do markets allocate resources : How do markets allocate resources? How do taxes affect market outcomes? How do the effects depend on whether the tax is imposed on buyers or sellers? Explain the answer with the help of graphs.

If production process is in statistical control : If a production process is in statistical control, which of the following statements is incorrect. Define and explain the following terms: System; Process flow analysis; Bottleneck; BPR; Throughput time; Capacity of a system; Process flowcharting; Pr..

User Account

All Pages