Foreign keys-verbs that represent relationship

Assignment Help Operation Management

Reference no: EM132215999

Create the following ERDs in LucidChart

Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules.

Teams have many players, but teams cannot exist without players. A player may only play on one team.

Each course may require a textbook and may require several textbooks. A textbook is used in one course only.

A company my hire several consultants or may not hire any. A consultant may work for many companies at the same time, but usually works for couple.

A doctor may examine many patients at a hospital. A patient may see many different doctors at the hospital.

An employee may be in several work groups but doesn’t have to be a part of any. Each work group needs at least one employee.

Reference no: EM132215999

Questions Cloud

Difference would it make to business or individual consumer : What difference would it make to a business or and individual consumer if Apple, Google, or Facebook dominated the Internet experience.

Determine the order quantity that will minimize total cost : Determine the order quantity that will minimize total cost.

Focus on yield management : Why is it important for many firms to focus on yield management?

What are the air toxins : What are "air toxins" and where do you think you are most likely to be exposed to them; and what steps can you take to minimize your exposure? 200-250 words.

Foreign keys-verbs that represent relationship : Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship,

How many machines should the company buy initially : How many machines should the company buy initially? what is expected payoff for this alternative?

What role does communication play in these five steps : Briefly summarize a situation that required change that exemplifies the element of persuasion you identified as the most important.

Samuel and grace in making their purchasing decision : what specific information about the different makes and models is the most relevant to Samuel and Grace in making their purchasing decision?

Create Work Breakdown Structure for eBook project : Create a Work Breakdown Structure for an eBook project, using a PowerPoint hierarchical structure chart or word outline format.

User Account

All Pages