CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019

[ayesha]

	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.

 

[+ M.Tariq Malik]

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

Discussed & be touched with this discussion. After discussion a perfect solution will come in a result at the end.

 

 

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Then copy Questions from assignment file and paste in Discussion.

 

+ http://bit.ly/vucodes (For Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (For Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here to Join (Our facebook study Group)

[Mutasadiq Iqbal]

CS614 assignment Solution accurate solution

[+ M.Tariq Malik]

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)

 

 

 

Solution:

 

 

 

Primary keys: primary key in UserData will be userID

 

Foreign Keys: in post Data will be userID

 

 

 

In this way two tables will be created,

 

 

 

User Table:

 

 

UserID(P-K)	UserName	Password	Address
01	Laraib Abid	Laly123	H# 92, St# 8, Fazalpark, shahdra,CS614 Assignment solution LHR
02	Asad Mahmood	Asad1986	H#112,St#87,Bagumkot, Lahore
03	Abdullah Ahmed	Abdul1965	H#1024,Guraiz Colony,Scheme-iii, RWP

 

 

Post Table:

PostID(F-K)	PostDate	PostContent	UserID(F-K)
201	11-Nov-018	I am a student of BSCS at virtual university	01
202	12-Nov-018	I am a job person but along with Studies(BS mass communication) at virtual university	02
203	13-Nov-018	I am a student of BS-Management at virtual university	03

 

 

 

 

 

 

 

 

 

 

 

 

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)

 

 

 

Solution:

 

 

 

Room Visitor:

 

 

RoomID	VisitorCNIC	DateTime
01	35303-0545781-3	22-07-019 22:00
02	35202-0546781-9	23-07-019 18:50
03	32202-0565781-4	25-07-019 14:30

 

 

Room Charges

 

 

RoomID	SpendDays	RoomRent
01	03	6000
02	06	12000
03	12	24000

 

 

                        De-Normalization

RoomID	VisitorCNIC	SpendDays	DateTime	RoomRent
01	35303-0545781-3	03	22-07-019 22:00	6000
02	35202-0546781-9	06	23-07-019 18:50	12000
03	32202-0565781-4	12	25-07-019 14:30	24000

[Mani Siddiqui BS VIII]

??

[Somo Khan]

Need solution of cs614 assignment fall 2019

[+ M.Tariq Malik]

CS614 Assignment 1 Solution

link below 

CS614 Assignment 1 Solution

[IRUM]

cs614 ki assignment solution agr kisi k pass hai to plzz full solution link send kar dain

[A4APPLE]

wrong soloution shared.  please soloution na ho b ho proper guide line share kr diya kary. ya helping material. dont share wrong solutions.

[IRUM]

 CS614 KI SOLUTION FILE.PLZZZ DATA ZROR CHANGE KAR DENE WARNA ZERO MARKS MILAY GAY SAB KO

[+ M.Tariq Malik]

CS614 Assignment#01 Solution Fall 2019

Link below 

CS614_Solution_Assignment_01_Fall_2019

[+ M.Tariq Malik]

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)

 

 

 

Solution:

 

 

 

Primary keys: primary key in UserData will be userID

 

Foreign Keys: in post Data will be userID

 

 

 

In this way two tables will be created,

 

 

 

User Table:

 

 

UserID(P-K)	UserName	Password	Address
01	Laraib Abid	Laly123	H# 92, St# 8, Fazalpark, shahdra,CS614 Assignment solution LHR
02	Asad Mahmood	Asad1986	H#112,St#87,Bagumkot, Lahore
03	Abdullah Ahmed	Abdul1965	H#1024,Guraiz Colony,Scheme-iii, RWP

 

 

Post Table:

PostID(F-K)	PostDate	PostContent	UserID(F-K)
201	11-Nov-018	I am a student of BSCS at virtual university	01
202	12-Nov-018	I am a job person but along with Studies(BS mass communication) at virtual university	02
203	13-Nov-018	I am a student of BS-Management at virtual university	03

 

 

 

 

 

 

 

 

 

 

 

 

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)

 

 

 

Solution:

 

 

 

Room Visitor:

 

 

RoomID	VisitorCNIC	DateTime
01	35303-0545781-3	22-07-019 22:00
02	35202-0546781-9	23-07-019 18:50
03	32202-0565781-4	25-07-019 14:30

 

 

Room Charges

 

 

RoomID	SpendDays	RoomRent
01	03	6000
02	06	12000
03	12	24000

 

 

                        De-Normalization

RoomID	VisitorCNIC	SpendDays	DateTime	RoomRent
01	35303-0545781-3	03	22-07-019 22:00	6000
02	35202-0546781-9	06	23-07-019 18:50	12000
03	32202-0565781-4	12	25-07-019 14:30	24000