My system is a Bar code Attendance Monitoring System. Can I ask some suggestions on how to make my database more effective?
What I have tried:
Right now I have 4 tables in the database:
tblarchive - archived employees
tblemployees - information of employees (id, code, name, DOB, department)
tbltimein - time in of employees (code, timein, date)
tbltimeout - time out of employees (code, timeout, date)