Employee Clocking in & Out System database
- by user164577
What would be the best database design for employee clocking and out? Right now I have two tables.
Employee Base Table: Employee Id, relevant information like name and address, clocked in column
Employee Clocked in Table: Employee id, clock in date, Clock in Time, Clocked Out Time.
Is this a good way to track clocked in and clocked out? I appreciate any help