Preview

Airlin reservation database project

Satisfactory Essays
Open Document
Open Document
710 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Airlin reservation database project
CLASS ASSIGNMENT PROPOSAL.
Airline resrevation Database management system
Description of the database system.
Airline reservation database management system will provide features for both costumers of the company and the company itself. Database system will meet almost all needs of an airline company. It will be possible for costumers to make reservations, buy ticket, see and manage old reservations etc. All of these will be held in the database. In Airline Company Database Management System, there are various entities required such as planes, cities, airports, flights, customers, reservation and system user.

Tables of different databases that make up the system.

1. Table name: AIRBUS

Fields
Data Type
Size
Airbusno
AutoNumber
(5)
First_cap
Number
(3)
Bus_cap
Number
(3)
Eco_cap
Number
(3)
First_wl_cap
Number
(3)
Bus_wl_cap
Number
(3)
Eco_wl_cap
Number
(3)

2. Table name: CUSTOMER

Fields
Data Type
Size
name
Text
(7)
Phone_no
Number
(12)
address
AutoNumber
(8)
ID_no
Number
(8)
Date of dep
Number
(8)

3. Table name: CANCELLATION

Fields
Data Type
Size
PNR
Number
(5)
Flight_no
AutoNumber
(7)
Flight_date
Date
(20)
Class
Text
(1)
Reserv_date
Date
(20)
Pass_name
AutoNumber
(20)
Pass_add
AutoNumber
(100)
Passport_no
Number
(8)
Cancel_date
Date
(20)
Total_fare
Number
(8,2)
Flight_type
Text
(1)
Pass_status
AutoNumber
(15)
Canc_amt
Number
(8,2)

4. Table name: RESERVATION

Fields
Data Type
Size
PNR
Number
(5)
Flight_no
AutoNumber
(7)
Flight_date
Date
(7)
Class
Text
(1)
Reserv_date
Date
(20)
Total_fare
Number
(8,2)

5.Table name: FLIGHT

Fields
Data Type
Size
Flight_no
AutoNumber
(7)
Flight_date
Date
(20)
First_bk_seats
Number
(3)
Bus_bk_seats
Number
(3)
Eco_bk_seats
Number
(3)

6.Table name: FLIGHT_SCH

