Airport Management System

Introduction

The Airport Management System is designed to manage airport operations through a robust database system efficiently. It features an ER diagram for system design, transformed into a relational model with 10 SQL tables, ensuring data integrity and reducing redundancy.

Features

• ER Diagram: Visual representation of database relationships.
• Relational Model: Structured schema based on industry standards.
• Data Integrity: Normalization processes to minimize data redundancy.
• SQL Tables: 10 relational tables populated with real-world operational data.
• Database Operations: Comprehensive SQL queries for data manipulation and reporting.

Getting Started

Follow these instructions to set up and run an Airport Management System project on your local machine.

Prerequisites

• SQL Server or any SQL-based Database Management System.
• Understanding of ER diagrams and relational databases.

Installation

1. Clone the repository:

   git clone https://github.com/kushalpatel0265/Airport-Management-System.git

2. Import the SQL schema and data files provided into your database system.

Usage

1. Start your SQL database server.
2. Connect to the database using provided SQL scripts to perform operations like queries, updates, and deletions.
3. Use the system to manage airport operations including flights, employee data, and ticket bookings.

Contributing

Contributions to this project are welcome! Please fork the repository and submit a pull request with your features or corrections.

License

Distributed under the MIT License. See LICENSE for more information.

Contact

• Gmail: kushalpatel0265@gmail.com
• Project Link: https://github.com/kushalpatel0265/Airport-Management-System