Tunku Abdul Rahman University College ('TAR UC') was established in 1969 as TAR College with the focus of providing tertiary education opportunities for young Malaysians. The College started with a single campus in Setapak. The first branch campus, in Penang, began at a temporary location in 1994 before moving to Tanjung Bungah five years later. The second and third branch campuses were founded in Kampar, Perak and Johor in 1998, and the Pahang faculty branch was established in 1999. The Sabah faculty branch was founded in 2002 in Sabah, East Malaysia. The university college has a student population of over 28,000, including international students from 24 countries including China, Hong Kong, Mauritius, Papua New Guinea, India, Algeria, Brunei, Sri Lanka, Somalia, Pakistan, United Kingdom, Syria and Yemen etc. Over 50 years since its inception, TAR UC has produced more than 210,000 alumni. Soon, TAR UC may transformed into a full-fledged University and will have more students enroll, both locally and internationally. The first computerized information system was developed in the late 1980, running on IBM AS/400 system. This system was used mainly for student records and examination results data. Later, as TAR UC grew with more branch campuses, the system was expanded to manage more data such as: Student enrollment Course offerings Course progression tracking Repeat/Resit Exam results . . Time-tabling and many more academic related functions (Refer to the Student Intranet to see more examples). The information system were continuously upgraded in line with technological advancement and more systems developed periodically to handle TAR UC's various academic needs. BAIT3003 Data Warehouse Technology 2022 Jan Semester Questions: 1) The administrators of TAR UC requires a good information reporting system to generate up-to date and accurate information for decision making. TAR UC is not the only well-known education institution as there are many competitors. As, the years go by, the current system seemed unable to cope with reporting demand especially at "peak periods", during non-peak periods, the system works fine. Explain why this is happening. (Hint: This is a OLTP system) (30 marks) 2) Suggest a suitable data warehouse implementation architecture for TAR UC in view of its current and near future needs. Justify your choice. (30 marks) 3) Should the data warehouse design use a "Star schema" or a "Snowflake schema". Justify your choice. Provide and sample design with at least 5 tables (for a Star schema) or 7 or more tables (for a Snowflake schema). (25 marks) 4) Assume the following scenario: Every year, TARUC produces an analysis report to show total number of students intake by year and also broken down by state, i.e. to show the number of students from each of the state in Malaysia. The state the students are from is based on their last known address. The management discover that, the numbers don't always match. For example, a report printed on 2018, to show the intake of 2017 is 100 students for the state of Selangor. The same report printed on 2019, to show the intake of 2017 is 105 students for the state of Selangor. The total number of students for the two reports remain the same, e.g. total intake for 2017 is 1000 students. Explain how this can happen and discuss how the implementation of a Type 2 slowly changing dimension (SCD) can provide for better analytics. (15 marks)