X hits on this document

Powerpoint document

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

49 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 views49
Page views51
Page last viewedSun Jan 22 10:41:57 UTC 2017
Pages10
Paragraphs48
Words704

Comments