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


Possibly Related Threads...
Thread Author Replies Views Last Post
  CS601 Data Communication Assignment Solution Rana 0 490 11-26-2016, 03:27 PM
Last Post: Rana
  CS610 Quiz first solved 2016 Rubaisha(Moody Girl) 0 150 11-17-2016, 11:13 PM
Last Post: Rubaisha(Moody Girl)
Lightbulb Need CS502 Assignment no 1 solution Adorable Pakhtoon 3 231 11-17-2016, 04:21 PM
Last Post: Rubaisha(Moody Girl)
  CS502 assignment 1 Solution 2016 Rubaisha(Moody Girl) 0 680 11-17-2016, 04:18 PM
Last Post: Rubaisha(Moody Girl)
  CS602 assignment solution idea 2016 Rubaisha(Moody Girl) 0 201 11-16-2016, 10:49 AM
Last Post: Rubaisha(Moody Girl)
  MGT101 assignment solution 2016 Rubaisha(Moody Girl) 0 228 11-16-2016, 10:39 AM
Last Post: Rubaisha(Moody Girl)
  CS401 assignment 1 solution of question 1 Rubaisha(Moody Girl) 0 54 11-16-2016, 10:36 AM
Last Post: Rubaisha(Moody Girl)
  CS601 assignment_1 solution 2016 Rubaisha(Moody Girl) 0 114 11-16-2016, 10:31 AM
Last Post: Rubaisha(Moody Girl)
  CS302 Assignment Solution Rana 8 681 11-15-2016, 05:28 PM
Last Post: Rana
  CS304 Assignment 1 Solution - Fall 2016 Rana 1 509 11-10-2016, 08:45 AM
Last Post: Lahori



Users browsing this thread:
1 Guest(s)