Intelligent database design and analysis for aeronautical information

• Main Author: Zhang, Rongsu
• Other Authors: Sameer Alam
• Format: Final Year Project
• Language: English
• Published: Nanyang Technological University 2021
• Subjects: Engineering::Aeronautical engineering::Air navigation; Engineering::Computer science and engineering::Information systems::Database management
• Online Access: https://hdl.handle.net/10356/149454
• Institution: Nanyang Technological University

In this day and age, digital technologies are involved in most aspects of everyone’s life. Data and information can be viewed and obtained from everywhere at any time. Digital technologies also allow users to store their data in clouds, displaying and retrieving their information both online and offline. With the implementation of the dashboard, everyone will be able to view the information in a simple yet efficient way. Air traffic data might be difficult to visualize as most of the data requires a map to analyse. Civil Aviation Authority of Singapore (CAAS) published the air navigation within the Singapore FIR in Aeronautical Information Publication (AIP) Singapore, for easier access, CAAS came out with an electronic integrated aeronautical information(e-AIP). In the e-AIP a large amount of data can be found, which are neatly placed in table formats according to the title. However, to make things more efficient for the users to view the air traffic data, a customise dashboard is desired. Thus, this project is introduced to create a dashboard for air traffic. To create a dashboard, the backend and frontend will be implemented. Backend development is more toward the server-side whereby it oversees the backend of the website such as managing the database, servers and application. The frontend is toward the client-side that controls the visual of the dashboard such as creating graph, figure, table and button that is web-based user interface. Once the principle of frontend and backend is understood, moving on to the implementation of this project, from gathering the data from e-AIP, establish the relations between the tables, creating models for the table so it can perform an auto-generating migration to the database, and finally the coding of the dashboard, all this process information can be found in this report. The time complexity for this project will be using the Big-O Notation, O(n), as the programming is mainly if-else statement. For Space complexity, this project will be using the Big-O Notation, O(1), as it takes a fixed amount of space that is not dependent on the input.