SQL - Airport Database

5th homework for DUMP Internship

Description

This database provides all the important possibilities for maintaining the airport system. Most important functionalities include buying tickets, searching for flights and organizing the flights.

This project was built in PostgreSQL management system.

Usage

1. Clone the repository

git clone https://github.com/SimeJadrijev/Internship-5-AerodromDB.git

2. Create a new empty database using pgAdmin

3. Run SQL scripts in this order:

3.1. - Airport tables query.sql
3.2. - Airport seed.sql
3.3. - Airport constraints.sql
3.4. - Airport triggers.sql
3.5. - Airport queries.sql