Assignment Financil Management
- 2127 Words
- 9 Pages
- Report
Assignment financil management
Assignment financil management
Task1
Icarus Airlines require a Database System to be set up to handle passengers booked onto flights. The ACCESS 2003 database will be used to record details of passengers and flights operated by the airline. It can also be used to record details of the bookings made by passengers onto flights. Identify three tables which need to be created.
Required:
a) Suggest and create fields (name, type and size) for these three tables using the ACCESS database package. Enter sample records (at least 5) for each table and print the results.
(15 marks)
Answer to Question 1 (a):
These three tables were aimed at collecting information of the payment and revenue of the organization, the passenger or customer of the organization and the services provided by the organization in terms of flight plans and offerings. The construction of table was based on general information that is to be associated with an airline industry and thus, may not be actual. However, the concept upon which these tables were constructed is clear and concise in terms of the process of airline industry and the possible required information, which essentially should be collected by Icarus Airlines to ensure that it has a good grip over its passengers, flight schedules as well as the revenue it is earning by providing the travel services. The three tables created for the purpose of feeding in data regarding the Icarus Airlines included the Flight Info table, the Passenger Info table and the Payment Info table. The three tables were constructed as per requirements and 10 records were entered as samples. These three tables are provided on the nest page, which include the 'design view' as well as the 'datasheet view':
Flight Info Table
Flight Info
Flight ID
Flight Plane
Flight Departure Time
Flight From
Flight To
Expected Arrival Time
Flight Seat Number
Ticket Number
Travel Class
TAS-2390
Airbus 320
9:45:00 PM
Cambridge
Birmingham
1:30:00 AM
SJ-897
5674-965-266
1st Class
TEG-5245
Boeing 757
9:32:00 AM
Nottingham
London
6:50:00 AM
SL-986
9676-426-797
1st Class
TEJ-1411
Boeing 747
3:30:00 AM
London
Coventry
1:50:00 AM
SM-765
7967-297-967
1st Class
TER-5274
Airbus 321
4:50:00 AM
Birmingham
Bradford
11:05:00 PM
SU-865
9679-722-979
Business
TIO-6766
Boeing 747
6:35:00 AM
Nottingham
Derby
10:30:00 PM
SM-786
4697-946-774
Business
TPO-6371
Airbus 320
10:23:00 AM
Derby
Canterbury
2:45:00 AM
SU-756
6422-964-964
Business
TSN-2348
Boeing 747
11:45:00 PM
Coventry
Nottingham
2:45:00 AM
SH-321
6462-464-646
Business
TUT-3418
Airbus 318
9:05:00 PM
Bradford
Birmingham
9:05:00 PM
SE-467
2497-984-626
Business
TWS-9876
Boeing 777
11:30:00 PM
Liverpool
Canterbury
6:30:00 AM
SJ-789
8642-964-564
1st Class
TZS-2394
Boeing 737
12:45:00 PM
Leicester
London
2:45:00 AM
SK-897
2456-462-496
Business
Passenger Info Table
Passenger Info
Passenger ID
Passenger First Name
Passenger Last Name
Passenger Age
Passenger Gender
Passenger Passport Number
AGT-1234
John
Mc Cullum
45
Male
925665416
ASK-6445
James
Jackman
24
Male
924168453
CGT-0123
George
Anderson
35
Male
924568451
GHT-8762
Laura
Dickens
48
Female
924585216
GYJ-2543
Jessica
Taylor
20
Female
924158515
KJT-8651
Jack
Simpson
31
Male
924575615
SDJ-4561
Josephine
Parker
36
Female
924784561
SFG-2378
Mary
Jackson
21
Female
924521844
STR-4521
Catherine
Jones
25
Female
925864521
YSA-4416
Edward
Johnson
28
Male
924587126
Payment Info Table
Payment Info
Payment ID
Passenger ID
Flight ID
Payment Mode
Cheque Number
Payment Amount
Payment Date
Payment Month
Payment Year
131264
KJT-8651
TZS-2394
Cheque
5641645641
5300
08-Feb-12
February
2012
156746
AGT-1234
TAS-2390
Cash
4500
11-Jan-12
January
2012
312134
GHT-8762
TER-5274
Cheque
4146346464
5100
24-Feb-12
February
2012
312416
YSA-4416
TPO-6371
Cheque
6341967486
4600
17-Feb-12
February
2012
341654
SDJ-4561
TWS-9876
Cash
4200
18-Jan-12
January
2012
413541
CGT-0123
TEJ-1411
Cash
5200
26-Jan-12
January
2012
416616
SFG-2378
TUT-3418
Cheque
6346346036
4900
14-Jan-12
January
2012
631464
ASK-6445
TEG-5245
Cash
4200
13-Dec-11
December
2011
654645
GYJ-2543
TIO-6766
Cash
4800
08-Dec-11
December
2011
731464
STR-4521
TSN-2348
Cheque
3210534034
5500
10-Dec-11
December
2011
b) Create two suitable queries, by linking two or more tables, which will be useful to the airline.
(15 marks)
Answer to Question 1 (b):
The querries are building for the purpose of linking two or more tables together and extracting meaningful fields so that they can be presented in a form or report. The querries are also used for the purpose of calculations. Two querries have been constructed in this assignment which is, Complete Passenger Flight Info and Passenger Payment Info. Both these querries are provided below including their 'design view' as well as the 'datasheet view':
Complete Passenger Flight Info
Complete Passenger Flight Info
Passenger ID
Flight ID
Passenger First Name
Passenger Last Name
Passenger Age
Passenger Gender
Passenger Passport Number
Flight Plane
Flight Departure Time
Flight From
Flight To
Expected Arrival Time
Flight Seat Number
Ticket Number
Travel Class
KJT-8651
TZS-2394
Jack
Simpson
31
Male
924575615
Boeing 737
12:45:00 PM
Leicester
London
2:45:00 AM
SK-897
2456-462-496
Business
AGT-1234
TAS-2390
John
Mc Cullum
45
Male
925665416
Airbus 320
9:45:00 PM
Cambridge
Birmingham
1:30:00 AM
SJ-897
5674-965-266
1st Class
GHT-8762
TER-5274
Laura
Dickens
48
Female
924585216
Airbus 321
4:50:00 AM
Birmingham
Bradford
11:05:00 PM
SU-865
9679-722-979
Business
YSA-4416
TPO-6371
Edward
Johnson
28
Male
924587126
Airbus 320
10:23:00 AM
Derby
Canterbury
2:45:00 AM
SU-756
6422-964-964
Business
SDJ-4561
TWS-9876
Josephine
Parker
36
Female
924784561
Boeing 777
11:30:00 PM
Liverpool
Canterbury
6:30:00 AM
SJ-789
8642-964-564
1st Class
CGT-0123
TEJ-1411
George
Anderson
35
Male
924568451
Boeing 747
3:30:00 AM
London
Coventry
1:50:00 AM
SM-765
7967-297-967
1st ...