CONTAINS
PART
• part number • part description • unit cost
Generalisation
NAME ADDRESS EMPLOYEE NO. EMPLOYEE DATE HIRED
ISA
ISA
ISA
HOURLY EMPLOYEE
SALARIED EMPLOYEE
CONSULTANT
• EMPLOYEE NO •HOURLY RATE
•EMPLOYEE NO •ANNUAL SALARY •STOCK OPTION
•EMPLOYEE NO •CONTACT NO. •DAILY RATE
Data Modelling Exercise
University Student Recreation Centre Database Students can only use the centre if they have paid their recreation fees in full. The centre will also allow a faculty to purchase a membership as well. Members are allowed to check out sports equipment such as basketballs, softball bats and balls, tennis rackets, badminton rackets and table tennis rackets that can be used at the facility. When the members check out equipment, an equipment-issue form is completed listing the membership number and equipment being used. This form must list at least one piece of equipment in order to be retained in the file. Otherwise it is discarded. A member of staff is employed to monitor the checkout and the use of the sporting equipment. Every employee is assigned to one of two departments: maintenance or general staff. The centre has 10 tennis courts. These courts may be reserved up to one week in advance. Reservations can be made via the equipment checkout window. The centre also operates a small accessory shop where some sporting equipment and clothing is sold. The sporting goods include tennis balls, table tennis balls, bandages, etc. Sportswear bearing the university emblem and mascot as well as a limited assortment of some name-brand sportswear are sold. Finally, the centre sponsors a limited number of classes in officiating various sports . A general rule is that instructors often teach in more than one sport but there is never more than one class offered in a particular sport.
