Develop a MONSU Star Schema - Two-Column Table Methodology - Engineering Assignment Help

Assignment Task :

MONSU (Monash Student Union) is a student run organisation which manages various clubs for students on campus, and stores their data in an Operational Database.
A club managed by MONSU has a unique identifier, club name, club’s president (whose full name is stored in the operational database) and 
The clubs are also divided into categories such as academic, cultural, special interest, and spiritual clubs with each category having a unique category ID. To join a club, students have to go through an enrollment process and for each enrollment, the unique enrollment ID and the date of the enrollment are recorded.
During the semester, clubs may host various social and professional events for students to participate in and interact with other students (such as Wine and Cheese Nights, Christmas
Delights, and so on). Some of the events may be a one-day activity, and some may last for a couple of days.
All events run by each club can be joined by anyone, both Members of the club and Non-Members, however Members normally get the benefit of paying less. Some events are fully funded so they are free to join. For paid events, the fees may vary depending on whether the student is a member or not.
For all events the registration ID, date and fee are recorded in the database after a student fills in the registration form. Each event has a limitation for the total number of students involved. When the number of students registered for the event reaches the maximum limit, the registration would be closed for that event.

To further manage and develop the student clubs, the President of MONSU requires a Data Warehouse for analyzing trends and making decisions for future events. As a Data Warehouse Engineer, you have been contacted by MONSU to design a small Data Warehouse to keep track of the statistics.
Currently, the President of MONSU is particularly interested in analyzing the following:
a) The number of registered students in each semester for each event size.
b) The total event fees collected from students according to each campus location.
c) The number of registered students in events run by each club category in Clayton.
d) The total event fees for “Special Interest Club” in each course level.

Tasks:
[1]. Develop a MONSU star schema. Identify the fact table, dimensions and attributes required to support the schema.
The result of this task is a star schema diagram. You can use any drawing tool, such as Lucidchart, to draw the star schema.
[2]. Validate your star schema using the Two-Column Table Methodology. You are required to illustrate the two-column tables for all fact measures and dimensions in your star schema design.
[3]. Write the SQL commands to create the fact and dimension tables. You need to create a script file containing the appropriate SQL commands to create the fact and dimension tables. The operational tables are accessible from the MClub account.
The result of this task is the SQL commands. You will also need to show the contents of the tables that you have created.

This Engineeering Assignment has been solved by our Engineeering 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.