We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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

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.

 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 2272

.

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

+ Click Here To Join (Our facebook study Group)

Attachments:

Replies to This Discussion

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)

CS614 assignment Solution accurate solution

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

??

Need solution of cs614 assignment fall 2019

CS614 Assignment 1 Solution

link below 

CS614 Assignment 1 Solution

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

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

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

Attachments:

CS614 Assignment#01 Solution Fall 2019

Link below 

CS614_Solution_Assignment_01_Fall_2019

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

RSS

Latest Activity

Jabra updated their profile
15 minutes ago
+ ! ! ! "EF" ! ! ! updated their profile
20 minutes ago
Sadia Nasir replied to + M.Tariq Malik's discussion How to Prepare The Mid Term Exams & Study in VU
57 minutes ago
SILA posted a discussion
1 hour ago
Abeer posted a status
"koi student hai cs619 final year project ka,jis ka project locating a tutor ho?"
2 hours ago
Asad posted discussions
2 hours ago
Asad replied to Asad's discussion انتظار
2 hours ago
MCS 2019 and Nimra zahid are now friends
2 hours ago
Mani Siddiqui BS VIII liked zohaib iftikhar's discussion ...*...* TERI ZAT KI RASAI TAK ...*...*
2 hours ago
Amina waqar joined + M.Tariq Malik's group
3 hours ago
+ ! ! S σ η g l replied to +¢αяєℓєѕѕ gιяℓ's discussion Me & Mid Term :-P
3 hours ago
Jabra posted a discussion
4 hours ago

Today Top Members 

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.