(Note: Customer_ID is the FK for the Pet table. The original typo error(PK) has been removed) After being in operation for more than 5 years, the management at Pet9 would like to build a data warehouse to analyse their business performance. The data warehouse should provide the following information:
(Note: level of staff expertise is based on the Staff level, e.g.: Junior,Senior, etc)
The seasons are defined as: summer (December to February), autumn (March to May), winter(June to August) and spring (September to November).
You are required to design a data warehouse for Pet9. The operational database can be accessed through the Pet9 account. You can, for example, execute the following query:
Tasks:
[1]. Develop a star schema named Pet9_DW. Identify the fact table, dimensions, and attributes required to support the schema. The result of this task is a star schema diagram.If you are using a bridge table, make sure to include the weight factor and list aggregate attributes.You can use any drawing tool, such as Lucidchart or draw.io, to draw the star schema.