A football club has a name a stadium with a playing ground, Ask an Expert

Management Studies

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?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92035221

Have any Question?Write your Review or question?

Related Questions in Operation Management

Imagine that a new person who holds an important position

Imagine that a new person who holds an important position (CEO, department supervisor, etc.) has been hired at your workplace. This information has to be conveyed to a variety of audiences. Think about 3 different groups ...

1 strategic transportation management--pipeline 1explain

1. Strategic Transportation Management--Pipeline 1.Explain the dual nature of pipeline transportation in the U.S. Compare the two common forms of pipeline oil and water by using the elements of a transportation system. 2 ...

Read the case study teloxy engineering aand answer the

Read the case study "Teloxy Engineering (A)"and answer the corresponding questions on the same page.(Atleast 300 words, with 2 APA citations) TELOXY ENGINEERING (A) Teloxy Engineering has received a one-time contract to ...

1 describe a time that you have been an agent for someone

1. Describe a time that you have been an agent for someone else and the way you were granted authority to act on behalf of the principal. If you do not believe that you have acted in such a capacity, describe a common ag ...

Adopting and implementing a policy governance model

"Adopting and Implementing a Policy Governance Model" discusses the mergers of two hospitals with different philosophies of governance. Compare the two philosophies of governance. Explain why the CEO suggested starting w ...

Define outplacement and severance paydistinguish between

Define outplacement and severance pay. Distinguish between transfers and promotions. Define offboarding. Why is it important? What signal might the decision not to fire Bill give to other store managers?

1 describe the evolution of business-to-business b2b

1. Describe the evolution of business-to-business (B2B) e-commerce. 2. How does one determine whether a trial has been speedy? 3. Should the United States move to greater and stricter regulation of multinational business ...

Topic managerial entrenchmentmanagerial entrenchment occurs

Topic: Managerial Entrenchment Managerial entrenchment occurs when managers gain so much power that they can use the firm to further their own interests rather than the interests of shareholders. The shareholders are ess ...

1 in continuous processes bottlenecks are shifting

1. In continuous processes, bottlenecks are shifting frequently. True Or False 2. Cycle time is characteristic of a system while throughput time is associated with a particular job. True or False 3. In services, material ...

1 which of the following best describes the contemporary

1. Which of the following best describes the contemporary book industry? A. Consolidation continues B. Online Booksellers have changed the way books are sold C. The content of books is remarkably varied d. An increasing ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert