Fitness Database

Database Management Systems, Siena University, Fall 2024

Project Description

Database designed in SQL using oracle that stores and manages information about users, trainers, fitness goals and exercises

Tables

ER Diagram

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

Click here to see sample data (opens a new tab)