💪 Gym Membership System

A comprehensive relational database system built to streamline operations for fitness centers, including membership registration, trainer management, workout session scheduling, and payment tracking. Designed and implemented using PostgreSQL with data modeling based on ER diagrams and normalization techniques.

🚀 Features

• Member Management: Register new members, assign membership types, and track workout history.
• Trainer Management: Assign trainers, schedule sessions, and manage personalized workout plans.
• Workout & Session Handling: Categorized workout plans and session bookings (individual/group).
• Payment System: Track membership payments, due dates, and renewal statuses.

🛠️ Technologies & Concepts

• Database: PostgreSQL
• Design Tool: pgAdmin
• Concepts: ER Diagrams, Functional Dependencies, Relational Schema, Normalization (up to BCNF)
• Queries: SQL (CRUD operations for all major entities)

📌 Key Entities

• Member
• Trainer
• Workout Plan
• Session
• Payment

🧠 Learning Outcomes

• Hands-on experience in relational database design and SQL query building.
• Applied advanced concepts like functional dependency analysis and data normalization.
• Understood real-world use cases in the fitness industry and translated them into a working schema.