CS614 Assignment No 01 Fall 2020 Solution & Discussion Due Date:26-11-2020
Tags:
#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.
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.
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
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.
© 2021 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
We are user-generated contents site. All product, videos, pictures & others contents on site don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at m.tariqmalik@gmail.com with copyright detail & We will happy to remove it immediately.
Management: Admins ::: Moderators
Awards Badges List | Moderators Group
All Members | Featured Members | Top Reputation Members | Angels Members | Intellectual Members | Criteria for Selection
Become a Team Member | Safety Guidelines for New | Site FAQ & Rules | Safety Matters | Online Safety | Rules For Blog Post