Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design a database for a fitness tracker(eg FitBit) Design must meet third normal form requirements. Provide ER diagram normalized to 3rd normal form. Business Requirements

image text in transcribed
Design a database for a fitness tracker(eg FitBit) Design must meet third normal form requirements. Provide ER diagram normalized to 3rd normal form. Business Requirements 1. For each user record Name, age, gender. 2. Like Facebook user can add friends, the friends need to be Fitbit user. 3. The application only tracks steps walked. 4. A user can start a competitions with friends(1st degree). A user can be part of multiple competitions with different sets of users at the same time. (Define your own competitions, in the multiple of 1 day, eg, 1day, 2day, 5day and 7 days) 5. A user2 participating in a competition can add his/her friends to the competition. (2nd degree friends to the user1 who started the competition. 6. Different users can be in different time zones. 2. EG. If user 1 is in CST and user 2 is in PST then for the user 1 the competition will end before user 2. 7.middotCompetition participation and results should be accessible even later. 8. User will also earn medals for individual performance even when not competing in anything. The date of earning a medal or badge should be accessible. (Medals for 5000 steps, 10000 steps and 20000 steps)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions