v1.0.0 — Ethiopian Airlines Flights Database

🛫 v1.0.0 — Ethiopian Airlines Flights Database System

Initial release of the Ethiopian Airlines domestic flight booking database,
developed as a group academic project at Haramaya University.

✅ What's Included

• Complete MySQL schema — 10 normalized tables (up to 3NF)
• Sample data — INSERT statements for all entities
• Advanced queries — reporting and data analysis queries
• Student Discount Module — university ID-based discount logic
• Crew & Aircraft management — crew assignment tracking
• ERD & Database Diagram — visual documentation
• Project Report (PDF) — full design rationale and normalization analysis

🗄️ Tables

Student, Passenger, Airline, Airport, Aircraft,
Flights, Bookings, Discount, CrewMembers, CrewAssignment

🛠️ Tech Stack

• MySQL

🚀 Getting Started

1. Clone the repo
2. Open DB Airlines.sql in MySQL Workbench or DBeaver
3. Run the script on a new database (e.g. DBProject)

---

📅 Date: July 2025
👤 By: Gemachis Tesfaye — Haramaya University, Dept. of Information Science