I am trying to create a scheduling program to help out one of my coworkers and I'm having some trouble designing the db.
I have figured an employee table to assign a pkEmployeeID to keep track of who is putting in availability.
I have broken out tables for the dates(tblYear, tblMonth, tblDay, tblDate, tblTimes). The problem I have is that I need to have all employees show up in an excel sheet with an x for each time slot they have available. There are 29 time slots (30 min increments from 8:00AM through 21:30 plus an "After 21:30" slot).
How would I store the information? Should I have an extra table with a field for each time slot and one for employee ID? Basically 30 fields in the table and a row for each employee's entry? This seems like it would not be normalized.
Any thoughts on how to design this would be great.
Thanks.
I have figured an employee table to assign a pkEmployeeID to keep track of who is putting in availability.
I have broken out tables for the dates(tblYear, tblMonth, tblDay, tblDate, tblTimes). The problem I have is that I need to have all employees show up in an excel sheet with an x for each time slot they have available. There are 29 time slots (30 min increments from 8:00AM through 21:30 plus an "After 21:30" slot).
How would I store the information? Should I have an extra table with a field for each time slot and one for employee ID? Basically 30 fields in the table and a row for each employee's entry? This seems like it would not be normalized.
Any thoughts on how to design this would be great.
Thanks.