• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

19. Some Common Data Manipulation Problems > 19.3. Overlapping Intervals II

Overlapping Intervals II

A company employs workers and supervisors. During a typical day, each worker and supervisor works one or more shifts, which consist of consecutive hours. Table 19-4 shows a typical day (from 12 noon to 12 midnight).

Table 19-4. Superload table: Hours worked by supervisors and workers

EmpID

EmpType

StartHour

EndHour

1

Super

12:00:00 PM

5:59:00 PM

2

Super

6:00:00 PM

11:59:00 PM

3

Super

4:00:00 PM

8:59:00 PM

4

Worker

4:00:00 PM

6:59:00 PM

5

Worker

5:00:00 PM

8:59:00 PM

6

Worker

2:00:00 PM

5:59:00 PM

7

Worker

8:00:00 PM

11:59:00 PM

8

Worker

12:00:00 PM

3:59:00 PM

We want to compute the maximum number of workers that each supervisor must supervise at one time.

Solution


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint