Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer within 10-20 minutes , need urgently! SE Sdn Bhd is a wholesale company selling furniture for living rooms, bedroom, dining hall and many

Please answer within 10-20 minutes , need urgently!

image text in transcribed

SE 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 contract part-time system analyst is hired to design a data warehouse for the company. The data warehouse has to allow the manager to analyse the company's situation at least with respect to the Furniture, Customers and Time. Moreover, the company needs to analyse: the furniture with respect to its type (chair, table, wardrobe, cabinet...), category (kitchen, living room, bedroom, bathroom, office...) and material (wood, marble...) 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 SE Sdn Bhd data warehouse and the fact table. (10 marks) b) Develop the sales star schema and define the attribute hierarchies. (10 marks)

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

Step: 3

blur-text-image

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

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago