www.vustudents.ning.com

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

# cs614 Assigment no1 fall 2021

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

Views: 214

### 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

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

 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

v  They Reduced number of foreign keys on tables.

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 1 By JUNAID

# cs614 Assignment No 1 Solution|Fall 2021

1

2

3

## Latest Activity

1 hour ago
1 hour ago
Derrick Bozem is now a member of Virtual University of Pakistan
5 hours ago
yesterday
yesterday
yesterday
yesterday
yesterday