Question: Read carefully through the situations described and develop an ERD that would fully address each portion of this situation. You should be able to create

Read carefully through the situations described and develop an ERD that would fully address each portion of this situation. You should be able to create the entities, attributes, and relationships with proper cardinalities from reading this scenario. Be sure to include all primary keys (pk) and foreign keys (fk) as well as appropriate data types.

Basic Diagramming (5 Points)

Problem described:

  1. As an airline, our customers will book flights with us.
    1. The flights can be explained using flight Number, Flight Type, Home, Destination, and Plane_type
  2. We also track information about our employee
    1. Things like their employee number, name, address, and phone number.
  3. Each customer must book a flight with the assistance of an employee, but if a customer would like, they can use our kiosk to book the flight without an employee
  4. We must keep track of the customers, the booking, and our employees with whom the customer was working with

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!