Quick question

[Stranger]

I need to create a database that will store individual resident assessments. One resident will have more than one assess over time. The score decides what level of care a resident needs.

Now, would it be best to just have one table that has the resident names and then another table that contains the assessment? the assessment contains a score at the end. I need to track a residents score over time.

Should I also include the current residents location? If so, would that be in the residents table or the assessment table?

Thanks.

 

[Sal Rosario]

It makes sense to have a table of residents and a separate table for the assessments. If the resident's location means where the person always resides, then it should be in the residents table, but if location means where the assessment took place then it should be in the assessments table. Data should be stored where it belongs.

--
Regards,

Sal Rosario
Small-Business Advisor
www.salrosario.com
I need to create a database that will store individual resident assessments. One resident will have more than one assess over time. The score decides what level of care a resident needs.

Now, would it be best to just have one table that has the resident names and then another table that contains the assessment? the assessment contains a score at the end. I need to track a residents score over time.

Should I also include the current residents location? If so, would that be in the residents table or the assessment table?

Thanks.

 

[Stranger]

Thank you so much.

I seem to have a hard time deciding what tables things belong in some times.

Thanks again.


It makes sense to have a table of residents and a separate table for the assessments. If the resident's location means where the person always resides, then it should be in the residents table, but if location means where the assessment took place then it should be in the assessments table. Data should be stored where it belongs.

--
Regards,

Sal Rosario
Small-Business Advisor
www.salrosario.com
I need to create a database that will store individual resident assessments. One resident will have more than one assess over time. The score decides what level of care a resident needs.

Now, would it be best to just have one table that has the resident names and then another table that contains the assessment? the assessment contains a score at the end. I need to track a residents score over time.

Should I also include the current residents location? If so, would that be in the residents table or the assessment table?

Thanks.