Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Download: http://solutionzip.com/downloads/personal-trainer-inc/
- Read the Personal Trainer, Inc. case on page 445. Complete assignments 1 through 4 on page 446. The assignments for this case are also listed below.
- Assignments:
- 1. Review the Personal Trainer fact-finding summary in Chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, activities and services, and fitness instructors.
- 2. Design tables in 3NF. As you create the database, include various codes for at least three of the fields.
- 3. Use sample data to populate the fields for at least three records in each table.
- 4. Recommend a date format for the new system. Should Personal Trainer adopt a single international standard, or should the format be determined by the country in which the center is located? Write a message to Susan with your recommendation.
- Download: http://solutionzip.com/downloads/personal-trainer-inc/
Advertisement
Add Comment
Please, Sign In to add comment