Problem statement You are developing a relational database system for a fitness tracking application. The application allows users to track their workouts, set fitness goals, and monitor their progress over time. Users can log various types of exercises, such as running, weightlifting, cycling, and swimming. Each exercise has specific attributes, and users can perform multiple exercises in a single workout session. Additionally, users can set personal fitness goals, such as target distances for running or target weights for weightlifting.

Consider the following requirements:

1. Users can register and have a unique user ID, username, email address, and password.
2. Each workout session is uniquely identified and contains information such as the date, duration, and type of workout.
3. Users can log multiple exercises within a single workout session, and each exercise log contains details such as exercise type, duration, distance (if applicable), sets, reps, and weight lifted (if applicable).
4. Users can set personal fitness goals for various activities, including running, cycling, weightlifting, and swimming. Goals can include target distances, target durations, weight loss, maximum weight lifted, number of workouts, and steps.
5. Each user may have multiple fitness goals, and each goal is associated with a specific activity type.
6. Users can track their progress towards their fitness goals over time.

Tasks:

1. Identify the entities and their attributes.
2. Design a relational database schema in third-normal form (3NF) based on the given requirements.

Submission:

• An entity-relationship diagram using a tool like Visio or Lucidchart.
• A relational schema with attributes, primary keys, and foreign keys, demonstrating 3NF.

Rubric:

please use a tool such Visio or Lucid Chart provide a screenshot that