Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions: Please draw an entity relationship diagram that is reflective of the following business rules: A pilot is employed by one and only one

Instructions: Please draw an entity relationship diagram that is reflective of the following business rules:

· A pilot is employed by one and only one airline.

· An airline employs one or many pilots.

· A pilot can fly one or many airplanes.

· An airplane can be flown by zero or many pilots.

Show entity names, relationships between the entities and cardinalities. Please make sure that you eliminate any many-to-many relationships that may exist.

Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

ANSWER A A pilot is employed by one and only one airline There are two kinds of ER diagrams conceptu... 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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

10th Edition

1119491630, 978-1119491637, 978-0470534793

More Books

Students also viewed these General Management questions