View Single Post
Old 01-26-2019, 10:53 PM   #18
Newly Registered User
Join Date: Jul 2013
Posts: 2,131
Thanks: 3
Thanked 463 Times in 456 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