21 reputation
5
bio website
location NYC
age
visits member for 1 year, 7 months
seen Nov 12 at 21:30

May
8
awarded  Benefactor
May
8
awarded  Supporter
May
1
awarded  Promoter
Apr
29
awarded  Editor
Apr
29
revised Is it ever a good idea to denormalize for integrity?
Was waffling between naming this table "questions" and "items", and accidentally included both in the description. Oops.
Apr
29
comment Is it ever a good idea to denormalize for integrity?
There are more columns in each of these tables, I've only reproduced a few them to explain the situation. For clarification, if I ask twenty users "What's 2+2", there's one problem row with the content "What's 2+2", and twenty question rows linking that problem to each of the users and holding their responses (and over the long run, a user might be given the same problem multiple times, hence the created_at in the questions primary key). There's no doubt in my mind that problem and question should be two separate tables, they represent very different things.
Apr
29
awarded  Student
Apr
29
asked Is it ever a good idea to denormalize for integrity?