AVIACO Database System

Project Overview

This project implements a relational database and data warehouse system for an aircraft charter company.

The system was designed to store, manage, and analyze operational data related to aircraft operations, bookings, and company activities.

---

Objective

The goal of this project is to design a structured database system capable of handling operational and analytical data for an aviation company.

The project demonstrates principles of:

• Relational database design
• Entity-Relationship modeling
• SQL query development
• Data warehousing concepts

---

System Description

The database models different aspects of the airline charter business, including:

• Aircraft information
• Flight operations
• Customer bookings
• Company operational data

The system includes both transactional data storage and elements of data warehouse analytics.

---

Tools & Technologies

• MySQL
• SQL
• Relational Database Design
• ER Modeling
• Data Warehouse Concepts

---

Methodology

The database design process included:

1. Requirement analysis
2. Entity-Relationship (ER) modeling
3. Schema design
4. SQL query implementation
5. Data analysis queries

The database structure ensures data integrity, consistency, and efficient query performance.

---

Database Design

Final Entity-Relationship Diagram

This diagram shows the final relational structure of the AVIACO database, including entities such as aircraft, charter flights, customers, and employees.

---

Database Schema

The schema illustrates table relationships and foreign key constraints used to maintain data integrity within the system.

---

Initial Design Concept

This diagram represents an earlier stage of the database design before the final schema was implemented.

---

Results

The final system includes a structured relational database capable of storing operational aviation data and supporting analytical queries.

The project demonstrates how database systems can support business operations and decision-making.

---

Project Structure

aviaco-database-system
│
├── database_schema
├── sql_queries
├── documentation
└── README.md

---

How to Run

1. Import the SQL schema into MySQL

2. Execute the SQL scripts to create tables and relationships

3. Run analytical queries to explore the dataset

---

Future Improvements

• Expand the data warehouse structure
• Add more advanced analytical queries
• Build a dashboard for operational analytics
• Integrate with business intelligence tools