Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fitness Wellness has just started a gymnasium business to respond to the call of the Malaysian government to build a healthy and vibrant society. Besides

image text in transcribedimage text in transcribed
Fitness Wellness has just started a gymnasium business to respond to the call of the Malaysian government to build a healthy and vibrant society. Besides gymnasium, Fitness Wellness also runs a series of training programs such as Zumba class, health talk and fitness coaching. The training programs are conducted every week with a specified date. Currently, it has 5 instructors and 50 customer members. It is expected that the number of customers will increase each month. In order to support for its new business and growing demand of membership from customers, Fitness Wellness requires a new system to ensure all information of their members such as membership ID, name, phone number and gender are well taken care of. Besides that, details of all instructors and list of conducted training programs must be recorded efficiently. Therefore, Mr. Kay, the manager, seek your help as a system analyst to analyse and design a new training registration database system which include all entities including associative entity that considers the following business rules: Fitness Wellness allows an instructor to conduct many trainings in a week but a training program can only be handled by one instructor. Each member may register in several different training programs by giving their membership ID to be entitled for the membership rate and make the registration payment. However, to ensure a comfort surrounding, every training program is limited to a maximum of thirty members only. End of month, Mr. Kay wants the new system to be able to generate monthly reports that could help him to monitor training program registration and manage Fitness Wellness's operation. REQUIRED: (a) Based on the case scenario, identify FOUR (4) entities (including associative entity) and attributes for the development of the new registration system for Fitness Wellness.(b) Draw an entity relationship (ER) diagram for the new system (including associative entity). (5 Marks) (c) Describe THREE (3) forms and its function that can be generated from the above tables. (3 Marks) (d) Fitness Wellness is worried if their database records are stolen. Discuss ONE (1) input security and control that can be implemented by Fitness Wellness to protect its record. (2 Marks) (e) Design an interface for a monthly registration report with a control break that is grouped based on training programs so that the management can monitor the fees collected for each training program together with the grand total fees. The report must consist of TWO (2) report headers, SIX (6) page header, ONE (1) group footer and ONE (1) report footer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John J Wild, Ken Shaw

25th Edition

1260247988, 978-1260247985

More Books

Students also viewed these Accounting questions

Question

1. Information that is currently accessible (recognition).

Answered: 1 week ago