joltremari70
New member
- Local time
- Today, 03:51
- Joined
- Jun 24, 2015
- Messages
- 8
I need to add a new table to an existing db. This table will hold employee awards info, such as employee of the month, safety awards, years of service milestones, etc... I am having trouble deciding how to store this info and relate it to the employee records. This data will need to be queried in the future by things like, how many times an employee has won employee of the year, and which years it was, and how many employees from a certain branch office have won certain awards, etc... If anyone could give some tips or suggestions on how to store and relate this data I'd appreciate it.