Hello Every Buddy Again.
Now i Have to Design a DataBase Table for Employee Record n Attendance
My Requirements are:-
Please tell me how should i design the table so i never have problem to maintain Data about Employee record and His Attendance Record.
asked Dec 09 '09 at 08:16 AM in Default
Shivrain K Vinod
Other than being able to say, that the basic employee information (name, address, phone, etc.) should be kept separate from the time and attendance information, you would need to provide additional information on what is required.
answered Dec 09 '09 at 10:45 AM
Based on what you've described here, I don't think you have a single table. From what you've described, I see at least three different entities, Employee, Shift, and EmployeeShift. With so little information it's hard to be sure, but it makes more sense to break these out for seperate storage. That way you can turn an employee on or off, modify the shifts, and do it all without affecting the historical records kept within the EmployeeShift table.
Again, that's based on inadequate information, so as you supply more details, that suggestion might change.
answered Dec 09 '09 at 12:37 PM
Grant Fritchey ♦♦