CS614 Data Warehousing Assignment No 02 Fall 2020 Solution / Discussion Due Date: 15-12-2020
Question (Marks 20)
“E-book store” is a web-based books shop that offers an online purchase service of books to the users who can place orders using the website. It offers books of different categories and from different authors. The administrative staff can update books information and manage categories of products. Main categories include Science books, Fiction books, history books, Islamic books, Math books, etc. The user (Customer) can views information about books and can place orders. The user will confirm the order and checkout. He/she can also cancel the order before the order is shipped. Payment will be made through credit card or debit card. GST (Sale tax) will also be included in the total price of books. Books will be delivered to the address provided by the user (customer). Given below is the ERD of the above-given scenario?
You have studied four steps which are involved in dimensional modeling. First step is to identify the business process. Consider the process Books Sales” described above. Apply the remaining steps of dimensional modeling to find out the grain, facts and dimensions, also create a simplified star schema from it.
Note: Deadline for assignment submission is 15 December 2020.
Wish you best of Luck!
Share the Assignment Questions & Discuss Here....
Click on the below link to download the file
Does anyone have the proper solution of CS614 kindly upload it.
This is not a valid one.
yar plz koyi solutiion upload karay plz