Ohe use of T-SQL in database systems based on the Medical Clinic Management System example
DOI:
https://doi.org/10.34767/SIMIS.2026.01.11Keywords:
databases, T-SQL, medical systems, MS SQL Server, Delphi, PHP, stored proceduresAbstract
This paper presents the design and implementation process of an IT system supporting the management of a medical clinic. The main objective was to create a relational database in the Microsoft SQL Server 2008 environment, fully utilizing the capabilities of the Transact-SQL (T-SQL) language. The project focused on shifting business logic to the database server side by applying stored procedures, triggers, and user-defined functions. The client application was developed in a two-tier architecture using the Delphi 5 environment and ADO technology, supplemented by a remote access module for patients implemented in PHP. The paper discusses the database structure, data integrity assurance mechanisms, and the functionality of individual system modules.
References
Ben-Gan I., Kass S., Kollar L., Sarka D., Microsoft SQL Server 2008 od środka: Zapytania w języku T-SQL, Microsoft Press, Warszawa 2009.
DeBetta P., Wstęp do Microsoft SQL Server 2005 dla programistów, Microsoft Press, Warszawa 2005.
Gerner J., Glass M., Le Scouarnec Y., Naramore E., Stolz J., PHP5, Apache i MySQL. Od podstaw, Helion, Gliwice 2005.
Marklyn B., Whitehorn M., Relacyjne bazy danych, Wyd. 2, Helion, Gliwice 2003.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
