Assignment Task :
The University of Melbourne Alumni Society
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 have asked you to design a physical ER model for a MySQL relational database.
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!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. Graduates can be located anywhere in the world.
The University needs to store the name of every degree awarded. Degree names can change over time. For example: The Bachelor of Architecture is now the Bachelor of Design and the Bachelor of Computer Science has now become the Bachelor of Science (Software Engineering). A history of all degree names needs to be stored. We need to store information about 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 the university. For example, the Department of Information Systems existed from 1997 to 2014 when it was merged with the Department of Computer Science (1983 – 2014) to form the School of Computing and Information Systems (2015 – ). The system needs to store a complete history of all departments in the University and all degree names conferred by a department and its faculty. For example: a Master of Information Systems degree could be conferred by the Department of Information Systems in the Science faculty or the School of Computing and Information Systems in the Engineering faculty depending on the date the award was conferred to the graduate.
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), fellow of the Royal Academy (FRA), or honours such as Nobel prize, or Fields medal. Distinguished alumni
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 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 financial information is NOT stored in this database. We must be able to determine if graduates and alumni society members have attended one or more previous reunion dinners.
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, 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 birthyear, graduation year or years (e.g. Bachelor, Masters, Doctorate), and the year of their death if they are deceased.
- It is important that your OLTP relational database design be able to easily answer queries similar 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 of Melbourne?
- List the different degrees conferred by the Melbourne School of Design
- Who was the dean and what year did the Department of Architecture change its name to the Melbourne School of Design?
- List the members who joined the Alumni, cancelled their membership and then rejoined the Alumni at a later date.
- How many alumni members attended the 150th Anniversary Celebration reunion dinner ?
Welcome to Our Online Academic Writing Service. Our online assignment writing website provide various guarantees that will never be broken. No matter whether you need a narrative essay, 5-paragraph essay, persuasive essay, descriptive essay, or expository essay, we will provide you with quality papers at student friendly price.
Ask for Instant Writing Help. No Plagiarism Guarantee!
