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.