Corporate Technology Center

Five years ago, Megan Thomas was a busy executive seeking to keep herself 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. The primary objective of her company is to offer a wide variety of technology update seminars to local business executives and their employees, including ones covering operating systems, spreadsheets, word processing, database management, the 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. Seminars are in a one-, two-, or fourday format. 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.

a. What entities are identified in the previous 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 entityrelationship diagram. Be sure to specify the cardinalities for each relationship.