Data Driven Healthcare

** Taken from slides 51,52 of the lecture material **

We want to create a database for patients admitted to the surgical department who undergo two different types of surgery (Intervention1 and Intervention2).

The purpose of this database, in addition to maintaining an up-to-date and easily searchable archive, is also to perform statistical analyses to compare the outcomes of interventions. Intervention1 is riskier in terms of intraoperative mortality, while Intervention2 carries no risk of death, but is suspected to be less effective.

The success of the surgery is measured during a follow-up visit, in which the patient is monitored by ultrasound and certain symptoms (PROs), such as pain, are collected.

The database should contain the following information: * patient demographic data * Data on the surgery, such as the type, the surgeon who performed it, the length of hospitalization, and any complications, including death * data on follow-up visits, specifically the result of any ultrasound examination in terms of the number of lesions found, size, and location. In addition, the presence and type of symptoms, if any, reported by the patient should be recorded. * one or more medications can also be prescribed during the visit, characterized by the name of the drug, its ATC code and recommended dosage.

*please submit the a representation of the relationships (i.e. tables, with columns representing attributes, and a couple of example rows filled in for each table) that you think solve this data representation problem. Almost any format is acceptable (including sketching on paper, snapping a photo and uploading. You will NOT be evaluated on the "beauty" of the presentation but on content alone. NOTE: it does need to be clearly redable though