CREATION OF THE «AIR PASSENGER TRANSPORTATION» DATABASE ON THE ACCESS DBMS
Received: 2023-07-20
Published: 2023-05-25
Abstract
This work describes the development of the Air Passenger Transportation database. The database is an important tool for airlines in improving the efficiency and quality of their work. Its use can help air carriers to reduce the time and reduce the costs of various processes that are associated with the organization of air travel. The use of databases in air transportation is an effective way to ensure more accurate and faster decision-making, increase control and management of transportation processes, improve the quality of passenger service and increase the profitability of the airline. A conceptual database model using an ER diagram has been developed. The data schema "entity - relationship" with the indication of attributes is constructed. In the Access DBMS, objects of the Main button form, several linking forms have been created, queries have been compiled in SQL, a report.
Keywords
List of references
-
Избачков Ю.С., Петров В.Н., Информационные системы: Учебник для вузов. 2-е изд.- СПб:Питер, 2005.- 656 с.
-
Джон Вейскас, Эффективная работа с Microsoft Access 97. –С-Пб., Питер, 2006 –970 с.
-
Карпова Т.С., Базы данных: модели, разработка, реализация. – СПб.: Питер, 2001. – 304 с.