title: ÐÐ½Ð°Ð»Ð¸Ð· Ð¸ Ð¼Ð¾Ð´Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ñ ÑÑÑÑÐºÑÑÑ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾Ð´ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸ÐµÐ¼ Ð¡Ð£ÐÐ PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Analysis and modification of database structures under the control of DBMS PostgreSQL
Creators: name: ÐÐ±ÑÐ°Ð¼ÐµÑÐ¸Ð½, ÐÐ»ÐµÐºÑÐµÐ¹
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
database

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð°Ð½Ð°Ð»Ð¸Ð·Ñ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Â«ÐÐ²Ð¸Ð°Ð¿ÐµÑÐµÐ²Ð¾Ð·ÐºÐ¸Â» Ð¸ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¾ Ð¶ÐµÐ»ÐµÐ·Ð½Ð¾Ð´Ð¾ÑÐ¾Ð¶Ð½ÑÑ Ð¿ÐµÑÐµÐ²Ð¾Ð·ÐºÐ°Ñ. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: 1. ÐÐ½Ð°Ð»Ð¸Ð· Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Â«ÐÐ²Ð¸Ð°Ð¿ÐµÑÐµÐ²Ð¾Ð·ÐºÐ¸Â». 2. Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¶ÐµÐ»ÐµÐ·Ð½Ð¾Ð´Ð¾ÑÐ¾Ð¶Ð½ÑÑ ÑÑÐ°Ð½ÑÐ¸Ð¹ Ð¸ Ð¿ÐµÑÐµÐ²Ð¾Ð·Ð¾Ðº. 3. ÐÐ°ÑÑÑÐ¾Ð¹ÐºÐ° Ð¿Ð°ÑÐ°Ð¼ÐµÑÑÐ¾Ð² Ð¼Ð¾Ð´Ð¸ÑÐ¸ÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. 4. Ð¢ÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ. Ð Ð°Ð±Ð¾ÑÐ° Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð° Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¿Ð¾ÑÑÐ°Ð»Ð° PostgresPro, Ð³Ð´Ðµ ÑÐ¾Ð´ÐµÑÐ¶Ð°Ð»Ð¸ÑÑ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð´Ð°Ð½Ð½ÑÐµ: Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ñ Ð¾ Ð¿Ð°ÑÑÐ°Ð¶Ð¸ÑÑÐºÐ¸Ð¹ ÑÐµÐ¹ÑÐ°Ñ, ÑÐ¿Ð¸ÑÐ¾Ðº Ð°ÑÑÐ¾Ð¿Ð¾ÑÑÐ¾Ð², Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ñ Ð¾ Ð¼Ð¾Ð´ÐµÐ»ÑÑ ÑÐ°Ð¼Ð¾Ð»ÑÑÐ¾Ð², Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ñ Ð¾ Ð±ÑÐ¾Ð½Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ð¸ Ð±Ð¸Ð»ÐµÑÐ¾Ð² Ð¸ Ð¸Ñ ÑÑÐ¼Ð¼Ð°ÑÐ½Ð¾Ð¹ ÑÑÐ¾Ð¸Ð¼Ð¾ÑÑÐ¸, Ð´Ð°Ð½Ð½ÑÐµ Ð¿Ð°ÑÑÐ°Ð¶Ð¸ÑÐ¾Ð². ÐÑÐ»Ð° ÑÐ¾Ð·Ð´Ð°Ð½Ð° Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¶ÐµÐ»ÐµÐ·Ð½Ð¾Ð´Ð¾ÑÐ¾Ð¶Ð½ÑÑ Ð¿ÐµÑÐµÐ²Ð¾Ð·Ð¾Ðº, ÑÑÐ¾Ð¶Ð°Ñ Ñ Ð±Ð°Ð·Ð¾Ð¹ Ð´Ð°Ð½Ð½ÑÑ Â«ÐÐ²Ð¸Ð°Ð¿ÐµÑÐµÐ²Ð¾Ð·ÐºÐ¸Â». Ð Ð°Ð±Ð¾ÑÐ° Ð¿ÑÐ¾Ð²Ð¾Ð´Ð¸Ð»Ð°ÑÑ Ð½Ð° Ð±Ð°Ð·Ðµ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ pgadmin, Ð¾Ð±Ð»Ð°Ð´Ð°ÑÑÐµÐ³Ð¾ ÑÐ´Ð¾Ð±Ð½ÑÐ¼ Ð¸Ð½ÑÐµÑÑÐµÐ¹ÑÐ¾Ð¼ Ð¸ Ð¼Ð½Ð¾Ð³Ð¸Ð¼Ð¸ Ð¿Ð¾Ð»ÐµÐ·Ð½ÑÐ¼Ð¸ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ°Ð¼Ð¸ Ð´Ð»Ñ ÑÐµÐ´Ð°ÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð° ÑÐ¾Ð·Ð´Ð°Ð½Ð° Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¾ Ð¶ÐµÐ»ÐµÐ·Ð½Ð¾Ð´Ð¾ÑÐ¾Ð¶Ð½ÑÑ Ð¿ÐµÑÐµÐ²Ð¾Ð·ÐºÐ°Ñ.Â  ÐÐ° Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ð¸ Ð¾Ð¿Ð¸ÑÐ°Ð½Ð½ÑÑ ÑÐ»ÐµÐ¼ÐµÐ½ÑÐ¾Ð² ÑÑÑÑÐºÑÑÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ, Ð±ÑÐ»Ð¸ ÑÐ¾Ð·Ð´Ð°Ð½Ñ Ð¸ Ð¿ÑÐ¾ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ñ Ð´Ð¾Ð¿Ð¾Ð»Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐµ Ð¾Ð³ÑÐ°Ð½Ð¸ÑÐµÐ½Ð¸Ñ ÑÐµÐ»Ð¾ÑÑÐ½Ð¾ÑÑÐ¸ Ð´Ð°Ð½Ð½ÑÑ, Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð»ÑÑÑÐµÐ¹ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸ Ð¸Ð½Ð´ÐµÐºÑÑ Ð´Ð»Ñ ÑÑÐºÐ¾ÑÐµÐ½Ð¸Ñ Ð²ÑÐ±Ð¾ÑÐºÐ¸ Ð°ÑÑÐ¸Ð±ÑÑÐ¾Ð² Ð¸Ð· ÑÐ°Ð±Ð»Ð¸Ñ.
description: The subject of graduate qualification work: "Analysis and modification of database structures under the control of DBMS PostgreSQL". This work is devoted to the analysis of the database "Air transportation" and the creation of a database for storing data on railway transportation. The tasks that were solved during the research: 1. Analyzing the "Air Transportation" database. 2. Creating a database for railroad stations and transportation. 3. Customizing the parameters of the modified database. 4. Testing of the database. The work was carried out on the basis of a demonstration database from PostgresPro portal, which contained the following data: information about passenger flights, list of airports, information about aircraft models, information about ticket reservations and their total cost, passenger data. A database for rail transportation was created, similar to the Air Transportation database. The work was carried out on the basis of PostgreSQL database management system with the help of pgadmin software, which has a convenient interface and many useful tools for editing databases. As a result of the work, a database for storing data on railroad transportation was created.Â  Based on the described elements of the database structure, additional data integrity constraints, views for better visualization of information and indexes for faster selection of attributes from tables were created and tested.