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

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

4

5

Latest Activity

Nida Arshad Javaid Ch posted photos
18 minutes ago

1 hour ago

1 hour ago

1 hour ago

1 hour ago