Airport Database

Airport Database is a project designed to store, organize, and retrieve essential information about airports, flights, and airline operations. This project simulates an airport management system with a focus on managing data for airplanes, airports, flights, airlines and passengers records in an organized and efficient way.

This project is structured to showcase the foundational aspects of an airport management system, allowing users to interact with a range of data points crucial for airport operations. By maintaining organized records for airplanes, airports, flights, airlines, and passengers, the database enables streamlined data retrieval and management of essential information.

Built With

This database is based on technology like below:

• Microsoft SQL Server

Features

✅ Comprehensive Airport Management: Includes tables for storing and managing data about airplanes, airports, flights, airlines, and passengers, offering a broad view of airport and airline operations.

✅ Flight Scheduling and Details: Manages and organizes information on flight schedules, departure and arrival times, destinations, and associated airlines.

✅ Airline Information Management: Maintains data on airlines, including airline codes and associated flights, enabling an organized approach to airline management.

✅ Passenger Records Management: Stores and updates detailed passenger records, allowing for efficient passenger tracking and reservation management.

✅ Data Validation and Consistency: Enforces relational database constraints to maintain data accuracy and integrity across tables.

✅ Automated Backup and Restore Management: Includes configuration for daily and weekly automated database backups, ensuring data is consistently safeguarded.

✅ Database Mail and Alert System: Configures Database Mail and alert notifications for SQL Server Agent, enabling administrators to monitor and receive real-time alerts about job statuses.

Prerequisites

Before starting, ensure that the Microsoft SQL Server is installed on your system.

• Follow the installation guide to download, install and set it up correctly.
• Verify your SQL Server installation by launching SQL Server Management Studio (SSMS) and connecting to your SQL Server instance.

Installation

1. Clone or download the repository to your local machine:

   git clone https://github.com/ndriqimlahu/airport-database.git
   

2. Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
3. In SSMS, restore the database:
   • Right-click on Databases in the Object Explorer.
   • Select Restore Database... option.
   • Navigate to the repository folder on your local machine.
   • Choose the Airport_Database.bak file from the FinalProject folder.
   • Follow the prompts to complete the restoration.
4. Once restored, verify that the Airport database is visible under Databases in SSMS and ready for use.

Screenshots

Below you can see some additional useful screenshots of what the database looks like and how it can be used:

• Connection of tables with Diagram

• Creation and selection of VIEW

• Execution and selection of STORED PROCEDURE

• Creating the Audit table

• Creating the TRIGGER

• Updating and selection of the table

• Creating a Backup Job

• Setting the time to perform the Job

• Mail Database Configuration (Step 1)

• Mail Database Configuration (Step 2)

• Mail Database Configuration (Step 3)

• Mail Database Configuration (Step 4)

• Alert System for SQL Server Agent

• Creating Job Step (Step 1)

• Creating Job Step (Step 2)

• Job Steps are created

• Creation of Alert

• Creation of Operator

• Operator is created

• Creation of Error Alert through Email

• Alert is created

• Notification via email

• Job starts successfully

• Job completed successfully and email sent

• Backup completed successfully

Support

If you find this project useful, please consider giving it a star!