Flight Reservation Database Project - CSCI 4320, Spring 2020

This document presents a comprehensive solution to the Flight Reservation Database Project, a software engineering assignment focused on database design and implementation. The project involves defining primary, foreign, and secondary keys for tables, linking tables according to an Entity-Relationship Diagram (ERD), and designing input screens, output screens, and queries for data entry, display, modification, and report generation. The solution also includes a user manual for the system and a data dictionary. The database design encompasses tables for passengers, agents, flights, and reservations, with detailed specifications for each table's attributes and relationships. The queries provided cover data manipulation tasks such as updating and retrieving information. The user manual is designed to be accessible to users with limited computer knowledge, while the data dictionary offers a structured overview of the database schema.

Running head: Flight Reservation Database Project
FLIGHT RESERVATION DATABASE PROJECT
Name of the Student
Name of the University
Author Note

1Flight Reservation Database Project
Table of Contents
1- Define the primary keys, foreign keys, and secondary keys for each table........................2
2- Link all tables according to the ERD..................................................................................3
3- Design the input screens, output screens, and queries to:...................................................4
a. Enter data:.......................................................................................................................4
b. Display data.....................................................................................................................5
c. Modify data:....................................................................................................................6
d. Generate Reports:............................................................................................................7
4- User manual:.......................................................................................................................8
5- Data dictionary:...................................................................................................................9
Bibliography:............................................................................................................................12

2Flight Reservation Database Project
1- Define the primary keys, foreign keys, and secondary keys for each
table
PRIMARY key in PASSENGER table:
In passenger table passenger number is primary key.
PRIMARY key in AGENT table:
In agent table primary key is agent number.
PRIMARY key in FLIGHT table:
Flight number is the primary key in this table
PRIMARY keys in RESERVATION table:

3Flight Reservation Database Project
Flight number, passenger number is primary and foreign key in reservation table. Agent
number is the foreign key in this table. Reservation code is also unique key in this table.
2- Link all tables according to the ERD

4Flight Reservation Database Project
3- Design the input screens, output screens, and queries to:
a. Enter data:
PASSENGER TABLE:
AGENT TABLE:
FLIGHT TABLE:

5Flight Reservation Database Project
RESERVATION TABLE:
b. Display data
Display agent data:
Display flight information:

6Flight Reservation Database Project
Display passenger information:
Display reservation information:
c. Modify data:
MODIFY AGENT DATA:
UPDATE AGENT SET AGENT.[AGENT NAME] = "Madre"
WHERE (((AGENT.[AGENT NAME])="WHERE") AND ((AGENT.[AGENT
NUMBER])=14));
MODIFY PASSENGER TABLE
UPDATE PASSENGER, PASSENGER AS PASSENGER_1 SET PASSENGER_1.
[PASSENGER NAME] = "Alerion"

7Flight Reservation Database Project
WHERE (((PASSENGER_1.[PASSENGER NUMBER])="ALER1098"));
MODIFY FLIGHT TABLE:
UPDATE FLIGHT SET FLIGHT.DESTINATION = "AUG"
WHERE (((FLIGHT.[FLIGHT NUMBER])=890));
MODIFY RESERVATION TABLE:
UPDATE RESERVATION SET RESERVATION.[FIGHT DATE] = #2/16/2004#
WHERE (((RESERVATION.[RESERVATION CODE])=289817));
d. Generate Reports:
Reservation report:
Agent report:
Flight report:

8Flight Reservation Database Project
Passenger report:
4- User manual:
This system is usable for any person who has basic knowledge in computer and MS
Access. In the flight reservation database total, four tables are available. Agent, flight,
passenger and reservation table. Agent table can contain most of the information of agents
such as agent number and agent name. only two columns are available in this system. With
the help of “AGENT INSERT FORM,” any person can insert details in this table. “Display
Agent” form can provide every information in this table. Flight is another table in this
database. Flight table contains every essential information of flights. Total five columns are
available in this table. This table can store flight number, origin, destination, depart time and
arrival time. “FLIGHT INSERT FORM” is able to insert values into the flight table. Apart
from the insert form this table also has a display form. With the help of the “Display flight”
form, any person can get every information about flights. Passenger table holds every
information of passengers. Passenger number and passenger name can be store in the
passenger table. With the help of “PASSENGER insert form” any person can insert

9Flight Reservation Database Project
information into the passenger table. “display passenger form” can provide every information
of passenger that is store in the passenger table. Reservation is one of the most important
tables in this database. this table contains every essential information of reservation. A
normal person can easily insert every information by using “RESERVATION INSERT
FORM”. “display reservation” form is also available for view every information of the
reservation table. Apart from these features this database also has several reports. Report is
one of the main features in this database. a person can provide a report to a Higher authority.
There are few medication queries are available. A person can use those queries to update the
information inside of every table.
This database system has been developed for every people. A person who does not
have knowledge in SQL, they can also use this database by using form application. And
report can provide a clear overview of the information. By providing the report any person
can get necessary information of each table.
5- Data dictionary:
Agent Table:
COLUMN_NAME DATA_TYPE NULLABLE KEY
AGENT NUMBER NUMBER NO PRIMARY
KEY
AGENT NAME LONG TEXT YES
Flight table:
COLUMN_NAME DATA_TYPE NULLABLE KEY

10Flight Reservation Database Project
FLIGHT NUMBER NUMBER NO PRIMARY
KEY
ORIGIN SHORT TEXT YES
DESTINATION SHORT TEST YES
DEPART TIME NUMBER YES
ARRIVE TIME NUMBER YES
PASSENGER TABLE:
COLUMN_NAME DATA_TYPE NULLABLE KEY
PASSENGER NUMBER Short Text NO PRIMARY
KEY
PASSENGER NAME Short Text YES
RESERVATION TABLE:
COLUMN_NAME DATA_TYPE NULLABLE KEY
FLIGHT NUMBER NUMBER NO PRIMARY
KEY
FLIGHT DATE DATE/TIME YES
PASSENGER NUMBER SHORT TEXT NO FOREIGN
KEY
RESERVATION CODE NUMBER NO FOREIGN
KEY

11Flight Reservation Database Project
SEAT NUMBER SHORT TEXT YES
AGENT NUMBER NUMBER NO FOREIGN
KEY