Bsc thesis. Conceptual database design of the ACL patient’s data

The Thesis explores the topic of database design, and its first couple of stages. Going from ana- lyzing the organizational structure of the hospital, and analyzing the data that is collected during a patient’s treatment process, to establishing a concrete conceptual design in form of an entity- relationship diagram. It investigates what are the present, and important relationships, entities, and the constraints imposed on them by the business rules of the hospital. More specifically, the data and the organization in question deal with patients su↵ering an anterior cruciate ligament injury, at the Orthopedie Groot Eindhoven.

After validation of the design, the results and findings of the Thesis can be used in further developing the database, as it gives a solid foundational understanding of the processes going on in the Maxima Medical Center and Catharina Hospital. On top of that, the insights into the organization and the data allow for finding novel ideas and solutions to the overarching problem of the Digital Twin project, as it is still in an early, pioneering stage. The conceptual design put forth in the Thesis gives insight into what needs to be done to implement a database that would support development of a dashboard, that is to be used by the surgeons in their daily practice.

As a sub-project of the Innovation Space Bachelor End Project (ISBEP), the team project aims to provide orthopaedic surgeons of the Orthopedie Groot Eindhoven a way of improved patient-specific decision-making, facilitating better healthcare.