We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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

Please Share your ideas

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 1216

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Please Discuss here about this assignment.Thanks

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.

 

Task

 

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:

RSS

Latest Activity

+ M.Tariq Malik added a discussion to the group CS401 Computer Architecture and Assembly Language Programming
7 seconds ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS610 Computer Network GDB Fall 2019 Solution & Discussion in the group CS610 Computer Network
1 minute ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS610 Computer Network GDB Fall 2019 Solution & Discussion
1 minute ago
+ M.Tariq Malik added a discussion to the group CS610 Computer Network
2 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS403 Database Management Systems GDB Fall 2019 Solution & Discussion in the group CS403 Database Management Systems
4 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS403 Database Management Systems GDB Fall 2019 Solution & Discussion
4 minutes ago
+ M.Tariq Malik added a discussion to the group CS403 Database Management Systems
4 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS304 Object Oriented Programming GDB Fall 2019 Solution & Discussion in the group CS304 Object Oriented Programming
7 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS304 Object Oriented Programming GDB Fall 2019 Solution & Discussion
7 minutes ago
+ M.Tariq Malik added a discussion to the group CS304 Object Oriented Programming
7 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MTH621 Assignment No 02 Fall 2019 Solution & Discussion Due Date: 26-01-2020 in the group MTH621 - Real Analysis I
8 minutes ago
+ M.Tariq Malik replied to Amir Abbas's discussion solution Required Assignment No.1, MGT621 in the group MGT621 Administrative Law and Accountability
9 minutes ago

Today Top Members 

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

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

.