Tunku Abdul Rahman University College ('TAR UC') was established in 1969 as TAR College with the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
Answer 1 This could be happening because the current system is an OLTP system Online Transaction Processing system This system is designed to handle h... View the full answer
Related Book For
Business Statistics
ISBN: 978-0321925831
3rd edition
Authors: Norean Sharpe, Richard Veaux, Paul Velleman
Posted Date:
Students also viewed these computer engineering questions
-
The data for various companies in the same industry are as follows: Determine the total asset turnover, net profit margin, and earning power for each of the companies. COMPANY S10 S20 10 2 S8 6 0.8...
-
Companies in the same industry generally have about the same break-even point. Do you agree? Explain.
-
Companies in the same industry generally have about the same break-even point. Do you agree? Explain.
-
Calculate the moment of inertia about the base of composite lamina made up of a semicircle of 120 mm base diameter is removed from base of rectangle 120 mm X 500 mm such that lamina is symmetrical to...
-
Identify the differences among reward, legitimate, and referent power.
-
Determine the projected component of the force FAB = 560 N acting along cable AC. Express the result as a Cartesianvector. 15 m 15 m Fan- 560 N 3 m.
-
Describe the measurements that must be taken and the equations that must be used to determine the shear creep compliance, \(S_{66}(t)\), of a unidirectional viscoelastic lamina by using a rail shear...
-
Suppose that the tax rate on personal income, tp, is equal to 40%; the corporate tax rate, tc, is equal to 35%; and the capital gains tax rate, tcg, is 20%. Also assume that the before tax rate of...
-
The costs per equivalent unit of direct materials and conversion in the Rolling Department of Jabari Steel Company are $1.00 and $2.15, respectively. The equivalent units to be assigned costs are as...
-
The trial balance of Pacilio Security Services Inc. as of January 1, 2017, had the following normal balances: Cash ................. 78 , 972 P e t t y C a s h . . . . . . . . . . . . . . . . 100 A c...
-
What is the target heart rate for Mary, a 14-year-old with a resting heart rate of 70 beats per minute, if we calculate it as 50% of her maximum heart rate?
-
Discuss the role of active listening in fostering empathetic understanding and facilitating constructive dialogue amidst complex interpersonal interactions.
-
1. LookGood, Inc. has just announced the bad news that its earnings have dropped by 30 percent. In fact, its investors had anticipated a decrease of 20 percent. As a result, LookGood's stock price:...
-
If the base rate of an hourly worker is 8.80 per hour and the employee worked 47 hours during the week, calculate his gross pay is overtime is paid at time and a half.
-
1. Find solutions for the divergence and curl of the vector field v at (1, 0, -1). v (x, y, z) = xzi+ xyzj + z cos(y) k 2. If r= (x, y, z), prove that V (-) = = = 1/2 - (8 mark)
-
what ways can individuals employ rhetorical devices to captivate an audience and foster meaningful dialogue in professional settings?
-
A proposed cost-saving device has an installed cost of $695,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial...
-
Evenflow Power Co. is considering a new project that is a little riskier than the current operations of the company. Thus, management has decided to add an additional 1.5% to the company's overall...
-
Exercise 47 shows the results of a poll that asked about gun ownership. Suppose we select three adults at random from this sample. a) What is the probability that all three respond Yes? b) What is...
-
A local insurance agent was concerned that he might lose customers to online discount insurance sites. To investigate, he randomly selected profiles (type of car, coverage, driving record, etc.) for...
-
For the Gas prices of Exercise 6, the actual value for January 2007 was 2.321. Find the absolute percentage error of your forecast.
-
The number on the jersey of each New York Giants football player is recorded, then the mean of those numbers is computed. Decide whether the statement makes sense (or is clearly true) or does not...
-
A professor calculates final grades using a weighted mean in which the final exam counts twice as much as the midterm. Decide whether the statement makes sense (or is clearly true) or does not make...
-
The following ages (years) of survey respondents: 22, 19, 21, 27, over 65, over 80. State whether the mean or median would give a better description of the average. Explain your reasoning.
Study smarter with the SolutionInn App