
$VVLJQPHQWV
Leave these assignments until a second reading unless you are confident that you have
mastered repeating groups.
1. The following table contains two repeating groups.
Dept (deptNo, deptName, Employee (employeeNo, employeeName),
Machine (machineType, quantity))
The table contains details of the employees and machines which belong to each
department; it is not intended to show any other connection between employees and
machines, such as which employees operate which machines. The quantity attribute
refers to the number of machines of a given machineType within a given department
(e.g. 6 lathes, 4 drills). Write down a table occurrence for Dept. ...