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...
-
Former Secretary of Labor Robert Reich: The era of big government may be over, but the era of regulation through litigation has just begun. Explain what Reich meant.
-
The following proposed audit report was drafted by a staff accountant at the completion of an engagement and submitted to the engagement partner for review. The partner reviewed the assistant's...
-
Tip Top Advertising, Inc., engaged in the following business transactions during July of 2010: Tip Top Advertising, Inc., uses the following accounts: Cash, Accounts Receivable, Supplies, Building,...
-
The following are system benefits for Interglobal Paper Company (from Problem 10): Year Benefits 1 ........... $55,000 2 ...........75,000 3 ...........80,000 4 ...........85,000 a. Use the costs of...
-
what does a bond rating say about the risk of fluctuation in a bonds value resulting from interest rate changes.
-
Joseph Randal has just been named the director of alumni relationships at a local university. Alumni donations are an important source of revenue for colleges and universities. If administrators...
-
Anika believes an individual's choice to go to college is mainly determined by access to resources.
-
Varley, P. and Laider-Kylander, N. (December 2014). Measured Approach: TEGV Assess Its Performance and Impact on Educational Enrichment Programs. Harvard Kennedy School Case Program. Available...
-
Simplify (2x)(4).
-
d. Solve: 24x + 38x + 15 = 0 x=
-
1. Graphically depict the impact of destroying wine on the overall market for French wines. 2. Clearly label all elements of your graph including consumer surplus, producer surplus, and deadweight...
-
Operations on Complex Numbers Simplify each of the following and write in the form a + bi. -36 = -6 -5= X 6+-36 = 2 15+ 49 8 Message instructor Post to forum
-
nominate a cruise market segment and undertake research from academic and industry sources This market you choose may be - the country the cruise passengers come from (the SOURCE market, NOT...
-
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 steps, in order, in the decision-making process are (a) identify issue, analyse information, gather information, identify decision-making tool, evaluate results; make a decision. (b) gather...
-
Which of the following is not a typical accountants role? (a) A financial controller. (b) A marketing manager. (c) An auditor. (d) All of the above are roles of an accountant.
-
Describe the financial reporting environment. Indicate whether each statement is true or false. (a) Accounting standards are set by the Financial Reporting Council. (b) The ASX Listing Rules are only...
Study smarter with the SolutionInn App