Airport Management System

Project Overview:

The “airport management system” is designed to store information about the airport, flights, flight schedule, passengers, baggage, check-in, booking and payments.

Project Description:

The airport management system automates the airport processes. This system can be used to keep a record of the information related to airport details, flights, flight schedules, passengers, baggage, booking, check-in and payments. The system can be accessed by authorized members. The information stored in the database tables will be linked together by following the relationship rules of the Database management systems. The System will generate reports for effective decision-making, hence improving the performance of the airports. The airport management system will be user-friendly. The look and feel of the system will be attractive, thus enhancing its usability and user experience.

Problems In The Existing Systems:

The existing systems require continuous changes. The existing systems are not very flexible. The system is unable to handle more data, generates errors, and interrupts business operations. The graphical user interface of the existing system is not good or user-friendly. Extensive training is required for the employees to operate the system. The usability of the system is very low. The system fails to generate the required report. The airport management needs an efficient and effective report generation process for further decision-making.

Solutions:

There should be a new airport management system. The GUI of the new system should be attractive. The system can be user-friendly. The information should be stored in well-organized and properly defined tables. The tables should be linked together by defining the proper foreign key and primary key constraints. It will be easy to generate reports as the information is stored in an organized manner. The selection of database management systems also plays a key role in improving the performance of the overall management systems.

Database Management Systems:

The Microsoft SQL Server is the best choice for airport management systems. The SQL server effectively handles large data. It provides an intelligent data manager on the server so that the clients can interact with the tables. If a client system halts or crashes, or there is a network interruption, the data manager does not commit the incomplete transaction; in this way, the system interruption does not affect the underlying table. This feature makes MSSQL more reliable than other DBMSs.

A transaction log is maintained by the client or server software. To restore the backup due to a system crash, the transaction log can be used to back up the database by restoring all the completed transactions.

SQL server maximizes data integrity by utilizing ‘triggers’ that can be used at the time of data insertion, modification, or deletion. The triggers are used at the table level, and they are not ignored or forgotten by the client system.

The Microsoft SQL Server is an optimized one; the SQL server quickly performs filtration, followed by the client machine. The data sent over the internet is minimal, hence maximizing the performance. As in most database management systems, their low-performance factor is the transmission of huge amounts of data over a network, but the MSSQL performance increases dramatically by reducing the data transmitted over the network. MSSQL supports thousands of users simultaneously without performance degradation.

However, it is very challenging to implement as it is much bigger and more complex than the existing database management system. It is not an easy system to manage. The airport management needs IT staff to manage it. It is costly to maintain it. The development of the database systems using MSSQL is complex and takes longer.