Question
(NEED ANSWERS URGENT IN TWO HOURS) ABC Sdn Bhd is a wholesale company selling furniture for living rooms, bedroom, dining hall and many other types
(NEED ANSWERS URGENT IN TWO HOURS) ABC Sdn Bhd is a wholesale company selling furniture for living rooms, bedroom, dining hall and many other types of furniture. As the company is getting many orders from the increasing customers from all over the country, the manager need an application to manage all the orders and sales. A system analyst is hired to design a data warehouse for the company. The data warehouse has to allow the manager to analyse the companys situation at least with respect to the Furniture, Customers and Time. Moreover, the company needs to analyse: i. the furniture with respect to its type (chair, table, wardrobe, cabinet...), category (kitchen, living room, bedroom, bathroom, office...) and material (wood, marble...) ii. the customers with respect to their spatial location, by considering at least cities, regions and states Based on the information, you need to answer the following questions: a) Define all dimension attributes for the ABC Sdn Bhd data warehouse and the fact table. (10 marks) b) Develop the sales star schema. (8 marks) c) Define attribute hierarchies.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started