View Single Post
  #8  
Old November 24th, 2004, 06:29 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"=?Utf-8?B?TWltaQ==?=" wrote in
:

But the way it's set up, all
Q1's, Q2's are the same for all days and all years! Tha'ts not good.
So maybe I"m not understanding your syntax of how to keep them unique
in the same table.

Days(*YearNum, *DayNum, etc)


Will the * keep them unique? I need help!


The asterisk is the Primary Key -- in other words you can have only one Day
record for 2004/298, similarly you can have only one Responses record for
Year=2004
Day=298
QuestNum = 37
SubjectID = 10994

and so there is only one AnswerGiven by that subject to that question on
that day. There is, of course, another answer for SubjectID=10995 on the
same day, and another one again for QuestNum=38 by the same subject on the
same day. And so on: one record for each answer by each subject on each
day. That is what I mean by long thin tables rather than wide flat ones!

If you look at the At Your Survey database, it will show you how it works.

The good news: once you get your head around this, you know (practically)
all there is to know about Relational Design Theory!

Best wishes


Tim F