Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dprichard
Yak Posting Veteran
94 Posts |
 Posted - 2006-10-06 : 13:09:10
|
| Okay, I have my idea of how to do this, but would like to get experience's idea of how to do this since I am a mere 3.5 weeks into using SQL.I am working on a time off tracker for my company. We have an employee table (employee), a request table(request). Originally I was told that all vacation is a lump of days and they take time off and it is subtracted from their vacation time. Now, I am getting told they can take off vacation, pto, bereavement and possibly more. I have a time off table now (time_off) that I made just so I could add time off types for tracking what time of time off the employee took based on having one pool of time off. I was thinking I needed to add another table (tracking) that shows the employee id as a foriegn key to the employee table then have the table show time off type, accrual rate (cause some accrue at 2 weeks per year and others at 3 days per year) and a column for increments cause some they can take in increments of 15 minutes and others half days. My thought was when I create a new employee, I have put in what types of time off they are allowed, what the accrual rates for those are. When they take a day off, put it in the request field and then when they want to view their available time off, say for the employee, how many vacation days have they accrued from the tracking database, minus the days they have taken off, leaves the number of days they have available. I would LOVE and APPRECIATE your input, cause I don't want to go down this path only to find out I could have / should have done it differently. One of the things I haven't really figured out is if they add a new time off type, how to add it for all the employees and make sure it is accounted for. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
dprichard
Yak Posting Veteran
94 Posts |
Posted - 2006-10-06 : 14:39:25
|
| Thank you for the links. I will start reading them and work on figuring this out. I am absolutely determined to not only learn this stuff, but learn to do it the right way. I am sure your links will be a big help. I have been thrust from the web designer world to programming and am having to skip from one chapter to the next for this project I was thrown into. The project is due by next Friday and I can't wait till it is over so I can go back to chapter 1 in all my books and go through them in order. I swear I am not just trying to get easy free answers, but am trying to survive this first project I have been assigned so I can learn all of this from step one instead of step 3, then 9, then 7, then 2. I know that one of these days this all will be less stressful than this first project, but you guys in the sqlteam forums have been an incredible help. I will start reading and try to figure it out. Thank you for your suggestion.DP |
 |
|
|
|
|
|
|
|
General Database Design Question