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 fac- ing 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 lo- cal 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 compa- nies. Seminars are in a one-, two-, or four- day 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, gener- ally only one staff member teaches a given course on a given date.

a. What entities are identified in the previ- ous scenario? Can you identify additional entities?

b. For each entity identified in part a, spec- ify 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 an- swers to a, b, and c, prepare an entity- relationship diagram. Be sure to specify the cardinalities for each relationship.