Fitness Database

Database Management Systems, Siena University, Fall 2024

Project Description

This project is a fitness management database designed using SQL with Oracle. It stores and manages detailed information about users, trainers, fitness goals, and workout routines. Users can log workouts, set goals, and review their progress through intuitive queries and reports. The database also incorporates relationships between users and trainers, ensuring seamless scheduling, goal tracking, and progress visualization.

Project Goal

Have users be able to efficiently track their progress, interact with trainers, achieve their fitness goals, and stay healthy

ER Diagram and Table Descriptions

ER Diagram
ER Diagram (Source: here)

UserTable

Stores user information

Trainer

Stores information about trainers

TrainerPhone

Stores trainer phone numbers if they have more than one phone number

Goal

Allows user to enter goals

LogTable

Logs user fitness activity

Exercise

Stores different exercises and the equipment used

Workout

Stores specific details for an exercise performed

Reach

Table to store that a user completed their goal