CS614 complete solution of assignment 1 2016
#1
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!


Attached Files
.docx   614 complete solution.docx (Size: 15.26 KB / Downloads: 69)
  


Possibly Related Threads...
Thread Author Replies Views Last Post
  CS614 Assignment Solution Spring 2019 Mishi Khan 0 7 Today, 01:29 AM
Last Post: Mishi Khan
  CS614 Assignment Solution Spring 2019 Mishi Khan 0 55 05-15-2019, 10:16 PM
Last Post: Mishi Khan
  CS614 Assignment 2 Idea Solution Mishi Khan 0 220 02-01-2019, 01:43 AM
Last Post: Mishi Khan
  CS610 Quiz first solved 2016 Rubaisha(Moody Girl) 0 2,425 11-17-2016, 11:13 PM
Last Post: Rubaisha(Moody Girl)
  CS602 assignment solution idea 2016 Rubaisha(Moody Girl) 0 1,562 11-16-2016, 10:49 AM
Last Post: Rubaisha(Moody Girl)
  CS601 assignment_1 solution 2016 Rubaisha(Moody Girl) 0 1,003 11-16-2016, 10:31 AM
Last Post: Rubaisha(Moody Girl)
  Cs614 lec 6 Normalization topic Rubaisha(Moody Girl) 0 908 09-27-2016, 03:26 PM
Last Post: Rubaisha(Moody Girl)
  cs604 assignment complete solution Rubaisha(Moody Girl) 0 1,570 05-12-2016, 07:50 PM
Last Post: Rubaisha(Moody Girl)
  Cs601 complete solution Rubaisha(Moody Girl) 0 1,287 05-10-2016, 11:43 AM
Last Post: Rubaisha(Moody Girl)



Users browsing this thread:
1 Guest(s)