Cakes & Bakes operates an online transactional database for recording information about customer sales and inventory control. It records all the transactions that are processed, including not only the ordering and delivery of stock items from the various warehouses to the supermarkets, but also the recording of inventory changes as the barcode reader scans each item at the checkout. A database server is located in each store, as well as each distribution warehouse, and the data is replicated over high-speed WAN connections to the Headquarters. Mr. Muhammad wants to view reports of total sale made by the different salesmen at different locations, product spoiled and quantity on hand in each warehouse. Draw the snow flake schema with possible hierarchies of the above scenario.