Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 38: Technology Retailer

Partial Solution 4

d) In every branch, there are several employees (EMP-Nr.) but these employees work only for a particular branch. Each employee has a special employment contract (contr-ID) which specifies the work hours (hours-#) and the payment class (pay-#).