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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a temporary table - is this a good solution to the problem? 4
Windows 2000 network transfer speed problem 4
Still having probs with SQL and Variables... 5
first record query 1
Normalization: Tables for Addresses? 5
Parameter queries with multiple parameters and null values 5
Restated: "Fields are expensive, records are cheap" 17
Analyzing/Normalizing Database 5

Back
Top