Gym Management Database

Overview

This project is a relational database built using MySQL to manage gym operations efficiently. It includes features like membership management, session tracking, attendance logging, and equipment maintenance.

Key Features

• Attendance Tracking
• Session Booking System
• Role-Based Access Control (RBAC)
• Equipment Maintenance Logs
• Payroll Calculations

ER Diagram

[View the ER Diagram] (https://github.com/rishabshukla-code/gym-management-database/blob/main/ERD.png)

Installation

1. Import the northeastern_university_full_dump.sql into your MySQL database.
2. Configure users and permissions as outlined in the documentation.

Usage

• Call stored procedures like CheckAndLogAttendance and BookSession.
• Query views for analytics like live member count and salary calculation.

Author

• Rishab Shukla