Alumni Society - OLTP Relational Database - Computer Science Assignment Help

Assignment Task:

The University of Melbourne Alumni Society manages all aspects of student alumni communications including invitations and acceptances to key reunion weekends, and alumni anniversary dinners at the 10th 20th 25th 30th 40th and 50th anniversary and other key dates (e.g. University 150th Anniversary celebrations), since graduation. The Alumni Society has asked you to design a physical ER model for a MySQL relational database. The Alumni database stores information about every person to graduate from any degree (e.g. Bachelor, Masters, PhD, etc) conferred by the University of Melbourne. Some alumni may have completed more than one degree at the university. Once graduation is complete the University of Melbourne Alumni Society sends a written invitation to become a member of the Alumni Society. Currently, the Alumni society membership is an annual fee of $130 AUD. About each graduate, we store their title, first name, middle name, last name, their personal email address, work, home and mobile number and their current residential address. We also need to store the date the graduation was awarded (3rd December 2016) Members of the Alumni Society receive a magazine four times a year. We need to store an electronic copy of each edition of the magazine in the database. Lastly, we need to keep a history of all addresses of all graduates over time. 
It is important that the Alumni Society keeps a record of any honours awarded to members of the Alumni Society. Examples of honours which could be awarded include, but are not limited to, a British peerage (CBE, OBE), an Australian honour (AOM, AM, AO, AC) or the U.S. Congressional Medal of Freedom. It could also include other awards such as recognition for their academic achievements including membership of the Royal Society, (RS), a fellow of the Royal Academy (FRA), or honours such as Nobel prize, or Fields medal. Distinguished alumni are invited to deliver the keynote speech at the reunion dinner. Alumni can be awarded more
than one honour.
The Alumni Society sends invitations to all graduates for the alumni reunion weekend including an invitation to the Alumni dinner. The invitation needs to contain the anniversary year (e.g. 25th) the keynote speaker (e.g. Professor Peter Singer), the cost of the alumni dinner (e.g. $300), the dates for the alumni weekend (5th – 7th June 2020) and dinner date (6th June 2020), and a total capacity of seats (e.g. max 1200). Alumni Graduates must attend the alumni reunion weekend to be eligible to purchase tickets to the alumni dinner. We need to be able to track all graduates who are attending the reunion, and who have paid for seats at the alumni dinner. The  Frequently Alumni members make donations or bequests to the University of Melbourne. The University needs to record who made the donation, what the donation was, the year of the donation. If the donation was an artefact (e.g. artwork, historical text, archive) the database must record the artefact type, where it is displayed, stored or archived. Alumni members may make none, or more than one, the bequest to the University of Melbourne over their lifetime, or after their death. For all alumni members who make a donation, we must store their birth year, graduation year or years (e.g. Bachelor, Masters, Doctorate), and the year of their death if they are deceased.

The OLTP Relational Database
It is important that your OLTP relational database design be able to easily answer queries similar to those listed below.

1. How many alumni weekends has Marc Forster (student ID 67834) attended?
2. Where is the Germain Greer archive bequest located?
3. How many graduates have obtained their Bachelors, Masters and PhD at the University of Melbourne?
4. List the different degrees conferred by the Melbourne School of Design
5. Who was the dean and what year did the Department of Architecture change its name to the Melbourne School of Design?
6. List the members who joined the Alumni, cancelled their membership and then rejoined the Alumni at a later date.
7. How many alumni members attended the 150th Anniversary Celebration reunion dinner?

You are to analyse the University of Melbourne Alumni case study and design a Conceptual Model in Chen notation, a Data Dictionary, Physical ER Model for a MySQL Relational Database in Crow’s foot notation modelled with MySQL Workbench for a MySQL relational database.
You may list any assumptions you have made about the model on a separate page. There is a 100 word limit for assumptions. Assumptions must not be used to simplify the assignment, but only to justify your decision about any ambiguity in the Case Study.

This Computer Science Assignment has been solved by our Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.