If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Quick question
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. |
#2
|
|||
|
|||
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 "Stranger" wrote in message ... 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. |
#3
|
|||
|
|||
Thank you so much.
I seem to have a hard time deciding what tables things belong in some times. Thanks again. "Sal Rosario" wrote in message ... 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 "Stranger" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about Absolute reference formula | Maria | General Discussion | 3 | June 23rd, 2004 06:27 PM |
A Different Quick Backup Question | Nathan Widmyer | Outlook Express | 4 | June 4th, 2004 03:40 AM |
Question on Array Formula | John | Worksheet Functions | 1 | February 21st, 2004 05:40 PM |
Ye olde blank cell question.. maybe | XLguy | Worksheet Functions | 3 | February 10th, 2004 09:49 PM |