We have been working very hard since 2009 to facilitate in learning Read More. We can't keep up without your support. Donate.

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS614 Assignment No 01 Fall 2020 Solution & Discussion Due Date:26-11-2020

CS614 Assignment No 01 Fall 2020 Solution & Discussion Due Date:26-11-2020

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

Views: 1005

### Replies to This Discussion

#Solution of #CS614 !Assignment 1 #Fall2020 by #Washi - #Data #warehousing

CS614 Assignment solution Fall 2020

Right Click on the below link, then click on “Save link as” to download the file.

CS614_Assignment_No_01_Solution_Fall_2020

Question 1  (Marks 10)

Consider the following part of an ERD of a Product Inventory System.

Which de-normalization technique will be used for the given ERD part? You are required to mention the name of the technique, apply this technique on the given ERD and provide the resultant de-normalized table.

Question 2  (Marks 10)

Consider the following information about two tables: Master and Detail.

Table1 (Master):

Header size:                 =   30 Bytes

Number of records:     =   50000

Table2 (Detail):

Header size:                 =   50 Bytes

Number of records:     =   30000000 Bytes

Suppose you have applied the pre-joining De-normalization technique on given tables. You are now required to calculate the size of resultant table in Gigabytes (GB). The reference column in these two tables is of 8 bytes.

Hint: The number of records in De-normalize table will 30000000.

Note: Deadline for assignment submission is 26 November 2020.

#cs614assignment1solution #cs614fall2020assignment
CS614 Assignment 1 Solution Fall 2020 | CS614 Assignment 1 Solution 2020

CS614 Assignment 1 Solution Fall 2020 | CS614 Assignment 1 Solution 2020

Question 1 me Collapsing tables ni aye ga pre-joining ki jaga kyon ke entities me relationship many-to-many ka hai

Collapsing Tables is used where.
- Two entities with a One-to-One relationship.
- Two entities with a Many-to-Many relationship.

Pre-joining is used where:

This technique is generally
used when there is a one-to-many relationship between two (or more) tables

product or customer entity me many-to-many relationship hai

CS614-Assignment-Solution

Right Click on the below link, then click on “Save link as” to download the file.

CS614-Assignment-Solution.docx

# CS614 Assignment Solution # 1 Fall 2020 | Data Warehousing|

Question 1 me Collapsing tables ni aye ga pre-joining ki jaga kyon ke entities me relationship many-to-many ka hai

Collapsing Tables is used where.
- Two entities with a One-to-One relationship.
- Two entities with a Many-to-Many relationship.

Pre-joining is used where:

This technique is generally
used when there is a one-to-many relationship between two (or more) tables

product or customer entity me many-to-many relationship hai

# cs614 assignment no1 fall 2020

Yar Collapsing tables ni aye ga pre-joining ki jaga kyon ke entities me relationship many-to-many ka hai

Collapsing Tables.
- Two entities with a One-to-One relationship.
- Two entities with a Many-to-Many relationship.

question 1 me product or customer entity me many-to-many relationship hai

## Latest Activity

6 minutes ago
+ ! ! Pagal Dewani ! ! + posted discussions
30 minutes ago
≋M≋S≋ posted a discussion

### JAB PYAAR NAHIN HAI

2 hours ago
2 hours ago
Asad waqas joined + M.Tariq Malik's group

### PSY403 Social Psychology

2 hours ago
3 hours ago
Mani Siddiqui Ex liked Ammara Sabir's discussion !!!!!!Muhabbat!!!!!!
3 hours ago
Mani Siddiqui Ex posted a status
"میں لامحدود تھا، تم نے محدود کیا اتنا میری ابتدا بھی تم سے، میری انتہا بھی تم تک"
3 hours ago
Amna Bhatti replied to + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion indeed
4 hours ago
Amna Bhatti liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion indeed
4 hours ago
4 hours ago
Amna Bhatti liked Shoaib Asghar's discussion CS619 Final Viva
4 hours ago

1

2

3

4

5