Chapter 2, Problem 2.49PAE

Draw an ERD for the following situation. (State any assumptions you believe you have to make in order to develop a complete diagram.) Also, draw a data model for this situation using the tool you have been told to use in your course: The A M. Honka School of Business operates international business programs in 10 locations throughout Europe. The school had to first class of 9,000 graduates in 1965. The school keeps track of each graduate's student number, name when a student, country of birth, current count"' of citizenship, current name, and current home address and current business address, as well as the name of each major the student completed. (Each student has one or two majors.) To maintain strong ties to Its alumni, the school distributes various communications, including publications and messages. Each communication has a title, date, and medium (e.g., printed magazine, electronic newsletter, invitation). The school needs to keep track of which graduates have received which communications. For each communication with a graduate, a
comment may be recorded with any feedback the school received from the graduate When a school official knows that he or she will be meeting or talking to a graduate, a report is produced showing the latest information about that graduate and the information learned during the past two years of comments from that graduate.