stuck with normalizing table

[pharaon]

well I want to make a data base for community service it will contain families data like
1- husband, wife, kids, address, phone
2- who might need a medication from any families members
3- who might need a shelter from any families members.
4- who is working from any families members

I read the Entity Relationship explanation I understand it but since i'm new to access I don't know how to apply it in my case
hope any one can help

 

[MarkK]

To say you need help applying a complex theoretical structure to a complex real world problem is too broad a topic to address without writing a book. Break it down into smaller chunks.

Do you need help creating a table, for instance? Do you need help creating an index in a table?

hth

 

[pharaon]

I need help in the structure of each table
for example one table will be for husband, wife, kids, address, phone
another table to indicate who's of them need medication
how to Structured that table and how to relate it with the first table what field need to be the key

 

[jdraw]

There is a high level generic Community Services related data model at
http://www.databaseanswers.org/data_models/community_groups_and_workers/index.htm

Th specifications that led to this model are at
http://www.databaseanswers.org/data_models/community_groups_and_workers/facts.htm