Project A: Airways Information System Overall description: Your team is employed by an airways company for the implementation and delivery of a computer system responsible for a large part of the operation of the company. Customer specifications: The system must be able to store the planes, flights and passengers of the company during the years of its operation. There are two types of planes, P62 and P124, with rectangular arrangements of 62 and 124 seats, respectively. The sources and destinations of the currently available flights of the company (for simplicity, assume only direct flights) are allocated from a set of city airports which can be potentially extended. The different passengers can be allocated to specific flights and seats. The system should be able to provide functionality to the different users listed below: o A database administrator who can include new flights, prices, dates, airports and perhaps new planes for each of the two available types. o A ticket agent who can flexibly search for a specific flight inquired by a customer. When the customer reserves or books a ticket, then the required details must be stored. Such information includes flight ID, payment details, expiration date of reservation, route, allocated seat, viewing facilities of the seating plan, etc. Facilities to amend this information must be provided. o A manager who can retrieve statistics about the companys operation, such as the number of planes for each type, total passengers per flight, total revenue, etc.

Project A: Airways Information System Overall description: Your team is employed by an airways company for the implementation and delivery of a computer system responsible for a large part of the operation of the company. Customer specifications: The system must be able to store the planes, flights and passengers of the company during the years of its operation. There are two types of planes, P62 and P124, with rectangular arrangements of 6x2 and 12x4 seats, respectively. The sources and destinations of the currently available flights of the company (for simplicity, assume only direct flights) are allocated from a set of city airports which can be potentially extended. The different passengers can be allocated to specific flights and seats. The system should be able to provide functionality to the different users listed below: o A database administrator who can include new flights, prices, dates, airports and perhaps new planes for each of the two available types. A ticket agent who can flexibly search for a specific flight inquired by a customer. When the customer reserves or books a ticket, then the required details must be stored. Such information includes flight ID, payment details, expiration date of reservation, route, allocated seat, viewing facilities of the seating plan, etc. Facilities to amend this information must be provided. A manager who can retrieve statistics about the company's operation, such as the number of planes for each type, total passengers per flight, total revenue, etc