SEM 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 companys 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)