system analysis and design eighth edition (Shelly Cashman)
Complete Personal Trainer Case on page 441 and ONLY ANSWER assignment question 1 and assignment question 2
You may use MS-Access or another diagramming tool to develop the ERD diagram and 3NF model
1. Reveiw personal Trainer fact finding summery in chapter 4 and draw an ERD with cardinality notation. Assume that system entities include memebers, 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.