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).