A relational database system for medium-sized airlines to manage airplane inspections, maintenance workflows, spare parts inventory, and analytical reporting.
Database Design Report.pdf – detailed documentation including assumptions, limitations, and schema rationale.
- Inspection-maintenance lifecycle: Track inspections that trigger maintenance tasks.
- Inventory tracking: Monitor spare part usage across workshops.
- Fleet monitoring: Airplane history and real-time availability.
- Analytics: Complex queries for failure rates, costs, workshop performance, employee workload, etc.
| Script | Purpose |
|---|---|
| CREATE.sql | Table definitions |
| INSERT.sql | Sample data population |
| UPDATE.sql | Sample update use cases |
| DELETE.sql | Safe record deletion (all rows) |
| DROP.sql | Schema teardown |
| SELECT.sql | Sample queries for specific business needs |
| TRANSACTION.sql | Sample transaction (failed inspection → book workshop → start maintenance) |