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:
- As an airline, our customers will book flights with us.
- The flights can be explained using flight Number, Flight Type, Home, Destination, and Plane_type
- We also track information about our employee
- Things like their employee number, name, address, and phone number.
- 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
- 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
Get step-by-step solutions from verified subject matter experts
