Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

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

can please some one share the solution of this!!! need !! last date is 10 decFall%202021_CS614_1.docx

Views: 211

Replies to This Discussion

Share the Assignment Questions & Discuss Here.... 

Stay touched with this discussion, Solution idea will be uploaded as soon as possible in replies here before the due date.

CS614 (Data Warehousing) Assignment No.1 Solution Fall 2021

CS614 Assignment#01 Solution fall 2021 File link 

CS614-Assignment-1-Solution-Fall-2021-By-VU-Ning.docx

#CS614Assignment #CS614Assignment01SolutionFall2021 #CS614Assignment1Solution202
CS614 Assignment 1 Solution Fall 2021 || CS614 Assignment No. 01 Solution Fall 21

The header of resultant De-normalized table = 40 + 70 – 9
= 101 Bytes
The number of records in De-normalized table = 2000000
Size of the De-normalized table = 101 * 2000000
= 202,000,000 Bytes
= 202 MB
=0.202 GB
=0.000202 TB

CS614 Assignment Solution 1 Fall 2021

Answer 1:

As there is many-to-many relationship between Student and Courses entities so Collapsing Table De-normalization technique will be applied.

S-id

S-name

Department

Address

S-id

C-id

 

C-id

C-code

Semester

C-title

After collapsing the three tables Many to Many relationship the result of de-normalization table is:

S-id

S-name

Department

Address

C-id

C-title

C-code

Semester

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advantage:

v  They Reduced number of foreign keys on tables.

 

Answer 2:

Header size of resultant de-normalized table    = 40 + 70 -9

                                          =101 Bytes

The number of records in De-normalize table     = 2000000

Size of de-normalized table                     = 101 *2000000

= 202,000,000 Bytes

                                                                     = 202 MB

                                                                     = 0.202 GB

                                                                    = 0.000202 TB

CS614 Solution link file

CS614 Solution 1 By JUNAID

CS614 ASSIGNMENT NO 1 100% ACCURATE SOLUTION 2021

cs614 Assignment No 1 Solution|Fall 2021

RSS

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

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