View Single Post
Old 01-26-2019, 10:53 PM   #18
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,093
Thanks: 3
Thanked 452 Times in 445 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Help - How Can I Tackle This Problem?

Jack, IMO it's open season on assuming (making your own rules) where the assignment is not fully specified. Obviously something we could not do in a real situation. Maybe the course instructor is looking for initiative but in any case is open to fair challenge.

Collen, I'd take it that one machine can be operated by one employee in any particular shift. Record that in a relational table any you can derive how much a machine is used between two dates and which employee operated which machines in any period, or all employees who operated a particular machine during any period.

In real life, I'd expect you'd need to provide for machines not being used in a shift, or employees operating a machine for only part of a shift (illness, injury) but if not asked specifically for this, omit it.

Cronk is offline   Reply With Quote