Question $22$

Hand$-$draw on paper a fully$-$labeled conceptual ERD for the following data$/$business rules. Scan or photograph the finished work and save as $.$pdf or $.$jpg$.$ Check to make sure the file is legible. Click the Add File button to attach the file to the question.

$($State any assumptions you believe you have to make in order to develop a complete diagram.$)$ The Maritime School of Business operates international business programs in $10$ locations through$-$out the maritimes. The school had its 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 country 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. Note: A student may receive many communications. Each communication may be sent to many students.

Hand$-$draw on paper a fully$-$labeled conceptual ERD for the following data$/$business rules. Scan or photograph the finished work and save as $.$pdf or $.$jpg$.$ Check to make sure the file is legible. Click the Add File button to attach the file to the question.

$($State any assumptions you believe you have to make in order to develop a complete diagram.$)$ The Maritime School of Business operates international business programs in $10$ locations through$-$out the maritimes. The school had its 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 country 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. Note: A student may receive many communications. Each communication may be sent to many students.