No late submissions will be accepted without prior extension. Hand-drawn diagrams are OK if done very carefully. Follow all diagramming conventions as outlined in the textbook. Make sure your name and email are on the top of every page. Use them to prepare an ER diagram of the airline s operations.
Personnel are important to the airline.
The different classes of employee include pilot, flight attendant and security agent. Each person hired has a unique SSN, a start date, and a name. The system should also track their current salary. In the case of pilots, it must track their total number of flight hours and the number of years flying experience they have had. Flight attendants are qualified to work in certain models of plane.