MGA’s School of Aviation has asked the students of the School of Information Technology to develop a web-based application that solves 2 needs of their program.
• Keep track of maintenance procedures performed on each aircraft
• Allows students and instructors to coordinate aircraft for flying
Currently they have an application that solves both; but it is expensive. Additionally, the abilities for maintaining aircraft are not as flexible as they want it to be and the customer support has proven unhelpful. Attached is a screenshot of the daily flying schedule; which does work well for their needs.
A large drawback in the current maintenance abilities is that it also acts as inventory management. This complicates the procedures and provides a lot of extra overhead to the application they do not desire. A good maintenance ability for them may consist of only 2 parts: 1) a log of procedures performed on each aircraft and 2) display a schedule, similar to the flight schedule, of when procedures will need to be done next for each aircraft.
Deliverables
• An ERD that solves the problems above
• An Access Database that implements the ERD w/ sample data
• Saved SQL queries that demonstrate usage of your DB
• Documentation/presentation that summarizes your ERD/experiences
Deeper Insight to the Flight Schedule
Composite Key: PA-28 161 N281HG:
• PA – refers to Piper Aircraft, a manufacturer - http://www.piper.com/
• 28 – is a family of light aircraft produced by PA
https://en.wikipedia.org/wiki/Piper_PA-28_Cherokee
• 161 – the variant of the family (aka Warrior)
• N281HG – The tail number
Other aircraft in the schedule
• Arrow - http://www.piper.com/aircraft/trainer-class/arrow/
• Archer - http://www.piper.com/aircraft/trainer-class/archer/
• Seminole - http://www.piper.com/aircraft/trainer-class/seminole/
• Citabria -...
No comments