Database Answers Senior Citizens Dancing

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Tracking Results of Treatment   

Back to the Data Model.
Entities are shown in Bold to provide a start to the design of the Data Model.
The Area being Modelled is :-
Tracking Results of Treatment

Subject: Schema
Question: I am designing a datbase for a study on the results of treatment.
To guage the results 4 different assessments will be given to the same individual at
3 specific times throughout the treatment stage.

What would be the best data model for this type of situation?

The current model I have is that I have created 7 entities with patients, interview type,
time, and then entities for the 4 interviews.

I cannot quite see how to set up the relationships and am totally stuck.

First time creating a database.


© DataBase Answers Ltd. 2012
About Us Contact Us