IBased on the given case scenario, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities and their relationship all entities, relationships (including names) and attributes that are relevant, primary keys identified, and include relationship participation - participation (optional / mandatory) symbols and cardinality. Case Study The following business rules are provided from the description of operations: A customer may request many charter trips. Each charter trip is requested by only one customer. Some customers have not (yet) requested a charter trip. Every charter trip is requested by at least one customer. An employee may be assigned to serve as a crew member on many charter trips. Each charter trip may have many employees assigned to it to serve as crew members. An employee may not yet have been assigned to serve as a crew member on any charter trip. A charter trip may not yet have any employee assigned to serve as a crew member. Each customer may make many payments. Some customers have not made any payments yet. Every payment is made by only one customer. Every payment must have been made by a customer. A payment may be toward many charter trips. Payment may not be in reference to any charter trip. Every charter trip must have a payment made. Each charter trip has only one payment. Every charter trip involves the use of a single aircraft. Every charter trip requires at least one aircraft. An aircraft may be used for many charter trips. An aircraft may not yet have been used for any charter trip. Each aircraft is only one model airplane. Every aircraft has a model designation. An airplane model is not required to be associated with any aircraft that the company owns. The company may own many aircraft of a given model. A given flight assignment may be given to many crew members. Some flight assignments may not have ever been given to any crew member. Every crew member assignment is associated with a flight assignment. Every crew member assignment is associated with only one flight assignment. An employee may have taken many tests. Some employees may have taken no tests yet. A test may be taken by many employees. A test may not have been taken by any employee yet. Each employee has one job with the company. Every employee has only one job with the company. A job may be done by many employees. A job may be currently unfilled and not be associated with any employee. An employee may be a pilot, and every pilot is an employee. A pilot may have earned many ratings. Some pilots have not earned any rating yet. A rating may be earned by many pilots. Some ratings are not held by any pilots. A pilot may have many licenses. A pilot may not have any license yet. A license may be held by many pilots. A license may not be held by any pilot yet. Every employee can have many qualifications. Some employees do not have any qualifications. Each qualification can be held by many employees. Some qualifications are not held by any employee.
IBased on the given case scenario, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities and their relationship all entities, relationships (including names) and attributes that are relevant, primary keys identified, and include relationship participation - participation (optional / mandatory) symbols and cardinality. Case Study The following business rules are provided from the description of operations: A customer may request many charter trips. Each charter trip is requested by only one customer. Some customers have not (yet) requested a charter trip. Every charter trip is requested by at least one customer. An employee may be assigned to serve as a crew member on many charter trips. Each charter trip may have many employees assigned to it to serve as crew members. An employee may not yet have been assigned to serve as a crew member on any charter trip. A charter trip may not yet have any employee assigned to serve as a crew member. Each customer may make many payments. Some customers have not made any payments yet. Every payment is made by only one customer. Every payment must have been made by a customer. A payment may be toward many charter trips. Payment may not be in reference to any charter trip. Every charter trip must have a payment made. Each charter trip has only one payment. Every charter trip involves the use of a single aircraft. Every charter trip requires at least one aircraft. An aircraft may be used for many charter trips. An aircraft may not yet have been used for any charter trip. Each aircraft is only one model airplane. Every aircraft has a model designation. An airplane model is not required to be associated with any aircraft that the company owns. The company may own many aircraft of a given model. A given flight assignment may be given to many crew members. Some flight assignments may not have ever been given to any crew member. Every crew member assignment is associated with a flight assignment. Every crew member assignment is associated with only one flight assignment. An employee may have taken many tests. Some employees may have taken no tests yet. A test may be taken by many employees. A test may not have been taken by any employee yet. Each employee has one job with the company. Every employee has only one job with the company. A job may be done by many employees. A job may be currently unfilled and not be associated with any employee. An employee may be a pilot, and every pilot is an employee. A pilot may have earned many ratings. Some pilots have not earned any rating yet. A rating may be earned by many pilots. Some ratings are not held by any pilots. A pilot may have many licenses. A pilot may not have any license yet. A license may be held by many pilots. A license may not be held by any pilot yet. Every employee can have many qualifications. Some employees do not have any qualifications. Each qualification can be held by many employees. Some qualifications are not held by any employee.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
IBased on the given case scenario, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include:
- Summarise the ERM's components, and names the entities and their relationship
- all entities, relationships (including names) and attributes that are relevant,
- primary keys identified, and
- include relationship participation - participation (optional / mandatory) symbols and cardinality.
Case Study
The following business rules are provided from the description of operations:
-
-
-
-
- A customer may request many charter trips.
- Each charter trip is requested by only one customer.
- Some customers have not (yet) requested a charter trip.
- Every charter trip is requested by at least one customer.
- An employee may be assigned to serve as a crew member on many charter trips.
- Each charter trip may have many employees assigned to it to serve as crew members.
- An employee may not yet have been assigned to serve as a crew member on any charter trip.
- A charter trip may not yet have any employee assigned to serve as a crew member.
- Each customer may make many payments.
- Some customers have not made any payments yet.
- Every payment is made by only one customer.
- Every payment must have been made by a customer.
- A payment may be toward many charter trips.
- Payment may not be in reference to any charter trip.
- Every charter trip must have a payment made.
- Each charter trip has only one payment.
- Every charter trip involves the use of a single aircraft.
- Every charter trip requires at least one aircraft.
- An aircraft may be used for many charter trips.
- An aircraft may not yet have been used for any charter trip.
- Each aircraft is only one model airplane.
- Every aircraft has a model designation.
- An airplane model is not required to be associated with any aircraft that the company owns.
- The company may own many aircraft of a given model.
- A given flight assignment may be given to many crew members.
- Some flight assignments may not have ever been given to any crew member.
- Every crew member assignment is associated with a flight assignment.
- Every crew member assignment is associated with only one flight assignment.
- An employee may have taken many tests.
- Some employees may have taken no tests yet.
- A test may be taken by many employees.
- A test may not have been taken by any employee yet.
- Each employee has one job with the company.
- Every employee has only one job with the company.
- A job may be done by many employees.
- A job may be currently unfilled and not be associated with any employee.
- An employee may be a pilot, and every pilot is an employee.
- A pilot may have earned many ratings.
- Some pilots have not earned any rating yet.
- A rating may be earned by many pilots.
- Some ratings are not held by any pilots.
- A pilot may have many licenses.
- A pilot may not have any license yet.
- A license may be held by many pilots.
- A license may not be held by any pilot yet.
- Every employee can have many qualifications.
- Some employees do not have any qualifications.
- Each qualification can be held by many employees.
- Some qualifications are not held by any employee.
-
-
-
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY