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.

Assignment No. 02
Semester: Fall 2019
CS614: Data Warehousing Total Marks: 10

Due Date: November 28, 2019

Objective:
The objective of this assignment is to enhance the learning capabilities of the students about:
• De-Normalization
• Pre-Joining
• Storage Issues of Pre-joining

Instructions:
Please read the following instructions carefully before submitting assignment:
You need to use MS word document to prepare and submit the assignment on VU-LMS.
It should be clear that your assignment will not get any credit if:

 The assignment is submitted after due date.
 The assignment is not in the required format (.doc or docx)
 The submitted assignment does not open or file is corrupt.
 Assignment is copied (partial or full) from any source (websites, forums, students, etc)


Assignment

Question

“Kare Pharma” is an online Medical store currently acquiring a large number of customers. To manage some performance issues this online Medical store requires to de-normalize its database using pre-joining technique for Prescription and Prescription details tables.

Normalized table structures are given below:

Prescription Table

Prescription_ID Patient_Name Doctor_Name Prescription_Date

….



Prescription details Table

Transaction_ID Prescription_ID Med_ID Med_Quantity Sale_Amount


…. … … …. …

Table Information

• Assume 1:11 record count ratio between Prescription table as master table and Prescription details table for online Medical store’s database.
• Assume 10 million records in Prescription Table.
• Assume 10 bytes reserved for Prescription_ID in memory.
• Assume 40 bytes header for master table and 70 bytes header for details table.

Task

You are required to perform the following tasks:

1. Calculate the total space reserved in memory using normalization
2. Calculate the total space reserved in memory after de-normalization using pre-joining technique






Best of Luck!

+ 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: 1654

.

+ 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)

Attachments:

Replies to This Discussion

Solution # 01:

Total space reserved using normalization = ?

Total space reserved using normalization = (header size of master table*number of rows of master table+(header size of detail  table*number of rows of detail table)

= (40bytes*10million) + (70bytes*110 million)

= 400 + 7700

= 8100

= 8.1GB

 

Solution # 02:

Total space reserved using de-normalization = ?

Total space reserved using normalization = (header size of master table+ header size of detail table-10bytes reserved for prescription_ID inmemory)*number of records in detail table

= (40+70-10)*110 million

= (110-10)*110

= 100*110

= 11000

= 11GB

thanks for help

CS614 Assignment No 2 Solution Fall 2019

1. Calculate the total space reserved in memory using normalization1. Calculate the total space reserved in memory using normalization
Total space used = 10 x 40 + 110 x 70

= 8.1 GB
2. Calculate the total space reserved in memory after de-normalization using pre-joining technique
Total space used = ( 70 + 40 – 10) x 110

= 11,000

= 11GB

  1. Calculate the total space reserved in memory using normalization1. Calculate the total space reserved in memory using normalization.

Total space used = 10 x 40 + 110 x 70                            =   8.1 GB

  1. Calculate the total space reserved in memory after de-normalization using pre-joining technique

Total space used = ( 70 +  40 – 10) x 110     

=11,000

=11GB                   

RSS

Latest Activity

Sukaina and Soldier are now friends
14 minutes ago
Noman Ijaz liked + ! ! ! ❣ Sanam ❣ !+'s profile
1 hour ago
Soldier liked Sukaina's profile
1 hour ago
Bilal joined +M.Tariq Malik's group
2 hours ago
Preety Girl is now a member of Virtual University of Pakistan
2 hours ago
Mani Siddiqui BS VIII liked + ! ! ! ❣ Sanam ❣ !+'s profile
3 hours ago
maheen mahan joined +M.Tariq Malik's group
7 hours ago
maheen mahan added a discussion to the group CS610 Computer Network
8 hours ago
maheen mahan replied to Habiba's discussion CS610 GDB No. 1 Spring 2020 Due date 19-08-2020 in the group CS610 Computer Network
8 hours ago
Shahzada Sajid liked Mani Siddiqui BS VIII's discussion How to Use Instagram on a PC
8 hours ago
Shahzada Sajid posted a status
"hi i am new here! any one from sailkot?"
8 hours ago
+ ! ! ! ! !Marshmallow updated their profile
16 hours ago

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

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

.