Flight booking system

We’re going to continue working the project to finish the last part o

Flight Booking Systems
Student Name: Awadh Almesri
UMl Diagram
Database tables
Database tables:
CREATE TABLE Flight {
Flight number int PRIMARY KEY AUTOINCREMENT,
Airline varchar (255),
From_ID varchar (255),
To_ID String,
DepartureTime Time,
DepartureDate Date,
ArrivalTime Time,
ArrivalDate Date,
Capacity Int,
EconomyPrice Double,
BusinessPrice Double
};
CREATE TABLE User {
ID Int PRIMARY KEY AUTOINCREMENT,
Username varchar (255),
Age int,
CreditCard_ID int,
PhoneNumber varchar (255)
};
Create Tabel Passenger {
PassengerName varchar (255),
PassengerAge varchar (255)
};
CREATE TABLE Ticket {
Ticket_ID varchar (255) PRIMARY KEY AUTOINCREEMENT,
Flight_Number int,
UserName varchar (255),
Dateof Purchase Date,
Reservation_ID varchar (255),
Seat_Number varchar (255),
Maximum_kg Double,
Type_of_Ticket varchar (255),
Price Double,
FOREIGN KEY username references User(username)
};
CREATE TABLE Reservation {
Reservation_ID varchar (255),
ReservationDate date,
};
CREATE TABLE Payment{
CreditCard_ID int;
UserNAme varchar (255),
FOREIGN KEY username references User(username)
};
CREATE TABLE city {
ID varchar (255) PRIMARY KEY,
Name varchar (255)
};
User Interface design
Resources to help with completing T4 Report
(there are plenty more available online)
User Documentation (already shared with you)

How to Build the Best User Manual

Ultimate Guide to write instruction for User Manual

Save Time On Research and Writing

Hire a Pro to Write You a 100% Plagiarism-Free Paper.

Get My Paper

What is System Documentation?
https://www.lawinsider.com/dictionary/system-documentation
Features, Purpose and Contents of System
Documentation
https://www.yourarticlelibrary.com/management/mis-management/systemdocumentation-features-purpose-and-contents-mis/70408