What would be the best design for a database that is used for scheduling work. We manufacture buildings and need to schedule 3 or 4 employee's in each building.
Employee
also keep up with absences, sick, vacation, or employee is in training
Date
Time
spent in each building.
Also have (16) different work stations:
Framing
conduit
electrical
painting,
carpentry, etc....
Need:
model
serial no.
job no.
of building,
I can build it but would like input on best layout.