The writer is very fast, professional and responded to the review request fast also. Thank you.
Book/movie review
22/08/2022
This assessment addresses the following Unit Learning Outcomes:
1. Describe the common data sources that exist in organisations and their use in BI
2. Demonstrate practical skills in the processes associated with extraction, transformation and loading (ETL) of organisational data
3. Design and implement a simple data warehouse environment
Please submit a single word document (or similar, e.g., pdf is acceptable) using the link in Moodle.
From the Unit Information Guide:
It is your responsibility to keep a copy of any work handed in for assessment purposes. It is recommended that you keep both a hard copy and an electronic copy.
Assessments that are not received by the due date will be regarded as late unless an extension has been granted by the unit coordinator. Applications for extensions should be made as soon as a problem is experienced. Late submission will be penalised at a rate of five percent of the total marks available for the assignment per day (or part thereof). No submission will be accepted more than two weeks after the due date, as assignment return will have begun
Mudrock University has asked you to help them to design their student grades data mart. Your requirements elicitation with the clients has determined that they are interested in answering questions such as:
– Number of students in each unit in each year
– Number of students in each unit offering (i.e., ICT394 in Semester 1 2017, is a different unit offering to ICT394 in Semester 2 2017) by year.
– Grade distributions of students in units by year
– Grade distributions of students in units by offering and year
– Grade distributions by Lecturer by unit and offering
– Grade distributions by Course
– Grade distributions by School
There are a number of data sources from which you will need to draw your data. Below are the sources and the tables within them that are/may be of interest to you. These are discussed below (Primary Key, Foreign Key):
Source 1: Course Handbook
The Course Handbook is a FileMaker Pro Database. It contains data regarding all courses, units and offerings of units that are offered by Mudrock University. A course is made up of units, and a unit will have at least one offering each year.:
COURSE (CourseCode, Version, CourseName, SchoolName)
UNIT (UnitCode, CourseCode, Version, UnitName)
UNIT_OFFERING (OfferingNumber, UnitCode, Year, TeachingPeriod)
OFFERING_COORDINATOR (StaffID, UnitOfferingNumber)
Source 2: Student Information System
The Student Information System has its data stored in a relational DBMS (Oracle) at present.
STUDENT (StudentID, StudentName, DateOfBirth)
ENROLMENT (EnrolNumber, StudentID, UnitOfferingNumber, Grade)
Source 3: Human Resources System
The HR System is a proprietary system that is owned by the HR Department.
STAFF_MEMBER(StaffNumber, StaffName, SchoolCode)
SCHOOL(SchoolCode, SchoolTitle)
TASK 1 (30%): Discuss two (2) issues that may be problematic in the creation of the data warehouse that are apparent from the description above. For both, explain what you see as being the issue, why it is problematic, and what you will suggest needs to be done. This should take no more than two (2) pages in total.
TASK 2 (25%): Discuss what you see as being the most appropriate level of granularity for your data warehouse. Your discussion will need to explain why you have made this choice, and why the alternatives have been discarded. This should take not more than one (1) page.
TASK 3 (30%): Assuming that the issues you have raised in TASK 1 have been addressed to your satisfaction, design a Star Schema that will support the analyses as listed above.
TASK 4 (15%): Provide the SQL statements you would use to create the tables if you were to be implementing this design using Oracle.
You will need to submit a single word-processed document that includes
– The written answers for Tasks 1 and 2
– The SQL statements for Task 4, and
– Screen shot of the design you have created for Task 3 (please do not submit your visio file, or whatever file you use, just a screen shot, copied and pasted into a word document please).
It is most likely that you will have questions about this assignment. There will be a Discussion Forum on Moodle. Please use this, firstly, to see if you query has already been answered and, then, if it hasn’t, to ask your question.
This is an INDIVIDUAL ASSIGNMENT. While it is OK to discuss the assignment with other students, it is NOT OK to submit the same work. As final year students, the onus is on you to ensure that you do not overstep the mark as regards Academic Integrity.
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more