Database setup

[ScottM]

I have an employee database I'm setting up and starting to
use. In it there are eight tables:
employee (name, address, etc.)
benefits (type, elections)
company property (PDAs, Laptops)
emergency contact (primary & secondary)
employment eligibility (I-9)
leave of absence (FMLA/CFRA)
payroll (w-4 info, etc.)
service (DoH, tenure, etc.)

There are corresponding queries for each table drawing all
information from each for use in different subforms.

Question: Is this an efficient setup? If not, how
should I better organize the information?

 

[Chris Nebinger]

Humm....

I don't see the reason of seperating out Employment
Eligibility from Employee, nor Service. Those sound like
additional fields.

Also, Emergency Contact may or may not be a seperate
table, depending on the number.

What are the key fields between each table?


Chris Nebinger