✅ Перевірена відповідь на це питання доступна нижче. Наші рішення, перевірені спільнотою, допомагають краще зрозуміти матеріал.
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. 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.
Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!