Clinical Database Design Real-World Exercise
Look at the example spreadsheet and think about table structures for this project.
Demographics (include one-shot msmts unless this data will be one set of a larger group of data). The study number or patient MRN is a logical choice for PK here.
Most measurements that are not one-shot in this study are repeated with sufficient frequency that we might think about dumping all data in one other table. The PK choice here is not as obvious, but we could perhaps combine the study number with an underscore and a time code (visit number) to assure we don’t add the same data for the same patient.