Five years ago, Megan Thomas was a busy executive seeking to keep her and her employees current
Question:
Five years ago, Megan Thomas was a busy executive seeking to keep her and her employees current with new technology. She realized that many small companies were facing the same dilemma. Using her life savings and money from investors, Megan founded Corporate Technology Center. Corporate Technology Center’s primary objective is to offer technology update seminars to local business executives and their employees. A wide variety of seminars is offered, including ones covering operating systems, spreadsheets, word processing, database management, Internet, Web page design, and telecommunications.
Although Corporate Technology Center offers seminars at its own campus, it also provides on-site training for local companies. One-day, two-day, or four-day seminars are offered. Courses are open to a minimum of twenty students and a maximum of forty students. Although several staff members are capable of teaching any given course, generally only one staff member teaches a given course on a given date.
Requirements:
a. What entities are identified in the scenario? Can you identify additional entities?
b. For each entity identified in part a, specify a set of associated attributes.
c. Select an identifier for each entity. What rules did you apply when selecting the identifier?
d. Based on the case scenario and your answers to a, b, and c, prepare an entity relationship diagram. Be sure to specify the cardinalities for each relationship.
Statistics Principles and Methods
ISBN: 978-0470904114
7th edition
Authors: Richard A. Johnson, Gouri K. Bhattacharyya