CMSC 243 HW 9.docx - Homework 9 Chapter 9 Personal Trainer...

This preview shows page 1 - 2 out of 2 pages.

Homework 9: Chapter 9 Personal Trainer, Inc. Tasks 1. 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. 2. Design tables in 3NF. As you create the database, include various codes for at least three of the fields. Entities Fitness Members member_id; member_name; address; phone_no Merchandise and class item Item_id; item_name; price; member_id; item_hour Sale staff and instructors Instructor_id; instructor_name; address; phone_no Sample data for 3NF Member Member ID Member Name Address Phone 001 Luisi, Lopter 123 NW street,

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture