normalization necessary?

[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

 

[Larry Daugherty]

Yes, there should be a "tblSubtest" related to tblTest.

HTH

 

[mscertified]

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

Dorian

 

[quaddawg via AccessMonster.com]

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.

 

[quaddawg via AccessMonster.com]

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.