(Solved): You are to draw a star schema diagram for this data which comes from a prototype of the data wareho ...

You are to draw a star schema diagram for this data which comes from a prototype of the data warehouse. There should be four (4) dimension tables in your diagram (named the same as the headings in the Excel file) and one (1) fact table (named something that makes sense [call it FACT]). Remember, the fact table should include in it the PKs from each of the 4 dimensions (these are to be both PKs and FKs in the fact table). It will also include the value attribute in it from the Excel file, which is a derived or calculated field. The dimensions should each have their own PK and three (3) additional attributes (minimum) that make sense to add (i.e., the item name, item description, and item cost in the ITEM dimension for example).