(Solved): Need help creating a Star Schema in ERDPlus, Thank you for the help STORE CATEGORY SALES TRANSACTION ...
Need help creating a Star Schema in ERDPlus, Thank you for the help
STORE CATEGORY SALES TRANSACTION CUSTOMER PRODUCT CHFCKAIIT CYCTFM
Constellation of Line-Item Detailed Fact Tables: Now ZAGI needs to track Sales and Returns (assume return information is available). Create a star schema with two fact tables. One fact table should be a line-item detailed fact table just like the one described in b. above. The second fact table should be a line-item detailed fact table that tracks product returns by customers, stores, and different dates. The additional fact table should include the units returned, the dollars returned for each return transaction, and the transaction time (TTime). Be sure to include an appropriate primary key for the fact table that identifies each row (i.e., return transaction and each product in the return transaction).