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: