normalization necessary?

  • Thread starter Thread starter quaddawg via AccessMonster.com
  • Start date Start date
Q

quaddawg via AccessMonster.com

I've inherited a db that has fields for each of 11 subtests of a test (the
record). Every subtest has a value, so there are no empty fields for
records; the number of records is well under 10K; and everthing seems to be
working efficiently (or quickly anyway).

My questions: ideally this should be normalized so that the scores for the
subtests are records in a separate table tied to the TestID, correct?

TestID ST1 ST2 ... ST3
2 8 12 6

vs
 
There is no problem until someone decides to create more subtests, then all
your queries, forms and logic has to be changed.

Dorian
 
Good point. Fortunately the tests won't change during the short life of this
database, so hopefully I'll get by with it as it is.
 
Good point. Fortunately the tests won't change during the short life of this
database, so hopefully I'll get by with it as it is.
 
Back
Top