logo

Crowdly

Create a database model for the following use-case: A Fitness Trainer App. ...

✅ Перевірена відповідь на це питання доступна нижче. Наші рішення, перевірені спільнотою, допомагають краще зрозуміти матеріал.

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.      

Identify all Entities in in the given problem

a.      

Correctly mark the Primary Key with an Underline

b.      

Identify at least 4 to 5 attributes for each

entity

2.      

Identify all Relations between the entities, and

also identify any relationship-specific attributes.

3.      

Correctly identify ‘Cardinality’ or Key

constraints of each relationship

4.      

Create a E-R diagram for the same

You can write all of the above on a paper and attach a snap or you can create a Word document with your answer and paste E-R in the document. Attach the document to the answer . You can use any online tools to create E-R or simply use pen and paper, whatever is suitable.

Більше питань подібних до цього

Хочете миттєвий доступ до всіх перевірених відповідей на lms.flame.edu.in?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!