www.vustudents.ning.com

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

# CS 614 Data Warehousing Assignment No. 2 Solution and Discussion Last date 30 May 2019

Views: 1437

### Replies to This Discussion

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

Discussed & be touched with this discussion. After discussion a perfect solution will come in a result at the end.

“How to Join Subject Study Groups & Get Helping Material”

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Share below link with friends for solution & Discussion. A Single link for help in your education.

http://bit.ly/vucodes

cs614 assignment 2 solution

CS614 Assignment No 02 Solution Spring 2019

Attachments:
 Assignment

HyperMart is an online shopping store currently acquiring a large number of customers. To manage some performance issues this online store requires to de-normalize its database for order and Order detail tables.

Normalized table structures are given below:

Order Table

Order_ID

Order_Date

100

2-Feb-2019

201

2-Feb-2019

300

4-Feb-2019

 1

….

 M

Order details Table

 Detail_ID Order_ID Product_ID Product_Quantity Sale_Amount 100 100 2 1 100 101 100 3 2 200 200 201 5 1 50 201 201 7 1 90 300 300 15 1 600 301 300 56 1 800 302 300 57 1 850 …. … … …. …

Table Information

·         Assume 1:12 record count ratio between Order master and Order detail for online store’s database

·         Assume 10 million orders (120 million records in order detail).

·         Assume 10 byte Order_ID.

·         Assume 30 byte header for master and 60 byte header for detail tables.

You are required to perform the following tasks:

1.      De-normalize the given tables using Pre-joining technique

2.      Calculate the total space used with normalization

3.      Calculate the total space used after de-normalization

Best of Luck!

CS614 Assignmen No 02 Solution Spring 2019

Attachments:

in sab ma sy right kon sa ha sir

CS614-Assignment-Solution

Attachments:

1

2

3

4

5

## Latest Activity

Naaz joined + M.Tariq Malik's group

### CS314 Introduction to Cellular Networks

6 minutes ago
Ehrish Gul left a comment for Muhammad Amir
42 minutes ago
Rabi, Ahmed Salman, Abdul Wahab and 4 more joined Virtual University of Pakistan
1 hour ago
1 hour ago
1 hour ago
AyesHa raja joined + M.Tariq Malik's group

### CS606 Compiler Construction

1 hour ago
AbdulRabecca updated their profile
6 hours ago
Attas updated their profile
12 hours ago