The University of Melbourne Alumni Society manages all aspects of student alumnicommunications including invitations and acceptances to key reunion weekends, and alumnianniversary 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 have askedyou 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 mayhave completed more than one degree at the university. Once graduation is complete theUniversity of Melbourne Alumni Society sends a written invitation to become a member of theAlumni 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 personalemail address, work, home and mobile number and their current residential address. We alsoneed to store the date the graduation was awarded (3rd December 2016) Members of theAlumni Society receive a magazine four times a year. We need to store an electronic copy ofeach edition of the magazine in the database. Lastly, we need to keep a history of alladdresses of all graduates over time. Graduates can be located anywhere in the world.The University needs to store the name of every degree awarded. Degree names can changeover time. For example: The Bachelor of Architecture is now the Bachelor of Design and theBachelor of Computer Science has now become the Bachelor of Science (SoftwareEngineering). A history of all degree names needs to be stored. We need to store informationabout the faculty including who was the Dean of the faculty on the date of graduation.Due to reorganisations, some departments disappear and reappear during the life of theuniversity. For example, the Department of Information Systems existed from 1997 to 2014when it was merged with the Department of Computer Science (1983 - 2014) to form theSchool of Computing and Information Systems (2015 - ). The system needs to store acomplete history of all departments in the University and all degree names conferred by adepartment and its faculty. For example: a Master of Information Systems degree could beconferred by the Department of Information Systems in the Science faculty or the School ofComputing and Information Systems in the Engineering faculty depending on the date theaward was conferred to the graduate.It is important that the Alumni Society keeps a record of any honours awarded to members ofthe Alumni Society. Examples of honours which could be awarded include, but are not limitedto, 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 fortheir academic achievements including membership of the Royal Society, (RS), fellow of theRoyal Academy (FRA), or honours such as Nobel prize, or Fields medal. Distinguished alumniINFO90002 A1 S1 2020 2are invited to deliver the keynote speech at the reunion dinner. Alumni can be awarded morethan one honour.The Alumni Society sends invitations to all graduates for the alumni reunion weekend includingan 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 total capacity of seats (e.g. max 1200). Alumni Graduates must attend the alumni reunionweekend 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 paidfor seats at the alumni dinner. The financial information is NOT stored in this database. Wemust be able to determine if graduates and alumni society members have attended one ormore previous reunion dinners.Frequently Alumni members make donations or bequests to the University of Melbourne. TheUniversity needs to record who made the donation, what the donation was, the year of thedonation. If the donation was an artefact (e.g. artwork, historical text, archive) the databasemust record the artefact type, where it is displayed, stored or archived. Alumni members maymake none, or more than one, bequest to the University of Melbourne over their lifetime, orafter their death. For all alumni members who make a donation, we must store their birthyear,graduation year or years (e.g. Bachelor, Masters, Doctorate), and the year of their death ifthey are deceased.The OLTP Relational DatabaseIt is important that your OLTP relational database design be able to easily answer queriessimilar to those listed below.How many alumni weekends has Marc Forster (student ID 67834) attended?Where is the Germain Greer archive bequest located?How many graduates have obtained their Bachelors, Masters and PhD at the University ofMelbourne?List the different degrees conferred by the Melbourne School of DesignWho was the dean and what year did the Department of Architecture change its name to theMelbourne School of Design?List the members who joined the Alumni, cancelled their membership and then rejoined theAlumni at a later date.How many alumni members attended the 150th Anniversary Celebration reunion dinner?