Alumni Database - Case Study Assignment Help

Assignment Task:

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 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 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. 

This Case Study has been solved by our Case Study 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.