ABC Corporation has different types of products for sale. It has a lot of stores in different cities. Sale is described in rupees. A product is described by a unique product id pId, its name, pName, its brand pBrand, its category, pCat. its height pHeight, its width, PWidth. A store is described by store id, sId, it name sName, its city, sCity, its address sAddress. Sale of each product is to be computed on daily basis, weekly basis, monthly basis, quarter basis, yearly basis. You can assume any reasonable domains for these attributes.

Using the above scenario construct the Star Schema, identify facts, dimensions and specify their attribute. Show the relationship which exist between the fact table and dimension tables. Mention any necessary assumptions that you make.

Answer rating: 100% (QA)

PRODUCT DIMENSION Product Dimension IdentifierPK Product Category Name Pro... View the full answer