CSCE 520 – Spring 2003
SSN (last 4 digits):
Answer the following questions.
Be brief and precise, please.
You have 1 hour 15 minutes to
finish the test.
Undergraduate students answer only questions 1, …, 6 (for a total of 85
points) and 8 if you want to.
Question 8 is open for everyone.
Design a database for the Healthy-And-Strong (HAS) fitness club.
Assume, that HAS owns
Each studio has a name, address, phone, and hours of operation.
has a manager and other employees.
An employee can work for a single studio only and has a
name, social security number, phone, and address.
The manager is an employee and has date
Information about the customers (members) of a studio includes names, SSN,
phone number, address, and date of joining the studio.
Also, for each member, there is a set of
workout goals (description of goal and date to be achieved, e.g., loose 30 lb by May 2003), and
recommended training programs that includes workout type, trainer, date, start time, and end
A trainer is an employee with training-license number, expertise, and rating.
(10) You need to