Questions Bank | Page 113968

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:

Identify all Entities in in the given problem

Correctly mark the Primary Key with an Underline

Identify at least 4 to 5 attributes for each

entity

Identify all Relations between the entities, and

also identify any relationship-specific attributes.

Correctly identify ‘Cardinality’ or Key

constraints of each relationship

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.

View this question

Crowdly

Questions Bank (1363767 total)