Design a data warehouse for a electronics store chain. The chain has 20 stores in 5 cities. Each store has different sections including computers, DVDs, TVs, audio, home appliances etc. Each store has roughly 5,000 individual items. Each item is identified by an SKU (Stock Keeping Unit) and/or UPC (Universal Product Code). Go over the four design steps and create a detailed schema of the fact and dimensions tables with all the required attributes.