Fields
Data Type
Size
Flight_no
AutoNumber
(7)
Airbusno
AutoNumber
(5)
Airbus_nm
AutoNumber
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Relational Schema Car Rental Key 544 F1
    • 182 Words
    • 2 Pages

    Relational Schema Car Rental Key 544 F1

    MGMT 54400 Fall 2013 Relational Schema 1. CUSTOMER (C_Name, C_Phone, Dr_Lic_No, C_Street, C_City, C_State, C_Zip) 2. CAR (Vehicle_ID, Lic_Plate_No, Make, Model, Price, Mileage, Car_Type, D_Name) FK D_Name  DEALER 3. COMPACT_CAR (C_Vehicle_ID, No_of_Doors) FK C_Vehicle_ID…

    • 182 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Checkpoint week 8
    • 1238 Words
    • 4 Pages

    Checkpoint week 8

    The reservation system is more than a convenient way for a passenger to buy a ticket. It is often the consumer’s first interaction with the airline and therefore could possibly set the tone for their entire experience.…

    • 1238 Words
    • 4 Pages
    Better Essays
    Read More
  • Good Essays

    Jet Blue and West Jet
    • 839 Words
    • 4 Pages

    Jet Blue and West Jet

    Over the past years, customers have been heavily relying on airline reservation systems to book their tickets, reserve seats, pay for the tickets and also check-in online. For customers, this has been a very convenient method and they are able to easily plan their trips. For the Airline companies, these systems have the whole flight inventory managed. They have all the flight information stored and records are maintained. It also provides a platform for communication between other airline companies for their “code-sharing plans” and agents or other ticketing offices can see real time information about the bookings and availability of seats. Since both parties rely on these systems they are of big importance to airline companies. For example, we see in the case of WestJet, the amount of chaos created after a delay of switch to another version of the system.…

    • 839 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Mgmt340 Week 4
    • 279 Words
    • 2 Pages

    Mgmt340 Week 4

    6. An airline reservation is an association between a passenger, a flight, and a seat. Select a few pertinent attributes for each of these entity types and represent a reservation in an E-R…

    • 279 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Airways flowchart
    • 497 Words
    • 2 Pages

    Airways flowchart

    Firstly, the airline company can build their brand and distinguish itself from the competitors by advertising. All information and prices should be included in the airline website so that potential customers can compare the airline to all the others. Besides that, the company should always maintain and improve its IT system for ticket reservation. For instance, they can include more payment options so that customers can pay online directly. When customers have any enquiries or problem, the customer service should always be accessible whether through a hotline or by emailing the office. Furthermore, the airline can also provide and inform about supplementary services such as airport shuttle service and more parking spaces.…

    • 497 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Assignment NP Access2013 CS P1a
    • 2671 Words
    • 11 Pages

    Assignment NP Access2013 CS P1a

    2. Switch to Datasheet view, enter the records shown in Table 1 below into the Coach table, and then close the Coach table.…

    • 2671 Words
    • 11 Pages
    Good Essays
    Read More
  • Good Essays

    Week 7 Assignment
    • 1565 Words
    • 7 Pages

    Week 7 Assignment

    402 Part IV: Building and Managing Systems BUSINESS PROBLEM-SOLVING CASE JetBlue and WestJet: A Tale of Two IS Projects The time had come for both JetBlue and WestJet to upgrade their reservation systems. Each carrier had started out using a system designed for smaller start-up airlines, and both needed more processing power to deal with a far greater volume of customers. They also needed features like the ability to link prices and seat inventories to other airlines with whom they cooperated. Both JetBlue and WestJet contracted with Sabre Holdings, one of the most widely used airline IT providers, to upgrade their airline reservation systems,…

    • 1565 Words
    • 7 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    My Sql
    • 1999 Words
    • 8 Pages

    My Sql

    This query will create a table create table furniture ( no int(6) NOT NULL PRIMARY KEY, itemname varchar(20) default NULL, type varchar(10) default NULL, dateofstock date default NULL, price decimal(6,0), discount int(2) ); Query OK, 0 rows affected (0.22 sec) This query will create a table create table arrival ( no int(6) NOT NULL PRIMARY KEY, itemname varchar(20) default NULL, type varchar(20) default NULL, dateofstock date default NULL, price int(6) default NULL, discount int(2) ); Query OK, 0 rows affected (0.22 sec) mysql> desc furniture; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | no | int(6) | NO | PRI | NULL | | | itemname | varchar(20) | YES | | NULL | | | type | varchar(10) | YES | | NULL | | | dateofstock | date | YES | | NULL | | | price | decimal(6,0) | YES | | NULL | | | discount | int(2) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 6 rows in set (0.00 sec) inserting values into the table furniture and arrival insert into furniture values(1,"white lotus","double Bed","2002/02/23",30000,25); insert into furniture values(2,"Pink Feather","Baby cot","2002/01/20",7000,20); insert into furniture values(3,"Dolphine","Baby cot","2002/02/19",9500,20); insert into furniture values(4,"Decent","Office Table","2002/01/01",25000,30); insert into furniture values(5,"Comfort Zone","Double Bed","2002/01/12",25000,25); insert into furniture values(6,"Donald","Baby cot","2002/01/12",6500,15); insert into furniture values(7,"Royal Finish","office Table","2002/10/20",18000,25); insert into furniture values(8,"Royal Tiger","Sofa","2002/03/22",31000,25); insert into furniture…

    • 1999 Words
    • 8 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Key Functions of Airlines
    • 18089 Words
    • 73 Pages

    Key Functions of Airlines

    The overview of this course is to give the future managers an inside view of Airlines management which is spread to various, functions, department and sub department. It is also deal with the various key functions and also the support functions of the air carriers.…

    • 18089 Words
    • 73 Pages
    Good Essays
    Read More
  • Powerful Essays

    airline reservation system
    • 5637 Words
    • 19 Pages

    airline reservation system

    ment against them, and what agency to go to in order to learn if a specific parcel of land is susceptible. Finally, the chapter outlines what seemingly minor building elements can make or break a property's suitability to house a Data Center.…

    • 5637 Words
    • 19 Pages
    Powerful Essays
    Read More
  • Better Essays

    JDBC using MySQL
    • 10167 Words
    • 41 Pages

    JDBC using MySQL

    ////////////////////////////////////////////////////////////////////////////////////////////////// CREATE DATABASE Company; USE Company; CREATE TABLE Customer( id VARCHAR(6) NOT NULL, name VARCHAR(30), address VARCHAR(30), salary DECIMAL(10,2), CONSTRAINT PRIMARY KEY (id) )ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE Orders( id VARCHAR(6) NOT NULL, date DATE, customerId VARCHAR(6) NOT NULL, CONSTRAINT PRIMARY KEY (id), CONSTRAINT FOREIGN KEY(customerId) REFERENCES Customer(id) )ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE Item( code VARCHAR(6) NOT NULL, description VARCHAR(50), unitPrice DECIMAL(8,2), qtyOnHand INT(5), CONSTRAINT PRIMARY KEY (code) )ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE OrderDetail( orderId VARCHAR(6) NOT NULL, itemCode VARCHAR(6) NOT NULL, qty INT(11), unitPrice DECIMAL(8,2), CONSTRAINT PRIMARY KEY (orderId,itemCode), CONSTRAINT FOREIGN KEY (orderId) REFERENCES Orders(id), CONSTRAINT FOREIGN KEY (itemCode) REFERENCES Item(code) )ENGINE=InnoDB DEFAULT CHARSET=latin1; ///////////////////////////////////////////////////////////////////////// INSERT INTO Customer VALUES( 'C001 ', 'Danapala ', 'Panadura ',54000);…

    • 10167 Words
    • 41 Pages
    Better Essays
    Read More
  • Powerful Essays

    Dbms
    • 1513 Words
    • 7 Pages

    Dbms

    2.Airlines: For reservations and schedule information. Airlines were among the first to use database in a geographically disturbed manner-terminals situated around the world accessed the central database system through phone lines and other data networks.…

    • 1513 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Better Essays

    Project Airline
    • 3245 Words
    • 13 Pages

    Project Airline

    Aim: The reason of us studying airline 6 is that we can know more about the knowledge of an airline operation. For example, we can study the establishment of different airline form the home country to other countries, provide cargo and passenger service and use the limited resource to the highest cost etc.…

    • 3245 Words
    • 13 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Amadeus
    • 268 Words
    • 2 Pages

    Amadeus

    In this Class 3 of Level I series of Airlines GDS/CRS Reservations & PNR Management, the candidates will be able to learn the following tasks & will be very comfortable to BUILD A COMPLETE PNR ON THEIR OWN:-…

    • 268 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    airline reservation system
    • 10839 Words
    • 44 Pages

    airline reservation system

    A furnace is an equipment used to melt metals for casting or to heat materials to change their…

    • 10839 Words
    • 44 Pages
    Good Essays
    Read More

Related Topics