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

www.vustudents.ning.com

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 01 Solution & Discussion Due Date:17-11-2016

CS614 Assignment No 01 Solution & Discussion Due Date:17-11-2016

Assignment No. 1 Graded Semester Fall 2016 Data Warehousing– CS614 Total Marks: 10 Due Date: 17-11-2016 Objective: This assignment has been designed to develop your ability to apply De-Normalization Techniques and principles to normalized data/tables. Instructions: Please read the following instructions carefully before solving & submitting the assignment: 1. The assignment will not be accepted after due date. 2. Zero marks will be awarded to the assignment that does not open or the file is corrupt. 3. The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format. 4. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet). 5. Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file. For any query about the assignment, contact only at CS614@vu.edu.pk Please do not post queries related to assignment on MDB. Question: [10 Marks] The four tables given below are in normalized form. You are required to de-normalize these tables and to combine them to a single table using demoralization techniques you have studied so far. Table#1 Student_ID Name Address/City Salutation ID BC1234 Ayesha Multan road, Lahore 1 MC2235 Adil Saleem Clifton Karachi 2 MC2236 Komel Masood G-12, Islamabad 3 MS3456 Kashif Hayatabad, Peshawar 2 Table#2 Salutation ID Salutation 1 Ms. 2 Mr. 3 Mrs. Table#3 Student_ID Course Code BC1234 CS101 BC1234 CS201 MC2235 CS201 MC2235 CS301 MC2236 CS101 MC2236 MGT101 MS3456 CS701 MS3456 CS702 Table#4 Course Code Course Name Instructor Campus CS101 Introduction to Computing Dr. Ijaz Lahore CS201 Computer Programing Dr. Saqib Karachi CS301 Data Structures Dr. Jamal Islamabad MGT101 Management Dr. Ali Islamabad CS701 Algorithms Dr. Hassan Lahore CS702 Automata Theory Dr. Atif Lahore Note: Deadline for assignment submission is 17th November 2016. Wish you best of Luck!

+ 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: 6163

.

+ 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

Aslam o alaikum Asif Bhai
Abi to raat b hony wale hy blky ho gay hy kindly upload full sollution plzzzzzzzzzzzzzz

Please find the attached file, it's the final de-normalized form of all tables given.

Attachments:

bhai aap ne is me 8 columns
bnay.aap ne salutation id ko miss q kia ha

wasif bhai ye solution bilkul theek hai kia ?

STUDENT_ID COURSE CODE COURSE NAME INSTRUCTOR NAME ADDRESS/CITY SALUATION ID SALUATION CAMPUS
BC1234 CS101 INTRODUCTION TO CUMPUTING Dr. Ijaz AYESHA MULTAN ROAD,LAHORE 1 MS. LAHORE
BC1234 CS201 CUMPUTER PROGRAMMING Dr. Saqib AYESHA MULTAN ROAD,LAHORE 1 MS. KARACHI
MC2235 CS201 CUMPUTER PROGRAMMING Dr. Saqib ADIL SALEEM CLIFTON KARACHI 2 MR. KARACHI
MC2235 CS301 DATA STRUCTURES Dr.Jamal ADIL SALEEM CLIFTON KARACHI 2 MR. ISLAMABAD
MC2236 CS101 INTRODUCTION TO CUMPUTING Dr. Ijaz KOMEL MASOOD G-12, ISLAMABAD 3 MRS. LAHORE
MC2236 MGT101 MANAGEMENT Dr.Ali KOMEL MASOOD G-12. ISLAMABAD 3 MRS. ISLAMABAD
MS3465 CS701 ALGORITHMS Dr.Hassan KASHIF HAYATABAD, PESHAWAR 2 MR. LAHORE
MS3456 CS702 AUTOMATA THEORY Dr.Atif KASHIF HAYATABAD, PESHAWAR 2 MR. LAHORE
Solution:

CS614 1st assignment solution

Attachments:

Complete solution

.doc document hi share kr deni thi :(

Yes .doc m submit krni hai

could you please define how it is wrong?

## Latest Activity

19 minutes ago
23 minutes ago
zohaib iftikhar and Mahrosh Ahmed are now friends
1 hour ago
2 hours ago
+ ! ! ! ❣ maho ❣ ! + posted a discussion

### logon sy b milta hun fasly b rakhta hun..

2 hours ago
faraz updated their profile
2 hours ago
3 hours ago
3 hours ago
3 hours ago
3 hours ago
5 hours ago
6 hours ago

## Today Top Members

1

2

3

### Awais

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

.