We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
www.vustudents.ning.com
|
+ Link For Assignments, GDBs & Online Quizzes Solution |
+ 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: 1197
.
+ 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
-
Permalink Reply by + M.Tariq Malik on
-
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.
-
-
-
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:
-
-
Permalink Reply by fahadmukhtar on
-
in sab ma sy right kon sa ha sir
-
-
-
CS614-Assignment-Solution
- Attachments:
-
Latest Activity
© 2019 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
