Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions