In relational schema design, explain the anomalies caused by redundant data with a good example of each. 

It is not possible to convert a  E-R Diagram or model to a relational schema, without normalization.

A Project relational algebra operator removes duplicates while returning results

Create a database model for the following use-case:

A Fitness Trainer App.

A Fitness Coach has a Fitness Training App.

Users sign up for Fitness coaching on the app, with their

details like name, age, email, weight, height etc.

The App has various Fitness Plans to choose from. Users

choose the best suitable plan for themselves. Each plan has time slots

associated with it in the morning and evening.

Each fitness plan comes with diet consultation and

suggestions which users have to follow.

A user’s progress is recorded from time to time and saved in

the app. Details include fitness stats like weight, BMI, muscle mass, and strength

measurements.

The App also sends regular notifications on email about

progress.

Your Tasks:

1.      

a.      

b.      

2.      

3.      

4.