I am trying to figure out the best way to design this Database.
I am trying to track outcomes for patients. Vision is what I am tracking over a period of time by the particular surgeon who performed the surgery.
I want to put the data into a report which will go into a chart.
I know I need a Patient Table but should I put their outcomes in this or create a separate table and just create the relationship. I know I will need a surgeon table.
Also All the fields with the exception of one will drop down on the main patient entry form. Should I create a table of static values for the score values for the patients vision?