Semester:
Fall 2016
|
Assignment
No. 1 Graded
Semester
Fall 2016
Data Warehousing– CS614 |
Total Marks: 10
|
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
2
|
Ms.
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
|
0 comments: