TERM PROJECT $-$ Handout#$1$

GENERAL ISSUES

Throughout the remainder of the semester, you are required to develop an Oracle database application as a term project.

The aim of the project is to practice actual database system development.

This and other project specification documents will serve as an essential guideline while you are developing your term

project. So$,$ please read it carefully and keep it throughout the semester. You can also use these documents as a checklist

before submitting a report, i$.$e$.,$ at every major stage of the project, to see if you have satisfied the basic requirements of

that particular stage. You should also check announcements on the Blackboard course page regularly to be informed on

the project status.

The general issues about this term project are listed below:

First, form project groups of $3-5$ students.

Note that we are assuming that the design of the database system is over, and we are in the stage of the physical

implementation of the system.

Do a project demonstration During Dec ${25}^{th},2023-$Dec${31}^{st},2023$

Submit a complete project $($both a report and development code$)$ by Monday $Ja{n}_1^{st},2024,$ at $23$:$59.$

Gvm Management Database Svstem

MyGYM is a is a gym located in Bahrain. You are to develop a gym management system $($GMS$)$ to help them

improve the performance of the current situation and overcome the problems that arise nowadays. Currently, MyGYM

uses manual system to record their members, fitness classes and other business information.

Gym Management System is designed to automate and streamline the management and administration tasks of a

fitness center or gym. This system helps gym owners, staff, and members in various aspects of gym operations,

including member management, class scheduling, attendance tracking, and billing.

Key Features:

Member Management:

Track member information, including name, address, contact details, emergency contact, and

membership type.

Assign unique member IDs and track membership status $($active$,$ expired, suspended$).$

Allow for new member registrations and member profile updates.

Class and Schedule Management:

Create a database of fitness classes offered, including details such as class name, instructor, schedule,

and maximum capacity.

Allow members to view and register for classes.

Implement a system to manage class schedules, cancellations, and substitutions.

Attendance Tracking:

Enable staff to record member attendance for classes and gym visits.

Generate attendance reports for individual members or classes.

Implement alerts for members with irregular attendance.

Billing and Payments:

Track membership fees, renewal dates, and payment history.

Generate invoices for members, including details of the charges.

Handle different membership plans $($monthly$,$ quarterly, annually$).$

Employee Management:

Maintain a database of gym staff, including trainers, front desk personnel, and management.

Assign roles and permissions to staff members.

Track employee attendance and performance.

Reports and Analytics:

Generate various reports such as membership reports, attendance reports, and financial reports.

Provide insights into class popularity, peak hours, and member engagement.

Support customizable reporting based on user requirements.