Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each of the following pairs of rules, identify two entity types and one relationship. State the cardinality and existence of the relationship in each

For each of the following pairs of rules, identify two entity types and one relationship. State the cardinality and existence of the relationship in each case. If you don't think enough information is available to define either of these, then state an assumption that makes it clear. Draw the ER diagram.

1. A department employs many persons. A person is employed by, at most, one department.

2. A manager manages, at most, one department. A department is managed by, at most, one manager.

3. An author may write many books. A book may be written by many authors.

4. A team consists of many players. A player plays for only one team.

5. A lecturer teaches, at most, one course. A course is taught by exactly one lecturer.

6. A flight-leg connects two airports. An airport is used by many flight-legs.

7. A purchase order may be for many products. A product may appear on many purchase orders.

8. A customer may submit many orders. An order is for exactly one customer.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+ (a) Show that A,(i) is trifling.

Answered: 1 week ago