OfficeId WeekdayId StartTime EndTime

------------------------------------------------------------------------

12 2.30pm4.30pm **

13 4.00pm 6.00pm

For 30 min timeinterval

this table should be populated: By dynamically i meant at run time this should be populated for marked **

Officeid weekdayid Timeslot

-----------------------------------------

1 2 2.30pm-3.00pm

1 2 3.00pm-3.30pm

1 2 3.30pm-4.00pm

1 2 4.00pm-4.30pm