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: 1546

.

+ 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

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

Students having same subject can start discussion here to solve assignment, GDB & Quiz and can clear their concepts until solution is provided. 

 

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

Then copy Questions from assignment file and paste in Discussion.

 

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

http://bit.ly/papersvu (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)

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

Is it true solution?

kisi k pas correct solution hy to share kary plz.

a.o.a kya ap bta skty k 1 ma answer 8.1GB kaisay aya hai kyunk jb calculate kren tou mera to 35700 araha h

First do mulitplicaition than add them,like

10*40  + 70*110

400 + 7700

8100

8.1G

  • thanks sir

CS614 2nd Assignment Solution

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

mujhy 1st plzz bta dain kaisy calculate krny sa 8.1 gb ata h kyunk meray calculate krny sa 35700 araha

ye dono ans he ghlt lag rahe ha dono ko calculate kre or agr 1024 pe divide kre to dfrnt answer ata ha koi explaion kr de video bana ke ya written ta ke smjh ajaye 

2nd ka answer thek h

first koi explain krdo

RSS

Latest Activity

Profile IconRana Mustafa Zohaib, Mudaser Naik, Natiq and 14 more joined Virtual University of Pakistan
2 hours ago
٢٣ دن posted a discussion
3 hours ago
Meg updated their profile
4 hours ago
Muhammad Sami (MOSCM) added a discussion to the group MGMT614 Supply Chain Management
4 hours ago
Muhammad Sami (MOSCM) joined + M.Tariq Malik's group
4 hours ago
Abdullah joined + M.Tariq Malik's group
6 hours ago
+ Տehɑr Ƙհɑղ + updated their profile
6 hours ago
MUHAMMAD LUQMAN liked + M.Tariq Malik's discussion EDU301 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material
6 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS314 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material in the group CS314 Introduction to Cellular Networks
7 hours ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS314 Current Mid Term Papers Fall 2019 (14 to 26 December 2019) & All Solved Past Papers, Solved MCQs & Helping Material
7 hours ago
+ M.Tariq Malik's 14 discussions were featured
7 hours ago
+ M.Tariq Malik added a discussion to the group CS314 Introduction to Cellular Networks
7 hours ago

Today Top Members 

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

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

.