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...

See similar textbooks

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.