Q1) A GYM needs a computerized system to atomize its front office operations which support the following functionalities:
• Query support
• Report generation
• Easy input facility for new data
•Update essential details about latest available facilities, fee structure, details of the equipment, timings, Gym Instructors (Male and Female), trainees, dieticians, batch-schedules etc..
Carry out the following tasks:
(i) Draw a ER diagram by identifying entities, relationships and cardinality using any of the drawing tools like smartdraw, dia, visio, conceptdraw etc. to manage the Gym. Follow proper conventions.
(ii) Create suitable database to support/accommodate all the functionalities referred above. Perform Normalization till required NF and prepare Normalized tables.
(iii) Using MS-Access, design different forms to support Gyms’ front office operations like enquiry form, registration, to display different batch schedules for both Men and Women, facilities, equipment, Details of Gym Instructors, Details of Dieticians, fee-structure, Discounts/Offers (if any), staff details, list of phone numbers, etc.
(iv) Report generation such as daily reports of attendance of registered visitors/participants, list of complaints on equipment (if any), staff attendance, fees collection on the particular day etc.