Click here to Skip to main content
15,942,757 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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)
Updated 26-Mar-18 0:49am
Richard Deeming 27-Mar-18 9:32am    

1 solution

Insufficient information to give you any meaningful suggestions. However, there are hundreds of examples available.
Here is one source:
Example Databases[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900