This paper presents the design and implementation of a data model developed for a Hospital Information System (HIS). The model addresses the complex requirements of modern healthcare facilities, including the management of patient records, clinical treatments, staff operations, and administrative workflows. By optimizing data integration, consistency, and security, the model ensures that healthcare institutions can efficiently handle large volumes of data. The paper provides a detailed description of the theoretical foundations of the model, including the definition of key entities and their relationships within the HIS. It also explores the technical implementation of the model using Oracle Database, focusing on key features such as indexing, partitioning, and query optimization. Data consistency and security are ensured through the use of transactions and role-based access control. This work serves as a reference for future articles discussing the model’s structure and its practical implementation. Additionally, it lays the groundwork for the creation of a real-world dataset, which will be used in subsequent studies for benchmarking purposes.