attendance system

[system]

i want to made a attendance system very simple but effective

there are

1. verify employee information like (name ,code) verified from database .
2. verify that employee who already made entry or exit don’t allow to do again in one day (one day == one exit and one entry)
3. at entry name code , current time , current date will be stored in the database.
4. at exit name code , current time , current date will be stored in the database.

i attached database ddl desc file which is easy to understand
please guide how to complete this

emp_info

Column Type Null Default Links to Comments
name varchar(40) No
ecode (Primary) varchar(30) No
desg varchar(40) No
dept varchar(40) No

Column Type Null Default Links to Comments
ecode varchar(40) No
entry_date date No
entry_time (Primary) time No

Column Type Null Default Links to Comments
ecode varchar(40) No
exit_date date No
exit_time (Primary) time No

[Strider64]

I’m going to ask a stupid question. Why do you need an exit time for an attendance system? I mean isn’t purpose of taking attendance is to find who has or hasn’t shown up? You know they are going to leave sometime and usually it’s at the regular end time.