Application to manage data stored using Azure SQL Database
Li, Jie (2025)
2025
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2025060621347
https://urn.fi/URN:NBN:fi:amk-2025060621347
Tiivistelmä
This thesis presents the design, implementation, and analysis of a web application with database system, built using Azure SQL Database and PHP. The project explores the complete development process, including environment configuration, relational database schema design, create, read, update, and delete functionality development, and a comparative analysis of the Azure and Heroku platforms.
The resulting web application features user-friendly interfaces for managing interconnected tables, with built-in validation mechanisms and dynamic result displays. A comparative evaluation of Azure and Heroku highlights their respective strengths: Azure offers a comprehensive, feature-rich environment suitable for large-scale, complex projects, while Heroku stands out for its simplicity and ease of use, making it ideal for small to medium-sized applications.
The thesis also reflects on the development challenges and proposes future improvements, such as automating backend processes for generating and linking IDs across tables to enhance efficiency and user experience.
The resulting web application features user-friendly interfaces for managing interconnected tables, with built-in validation mechanisms and dynamic result displays. A comparative evaluation of Azure and Heroku highlights their respective strengths: Azure offers a comprehensive, feature-rich environment suitable for large-scale, complex projects, while Heroku stands out for its simplicity and ease of use, making it ideal for small to medium-sized applications.
The thesis also reflects on the development challenges and proposes future improvements, such as automating backend processes for generating and linking IDs across tables to enhance efficiency and user experience.