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: 61)
  


Possibly Related Threads...
Thread Author Replies Views Last Post
  Assignment Solutions Iram shahzad 2 18 Yesterday, 08:21 AM
Last Post: Rana
  CS301 Assignment 2 Solution - Spring 2017 Rana 0 247 05-17-2017, 08:54 PM
Last Post: Rana
  cs504 assignment 1 help needed Syed Muhammad Taha 3 129 05-10-2017, 04:44 PM
Last Post: Rana
  CS403 Assignment 1 help required Syed Muhammad Taha 3 119 05-06-2017, 06:50 PM
Last Post: Rana
  CS506 Assignment No1 Solved 2017 Rubaisha(Moody Girl) 0 225 05-05-2017, 02:11 PM
Last Post: Rubaisha(Moody Girl)
Thumbs Up cs402 Assignment jamshed Ansari 1 105 05-03-2017, 06:05 PM
Last Post: Rana
  CS610 Assignment 1 Pakistani 3 360 05-03-2017, 01:50 PM
Last Post: jamshed Ansari
  CS601 Data Communication Assignment Solution Rana 2 1,225 02-07-2017, 06:00 PM
Last Post: Pakistani
  CS301 Assignment 3 Solution Rana 8 1,327 01-21-2017, 02:25 PM
Last Post: Rana
  CS601 Assignment 3 Solution Rana 0 488 01-12-2017, 01:41 PM
Last Post: Rana



Users browsing this thread:
1 Guest(s)