Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Provide a complete entity relationship diagram (in crow's foot notation) for the following system that shows the entities, identifiers, attributes, and relationships. Be assumptions
1. Provide a complete entity relationship diagram (in crow's foot notation) for the following system that shows the entities, identifiers, attributes, and relationships. Be assumptions you are making. Document any cardinality constraints that are not in the diagram. Wingz Aviation operates charter flight services and need a system to track its personnel, aircraft, and flights. The company stores the name, employee number, phone, and hire date of each employee. The company has 10 planes, several each of three types of models. It employs 25 pilots. The company tracks the weight, fuel capacity, and number of seats on each aircraft. The company modified some planes so that two of the same model plane may have different numbers of seats. Each aircraft has a unique registration number. The company tracks the number of hours each plane has flown. Each pilot has one or more FAA certifications. For example, a certification may allow a pilot to be the copilot on a jet, and another certification might allow a pilot to be the lone pilot on a prop plane. Every flight requires a pilot be designated as captain. Some flights require a pilot to serve as a copilot. The number of passengers a plane can carry varies from 2 to 25. Wingz must keep a record of aircraft maintenance per FAA regulations. The system must record the date, time, location, type of maintenance, and person responsible for performing the maintenance. The company employs 4 mechanics. The system should be able to show what pilot(s) flew on each flight, how many hours each plane was in operation, when maintenance was performed on each plane, how many passengers were on each flight, the destination for each flight, what certifications each pilot holds, and how many hours each pilot has flown
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started