SHould I worry about the Table Analyzer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run this over my tables its bring outs some wierd results, should I
worry about it?

The types f things it comes up with are:

Employee table
I have Address lines for upto 4 lines of text and the table analyzer wants
to put them into separate tables?

Should I just ignore?
 
Anything that guesses what you are trying to do and rearrnages things
according to that should be regarded with some caution. Having said that,
your address should be separated into fields for street, city, state, zip (or
province or postal code or whatever the separate elements are). You can
combine them later with a query (or by other means) as needed. There could
be a separate address table (with separate fields as described), or the
address could just be in the Employees table. You may want to consider the
former if several employees share the same address.
 
My Employee table conssits of the following, I don't believe there's anything
wroong with it....Is there?

Employee ID (Primary key) Text
Surname Text
Forename Text
Middle Name Text
Addressline-1 Text
Adressline-2 Text
Town Text
Start-Date (Date/Time)
End-Date (Date/Time)
County Text
Postcode Text
Job-Title Text
NI No Text
DateofBirth (Date/Time)
 
Looks fine. Sometimes in cases such as a student database, where it often
occurs that there are several students from the same physical address, a
separate address table may be used in order to reduce the confusion that data
entry errors could cause. That is probably more the exception than the rule.
From your original posting I had imagined that you were putting the entire
address (street, city, state, zip) into a single field, which would not have
been the best approach. I see now that you are not doing that. In my view
the table analyzer is not an especially useful tool. Its suggestions should
be regarded with caution.
 
Thanks Bruce 8-)

BruceM said:
Looks fine. Sometimes in cases such as a student database, where it often
occurs that there are several students from the same physical address, a
separate address table may be used in order to reduce the confusion that data
entry errors could cause. That is probably more the exception than the rule.
From your original posting I had imagined that you were putting the entire
address (street, city, state, zip) into a single field, which would not have
been the best approach. I see now that you are not doing that. In my view
the table analyzer is not an especially useful tool. Its suggestions should
be regarded with caution.
Click to expand...
 
Back
Top