Mark (mark.rullo@gmail.com) writes:

> Hi there gurus, can you please add your 2 cents on this design? We're
> having trouble relating these tables in a diagram because of the keys.
> Is it necesary to have the references setup? I would assume yes so the
> forign keys can be setup.
>
> If you look at this link, you'll see our diagram. In Red are the
> relationships that we would like to make for referential integrity, but
> cannot because of the keys.
> http://rullo.ca/linktome/QuestionsDB.jpg

It's not clear from the diagram, in which direction you want the relation
to go. If my guess is right, you need to add QuestionGroupID to the tables
QuestionAnswerName and QuestionNames. Really what QuestionAnswer relates
to is not clear. When I think of it, maybe QuestionAnswer should have an
FK to QuestionGroupDetails, and thus also have a QuestionGroupID. And
QuestionAnswerName should relate to QuestionAnswer, not
QuestionGroupDetails.

> -Q1| QNameID = 1 | "-French - Do you have a chien in your appartment?"
>| LangID = 2(fr)

"Est-ce que vous avez un chien dans votre appartement?" :-)

> The difficulty is when we try and put this in the group details table.
> We don't want to outline the Language, we'd just pass the language into
> a proc to retreive a specific group with a specific language. If you
> folks would be so kind as to add your comments to the design I would be
> truely grateful.

I fail to see what the proc has to do with the data model.


And next time, please do not post the same question independently to
multiple newsgroups.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx