1. In your discussion of the systems design phase, you mentioned normalization t

Question

1. 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.

2. 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.

3. Design tables in 3NF. As you create the database, include various codes for at least three of the fields.

4. 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

Explanation / Answer

Dear user,

Note: One question per one post regarding rules. So, i done two questions only.

Please provide one question at a time.

2)

ERD(Entity Relationship Diagram):<?xml:namespace prefix = o />

The FITNESS INSTRUCTOR is assigned to them to train for the activity.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.