Many to many to many

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary key) Question and IdGroup.
T_QuestionsGroups/T_Questions: One to many.
I have too:
T_HaedOfTheHouse: IdHeadOfTheHouse (with primary key) and others fields
T_CollectiveFamily: Some fields and IdHeadOfTheHouse
One to many too.
In addition, to each question to be able many fixed answers, choosed in
T_Answers with IdAnswer and Answer.
So, I have many Questions, many Answers and many Persons but I don't know to
do a relationships between theese three conjuncts.
Thanks in advance.
an
 
an said:
I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary key) Question and IdGroup.
T_QuestionsGroups/T_Questions: One to many.
I have too:
T_HaedOfTheHouse: IdHeadOfTheHouse (with primary key) and others fields
T_CollectiveFamily: Some fields and IdHeadOfTheHouse
One to many too.
In addition, to each question to be able many fixed answers, choosed in
T_Answers with IdAnswer and Answer.
So, I have many Questions, many Answers and many Persons but I don't know to
do a relationships between theese three conjuncts.
Thanks in advance.
an
Click to expand...

Hello,

Speaking to your question about questions, answers, and people, I
propose the model diagrammed at the link below (my website). I'm going
from memory somewhat, but IIRC this is how we do it at work.

http://vfdrake.home.comcast.net/files/interview.pdf

At the heart of this are answers (responses). Responses belong to
questions, which belong to interviews (collections of questions). People
can have many interviews, and vice-versa, hence the joining table
"InterviewPerson".

To model this remember the arrowheads point at the "one" side of a
one-to-many relationship.

HTH
 
Hi!

Sorry my delay.
Thank you very much for your reply and help.
But I don't undestood in Responses PK,FK1,FK2 to InterviewID, and
In InterviewPerson FK1 to PersonID

Thank you more one tima.
an
 
Hi, Smartin.

Tell me the next terminology, please:
PK - Primary Key
PK,FK1,FK2 - ?
FK - ?

Thank you.
an
 
FK = Foreign Key, i.e. a field that relates to the primary key of another
table (or at least a uniquely indexed field in another table.)
 
AB,
Thank you very much.
I have a difficult to aply Smartin Solution in my tables.
Do you know any BD sample, please?
Thanks in advance.
an
 
AB,
Many you very much for your sample.

As a matter of fact, the 1st link return:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/Otherdownload.asp, line 32

But the 2nd link it's Ok.
Thanks more one time.
an
 
Back
Top