We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
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!
+ Click Here To Join also Our facebook study Group...How to Join Subject Study Groups & Get Helping Material?..
.+ 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?)
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.
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
CS614 1st assignment solution
.doc document hi share kr deni thi :(
Yes .doc m submit krni hai
could you please define how it is wrong?