a. In your discussion of the systems design phase, you mentioned normalization to Cassia. She would like you to explain the basics of normalization in plain English to help her understand the data design tasks.
b. Review the Personal Trainer fact-finding summary in Chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, classes, merchandise, and fitness instructors.
c. Design tables in 3NF. As you create the database, include various codes for at least three of the fields.
d. Use sample data to populate the fields for at least three records in each table.
Taken from Systems Analysis and Design 10th ed, Rosenblatt. Pgs 397-398 Tasks 1-4