Normal Form Rules

[detgharris]

I'm working on a database that has, among other things, a time sheet. I'm trying to make my database and comply with all the normal form rules. So far, my table has DateWorked, RegularHours, OvertimeHours, CompTimeHours, CompTimeUsed, SickTimeUsed, and VacationTimeUsed. At this point, since each employee will appear multiple times, I was thinking about creating a seperate table for each employee, not sure if that's such a good idea, but still in the design process, and just looking for some advise. Thanks in advance.

 

[dhookom]

If you want to normalize, don't create fields like "RegularHours, OvertimeHours, CompTimeHours, CompTimeUsed, SickTimeUsed, and VacationTimeUseda". Regular should be a value stored in a field. Each hour value should be stored in a record by itself.

Also, do not create separate tables for each employee. You need to research more on normalization.

I would expect to see a table somewhat like:
[tt][blue]
tblEmployeeHours
=================
emhEmHID autonumber primary key
emhEmpID link to tblEmployees.empEmpID
emhDate date worked
emhHTyID link to tblHourTypes (table storing Reg, OT, DT...)
emhHours actual hours worked
[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP

 

[detgharris]

Ok, I see where you're going, I've started this database about 15 times, and just get frusterated and restart because I don't seem to be getting anything that feels right. I am basing the database on an excel spreadsheet that a former employee had created and it's been a pain. I WILL get my head around this database thing, because I know that it will make life much simpler. If I ever get this one done, my goal is to create an evidence database which I'm sure will be equally as challenging. Thanks for your help.