Hi Art
I think this is a common scenario, where people in an organisation can have
multiple roles. Each person has a name, contact details, and other common
data, but there are specific data for each role as well, and the same person
could assume more than one role.
For example, in a learning institution where you have students, teachers,
administrators and technical staff, a person could play all four of these
roles, while most would be associated with only one.
The approach I use is to have one "Persons" table containing all the
"common" data, then one table for each role, with a one-to-one relationship
to Persons. For example, the Teachers table would have fields relating to
qualifications and areas of expertise and courses taught, while the Students
table would have links to courses studies and grades.
If someone who is both a teacher and a student has a change of address, then
this needs to be updated in only one place.
Just my 2c worth :-)
Best wishes,
Graham
> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
> Sent: Friday, 7 October 2011 04:36
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Single table for client and household
>
>
> Does any one have an idea on how can develop a single table that would
contain a client data as well as household members data? It would need to
demographic data for the client (name, address, dob, ssn, etc) and as well
as for household members.
>
> I thought o do it in two seperate tables but that would lead to redundant
data in both the client table and the household member table for the client
record.
>
> If there was sample somewhere for me to look at it would be great.
>
> Thanks
>
> Art Lorenzini,
> Sioux Falls, Sd
Tidak ada komentar:
Posting Komentar