Skip to content
  • 0 Votes
    2 Posts
    1k Views
    zareenZ
    Please share your idea solution
  • 0 Votes
    4 Posts
    2k Views
    zareenZ
    @zareen said in CS614 Assignment No.2 Solution and Discussion: Question No. 2 Consider the following normalized tables for a telecommunication company showing the daily call record details of customers: Customer_ID Customer Phone No. Balance 1 033XXXXX 300 2 033YYYYY 250 3 033ZZZZZZ 300 4 033AAAAA 1000 5 033BBBBB 80 6 033CCCCC 554 … … … Call_ID Customer_ID Dialed Phone Number Duration Call Charges 1 1 032ABCVD 1 minute 2 RS 2 1 032ABCVG 2 minutes 4 RS 3 1 032ABCVD 1 minute 2 RS 4 2 032ANNNN 3 minutes 6 RS 5 2 032AMMM 4 minutes 8 RS 6 3 033RRRRR 1 minute 2 RS … … … … … Due to certain performance factors company wants to de-normalize the tables using pre-joining technique. Table Information is given below: • Assume 1:4 record count ratio between customer Info (master) and Call record detail (detail). • Assume 15 million customers. • Assume 10 byte Customer_ID. • Assume 50 byte header for customer Info (master) and 80 byte header for Call record detail (detail) tables. You are required to perform the following tasks: • Calculate the Total space in GBs used with normalization. • Calculate the Total space in GBs used after de-normalization. Solution: With normalization: Total space used = 15 x 50 + 60 x 80 = 5.55 GB After de-normalization: Total space used = (80 + 50 – 10) x 60 = 7.2 GB
  • 0 Votes
    5 Posts
    2k Views
    zaasmiZ
    @Faaizaa said in CS614 Assignment 2 Solution and Discussion Spring 2020: Re: CS614 Assignment 2 Solution and Discussion Assignment No. 2 Semester: Spring 2020 CS614 – Data Warehousing Total Marks: 15 Due Date: June 17, 2020 Objectives: After completing this assignment, the students will be able to: • De-Normalize the given table using horizontal splitting technique • Calculate the Total space used with normalization. • Calculate the Total space used after de-normalization. Instructions Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: • Assignment is submitted after due date. • Submitted assignment does not open or file is corrupt. • Assignment is copied (From internet/ to from students). • Assignment is submitted other than word format (.doc, .docx). Assignment Question No. 1 Consider the following table having the information of students of a university: Student ID Student Name Campus ID Student Age Degree Program 1 Ali VLHR01 27 MS 2 Kamran VISB01 24 BS 3 Akmal VRWP01 24 BS 4 Ahmad VLHR01 26 MS 5 Rehan VISB01 23 BS 6 Rizwan VRWP01 29 MS 7 Umer VISB01 25 BS 8 Javed VLHR01 26 MS You are required to completely de-normalize the above table using “horizontal splitting” on the basis of Degree Program. Question No. 2 Consider the following normalized tables for a telecommunication company showing the daily call record details of customers: Customer Info Customer_ID Customer Phone No. Balance 1 033XXXXX 300 2 033YYYYY 250 3 033ZZZZZZ 300 4 033AAAAA 1000 5 033BBBBB 80 6 033CCCCC 554 … … … Call record detail Call_ID Customer_ID Dialled Phone Number Duration Call Charges 1 1 032ABCVD 1 minute 2 RS 2 1 032ABCVG 2 minutes 4 RS 3 1 032ABCVD 1 minute 2 RS 4 2 032ANNNN 3 minutes 6 RS 5 2 032AMMM 4 minutes 8 RS 6 3 033RRRRR 1 minute 2 RS … … … … … Due to certain performance factors company wants to de-normalize the tables using pre-joining technique. Table Information is given below: • Assume 1:4 record count ratio between customer Info (master) and Call record detail (detail). • Assume 15 million customers. • Assume 10 byte Customer_ID. • Assume 50 byte header for customer Info (master) and 80 byte header for Call record detail (detail) tables. You are required to perform the following tasks: • Calculate the Total space in GBs used with normalization. • Calculate the Total space in GBs used after de-normalization. Deadline: Your assignment must be uploaded on VULMS on or before June 17, 2020. While June 18, 2020 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email. Solution file link
  • 0 Votes
    2 Posts
    1k Views
    zaasmiZ
    CS614 ASSIGNEMNT NO 01 Solution [image: 1j7dUIA.png] [image: ZXcDeiM.png] [image: syb0jO9.png] [image: tMSeWA2.png] [image: UWBEhvV.png] [image: EYSG6fO.png] [image: hQj3oOC.png] [image: LpvgqH8.png] CS614 assignment Solution spring 2020.xlsx
  • 0 Votes
    3 Posts
    2k Views
    zareenZ
    [image: IuNus9P.png] [image: cEvN2SW.png] [image: DwDEh3n.png] [image: 8yoKgvf.png] [image: mmFrSqn.png]
  • 0 Votes
    1 Posts
    961 Views
    No one has replied
  • 0 Votes
    2 Posts
    1k Views
    zareenZ
    @zareen said in CS614 Assignment 2 Solution and Discussion: Calculate the total space reserved in memory using normalization Q. 1. Calculate the total space reserved in memory using normalization1. Calculate the total space reserved in memory using normalization Q. 1 Solution: Total space used = 10 (Million records) x 40 (Bytes header) + 110 (Million records) x 70 (Bytes header) = (1000000040) + (11000000070) =8,100,000,000 = 8.1 GB Q. 2. Calculate the total space reserved in memory after de-normalization using pre-joining technique Q. 2 Solution: Total space used = (70 + 40 – 10) (Bytes header) x 110 (Million records) =100*110000000 =11,000,000,000 = 11 GB
  • 0 Votes
    3 Posts
    1k Views
    zareenZ
    @zareen said in CS614 Assignment 1 Solution and Discussion: Assignment No. 1 Semester: Fall 2019 CS614 – Data Warehousing Total Marks: 15 Due Date: November 14, 2019 Objectives: After completing this assignment the students will be able to: • Identify Database entities from a given scenario • Understand the database table structure • Normalize a database table up to 2nd normal form • De-normalize relationships using collapsing table technique Instructions Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: o Assignment is submitted after due date. o Submitted assignment does not open or file is corrupt. o Assignment is copied (From internet/ to from students). o Assignment is submitted other than word format (.doc, .docx). Assignment Question No. 1 Consider the following schema related to a Social Media website named as ‘userPosts’. You have to perform following tasks related to the provided schema: 1- Identify appropriate keys for following structure (Primary and/or foreign key(s)) 2- Convert this schema into 2 NF userPosts (userID, userName, password, address, postId, postDate, postContent) Question No. 2 Consider the following schemas relevant to a hotel booking website. You are required to De-Normalization the given schemas using Collapsing Tables Technique. roomVisitor (roomID, visitorCNIC, dateTime) roomCharges (roomID, spentDays, roomRent) Deadline: Your assignment must be uploaded on VULMS on or before November 14, 2019. While November 15, 2019 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email. Q.1 Answer: userDetails (userID, userName, password, address) posts(postID, postDate, postContent) userPosts (userID, postID) • userID and postID in schema / table ‘userPosts’ are foreign keys Q.2 Answer: roomVisitorCharges (roomID, visitorCNIC, dateTime, spentDays, roomRent)
  • CS614 Quiz No. 2 Solution and Discussion

    Solved CS614 - Data Warehousing cs614 quiz.2 solution
    34
    1 Votes
    34 Posts
    30k Views
    cyberianC
    @zareen said in CS614 Quiz No. 2 Solution and Discussion: 3_ Bill Inmon argues that requirements are well understood only after Data warehouse is populated _ pg285 Bill Inmon argues that requirements are well understood only after: “a thorough examination of the business processes and objectives.” Inmon emphasizes that understanding the business processes and objectives is crucial for designing an effective data warehouse. This thorough examination ensures that the data warehouse aligns with the actual needs and goals of the organization, leading to a more effective and relevant system.
  • 0 Votes
    5 Posts
    2k Views
    zaasmiZ
    Answer will be same after convert. [image: 1564758814304-84e0807a-616d-4c42-84a2-4f63289e5a4a-image.png] [image: 1564758789133-4476461b-9e74-4125-ad00-78dac6fb19df-image.png]
How to Build a $1,000/Month PAK VS BAN Live Live Cricket Streaming
File Sharing

1

Online

3.0k

Users

2.8k

Topics

8.2k

Posts
| |