Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
1
ФAKBOBEK ABILKAIYRKYZY
AIRLINE DATABASE
CONCEPTUAL MODEL
ABOUT
Introduction
Databases - a set of structures designed to store large amounts of information and software modules that manage data, their selection, sorting and other similar actions. Database information is stored in one or more tables. Any table with data consists of a set of similar records, located one after another. They are table rows that you can add, delete, or modify. Each record is a set of named fields or cells that can store a variety of information, from the date of birth and ending with a detailed description of the recipe. The same types of fields for different entries form a column of the table.
What about my DB?
This calculation-graphical work considers the airline's database system. The purpose of this work is to provide information support for the activities and organizational moments of airline.
The subject domain of DB
It is required to develop an information system for the airline. The database of the airline should carry out: the distribution of the crew on flights, the formulation of the crew of the staff depending on the qualifications and positions. Also, the flight can not be realized without aircraft and passengers.
Database design includes:
- familiarity with the subject area on the examples of existing databases
- definition of the main entities of the database - assigning attributes to entities
- create a model in the Erwin app
- - construction of matches and relationships between tables and attributes in the database model
Analysis of subject area
THE SUBJECT AREA
It is required to develop an information system for the airline. The database of the airline should carry out: the distribution of the crew on flights, the formulation of the crew of the staff depending on the qualifications and positions. Also, the flight can not be realized without aircraft and passengers.
THE MAIN PURPOSE:
The main purpose of creating an Airport database is to process information about flights, flight schedules and tickets.
TASKS
List of tasks to be solved by the database
With the help of the database "Airline" it will be possible to obtain the following information:
- about aircraft (type of aircraft, location, speed, altitude);
- detailed information about the airline employees (ID, name, work experience, position);
- about the schedule (flight number, departure point, destination, departure time, flight time, availability, ticket price);
- about the established rates which cost is included in the ticket;
- passenger data (name, passport number, phone number, ticket class);
The application for working with the database "Airline" implemented the separation of users by roles:
- Manager (enter service information about airports, flights, departures, etc…)
DESCRIPTION
The system must provide for modes of treatment flights, the schedule of planes and about the tickets. The airline cannot operate without aircraft.Inside the airline flights have their own unique internal number and directions. For each flight, a certain aircraft is installed and is characterized by the following characteristics: flight number, date of departure, time of departure and arrival. The system is the essence of the "Plane", which consists of the model, the Board number, capacity. Each flight is assigned to the crew of the Board, consisting of employees and types of their positions. Passengers are sent to the flight, whose data is stored in the database. Passengers buy tickets for the flight, the price of which is determined by the tariffs.
ENTITIES
My Airline database consists of entities like:
- flights
- workers
- aircraft
- passengers
- tickets
- tariffs
- crew of the board
- position
Relationships
Passengers
Flights
* the passenger can buy tickets for several flights. Several passengers can fly on the same flight;
Flights
Aircraft
* the aircraft can be assigned to several flights. One plane is assigned to the flight;
Workers
Positions
* positions may be different for workers. But one worker has one position.
Tariffs
Tickets
* many of the tickets sets a single tariff. A few fares may not be in the same ticket