AirGo is a relational database system that models and manages the core operations of an airline company. It centralizes data about flights, aircraft, pilots, and cabin crew, ensuring consistency, scalability, and efficient access through a normalized schema.
Developed as part of the Informatics Certification at Liceul Teoretic “Avram Iancu”, Cluj-Napoca (2024), this project demonstrates solid understanding of SQL database architecture and data modeling principles. The goal was to create a production-like database structure capable of supporting typical airline data workflows.
Relational schema design with strong referential integrity
Entity–Relationship (ER) modeling for logical data organization
Normalization (up to 3NF) to minimize redundancy
Constraint management (PRIMARY KEY, FOREIGN KEY, CHECK, NOT NULL)
Data manipulation using standard DDL and DML SQL operations
The system models several interrelated entities:
PILOT – manages pilot data and flight experience
STEWARDEZ – stores cabin crew information
AVION – holds aircraft specifications and maintenance details
CURSA – defines flights and their scheduling
DISTRIBUIRE1 – links pilots and copilots to flights
DISTRIBUIRE2 – assigns stewardesses to each flight
Oracle SQL / SQL Developer – database design and implementation
ER Diagram Modeling Tools – schema visualization and analysis
Oracle Academy educational framework – academy.oracle.com
Logical and normalized airline database design
Realistic relationships between flights, staff, and aircraft
Enforced data consistency through constraints
Example queries for management, reporting, and analysis
Lușcă Vlad Project coordinated by Prof. Cristina Lupșa April – May 2024