Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.


CS614 Data Warehousing Assignment No 02 Fall 2020 Solution / Discussion Due Date: 15-12-2020

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?                                                                                               

 

 

 

 

Now, using the above scenario consider the process “Books Sale”. The entities which are involved in the process are given in above ERD. The process has the following information;

“Customer ‘A’ ordered 5 History books from e-book shop”.

“Customer ‘B’ ordered 8 Science books from e-book shop”.

“Customer ‘C’ ordered 5 Fiction books and 5 Islamic books from e-book shop”.

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!

Views: 1223

Replies to This Discussion

Share the Assignment Questions & Discuss Here.... 

Solution File

Attachments:

CS614_Assignment_No_02_Solution_Fall_2020

Click on the below link to download the file

CS614_Assignment_No_02_Solution_Fall_2020

Idea Solution

Does anyone have the proper solution of CS614 kindly upload it.

This is not a valid one.

yar plz koyi solutiion upload karay plz

CS614 Assignment Solution # 2 Fall 2020 - Data Warehousing

CS614_Assignment_No_02_Solution_Fall_2020

Click on the below link to download the file

CS614_Assignment_No_02_Solution_Fall_2020

RSS

Looking For Something? Search Below

VIP Member Badge & Others

How to Get This Badge at Your Profile DP

------------------------------------

Management: Admins ::: Moderators

Other Awards Badges List Moderators Group

Latest Activity

Blessing posted a discussion
56 minutes ago
Muhammad Nadeem added a discussion to the group ECO402 Microeconomics
1 hour ago
Mani Siddiqui posted a status
"کوئی تو ہو جو گھبرائے میری خاموشی سے ‏کسی کو تو سمجھ آئے میرے لہجے کا دکھ"
1 hour ago
ልጠክል ጌዘልፕፕጎ replied to ልጠክል ጌዘልፕፕጎ's discussion !!!!!!!!!!!!HAPPY FATHER'S DAY!!!!!!!!!!
1 hour ago
Mani Siddiqui posted a status
"Pakistan’s Haroon Khan has claimed a bronze medal at the 24th Asian Taekwondo Championship in Beirut, Lebanon"
1 hour ago
Mani Siddiqui liked Honey Chaudhary's discussion Sabit to kar
2 hours ago
Saba liked Honey Chaudhary's discussion Sabit to kar
2 hours ago
Mani Siddiqui commented on Mani Siddiqui's blog post Tu Mujha Souch Kabhi
2 hours ago

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service