Scribd
Upload
45 views3 pages

Course Work 2

A-lite airlines needs a database system to track flights, passengers, destinations, and related information to address delays. The database should include flight details like number, arrival/departure times. It should store passenger details like name, DOB, address, and unique ID. Aircraft assigned to flights need details on model, make, and capacity. Airports in the database require code, name, city, and state. Staff records need name, ID, job title, salary, and address. Tickets sold by staff need number, date, and time.

Uploaded by

Ricardo Knight
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
45 views3 pages

Course Work 2

A-lite airlines needs a database system to track flights, passengers, destinations, and related information to address delays. The database should include flight details like number, arrival/departure times. It should store passenger details like name, DOB, address, and unique ID. Aircraft assigned to flights need details on model, make, and capacity. Airports in the database require code, name, city, and state. Staff records need name, ID, job title, salary, and address. Tickets sold by staff need number, date, and time.

Uploaded by

Ricardo Knight
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Course Work 2

Database Management
Ricardo Knight
Andre Richie
Course Code: CSYS4804
Lecturer: Ms. L. Walker
Date: July 6, 2016
Portmore Community College

A-lite airlines has a fleet of 4 aircrafts, a Boeing 74-7, Boeing 787, Airbus A50 and Airbus A380.
A-lite has recently noted that they are not keeping proper records and as such has contributed to
delays in travel time. You have been employed by the company to create a database system that
will assist them in keeping a track of the airlines flights, passengers and destinations. Each flight
must have a flight number along with the arrival and departure time. Details about the passenger
such as their name, date of birth, sex, address, TRN, email and telephone should also be kept.
Each passenger must have a unique id number. Aircrafts that are assigned to flights should have
the model, make and capacity of the craft. Flights arrive at specific airports and these records
should include airport code, name, city and state they are located in. Staff records should be kept
with their name, id number, telephone, job title, salary and address. Staff will also issue tickets to
passengers, these tickets will contain the ticket number, date and time.

Entity Relationship Diagram

Staf

Issue

Sold

Passeng
er

Ticket

Travel on

Arrive at

Airport

Air_craf
t

You might also like