X hits on this document

Powerpoint document

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

34 views

0 shares

0 downloads

0 comments

6 / 10

Clinical Database Design Task #3 – Table Structure

Think about final user interface.  Does the table structure look appropriate?

Do all tables have a unique (primary key) field?  Is it logical?  If not, add a tablename_id autonumber field.  You really strive to never design a table that doesn’t have a unique field.

Are all tables related through a primary/foreign key relationship?  You should be able to start at the lowest data table and work back to high level details following foreign/primary key links if table relationships are properly set up (think one to many relationships).

Document info
Document views34
Page views36
Page last viewedFri Dec 02 22:52:31 UTC 2016
Pages10
Paragraphs48
Words704

Comments