/Airport_Project

This is a collaborative Project we undertook using Python and SQL databases.

Primary LanguagePython

Airport Project

This is the a project set over the course of 3 days. Using the assigned user-stories we are to complete a program that is capable of carrying out each of their requests, following a definition on done.

The Team

Name Position X
John Byrne Developer 🐛
Sohaib Sohail Developer 🚚
Max Palmer Developer 💥

User Stories

The to do list in terms of user stories :

  • As an airport assistant I want to be able to create passengers with name and passport number, so that I can add them to the flight.
  • As an airport assistant I want to be able to create flight_trip with specific destination
  • As an airport assistant I want to be able to change flight trip details, if someone wanted to extend their departure date etc. Use a password.
  • As an airport assistant, I want to be able to add passengers to flight_trip, so that I can sell tickets.
  • As a flight attendant I want to generate a flight attendees list.

Our Kanban Board

Find the Board HERE

Entity Relationship Diagram from our Airport Database

image info

Description

This is an Entity Relationship Relationship, it is the first process in the creation of what is known as a Relational database, an extremely common practice among database developers as it allows the tables to be linked via specific relationships which link certain values in one to to some in others.

Types of Relationships

There are three main types of relationships:

  • One-to-Many
  • One-to-One
  • Many-to-Many (Converted to Conjunction)

Flow Chart of Airport Program

The project Structure

image info

This shows the flow of the program as it is interacted with by the user.