X hits on this document

Powerpoint document

Access Database Design for Clinical Research Studies - page 7 / 10

39 views

0 shares

0 downloads

0 comments

7 / 10

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.

Document info
Document views39
Page views41
Page last viewedSun Dec 11 00:34:01 UTC 2016
Pages10
Paragraphs48
Words704

Comments