Exercise 1:
John is a certified professional fitness trainer and helps clients to achieve their fitness goals. He is interested in having an application built to track his clients’ progress. As the first phase of the project, he has tasked you to develop a data model for the application. Use the following business rules to develop a database model (Use the CFD notation).
• John has multiple clients
• Each client is assigned 3 types of physical activities
• John is certified in the following types of activities (the various measurement factors for each activity are listed in parentheses):
o Treadmill (miles run/walked, average speed, average elevation)
o Free Weights (pounds, number of reps)
o Swimming (laps, average time per lap)
o Meditation (Number of minutes)
o Racquet sports (Number of active minutes)
Note:
• The data model should be able to record client demographic information (name, address …etc.)
• The data model should be able to record client activity information
• Assume that once the client is assigned 3 activities, they do not change the activities.
• Each client works on different schedule i.e. some clients work on all activities on a day, whereas some work on only one activity per day …etc.
• Clearly indicate primary key, foreign key, relationships, cardinality and other relevant information
• If you make any assumptions, clearly indicate them on the model
Exercise 2:
John is very happy with the data model you developed. He is thinking of expanding his application to accommodate other trainers like him. He wants to start a new online business with the application. Other trainers like John will sign up on the application website and use the application to track their customers’ activity information.
Your task is to expand the model developed in Exercise-1 to accommodate other trainers. Assume that clients do not change trainers i.e. each client works with only one trainer.
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!