A local gym wishes to design a computer system to process its members details which includes the different types of gym membership information and the staff privileges for using the system.
Gym memberships are issued by staff with the privilege rights and not all staff can issue all membership types.
There are three types of membership that include gym, swimming pool, courts. There are options to have one, two or all three. Each type also carries an option of paying an additional fee to gain access to an unlimited number of its private clubs, for example the swimming one has diving one, the gym has an aerobics club. One guest member is free with each type; however an additional fee is added for up to 5 guests.
From time to time offers with discounts are applied and can only be applied by staff with the privileges.
Each gym membership is paid by instalments, which may be a single annual payment or monthly payments.
Access database is available. Needs a log on form.