I have 2 tables. One table contains a list of machines. Each machine has
a status, for example AVAILABLE, ALLOCATED, IN USE, IN REPAIR. Each
machine has a unique ID number. The second table contains a list of
jobs, and the machine type required for t...