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 [email protected]
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 2 Solution Fall 2019 Ayra Suleman 0 175 11-28-2019, 11:41 PM
Last Post: Ayra Suleman
  CS614 Assignment Solution Fall 2019 Ayra Suleman 0 161 11-26-2019, 11:39 PM
Last Post: Ayra Suleman
  CS614 GDB Solution Spring 2019 Ayra Suleman 0 94 07-26-2019, 07:16 PM
Last Post: Ayra Suleman
  CS614 Assignment 2 Solutionn Spring 2019 Mishi Khan 0 194 05-31-2019, 02:21 AM
Last Post: Mishi Khan
  CS614 Assignment Solution Spring 2019 Mishi Khan 0 169 05-27-2019, 01:29 AM
Last Post: Mishi Khan
  CS614 Assignment Solution Spring 2019 Mishi Khan 0 188 05-15-2019, 10:16 PM
Last Post: Mishi Khan
  CS614 Assignment 2 Idea Solution Mishi Khan 0 418 02-01-2019, 01:43 AM
Last Post: Mishi Khan
  CS610 Quiz first solved 2016 Rubaisha(Moody Girl) 0 2,670 11-17-2016, 11:13 PM
Last Post: Rubaisha(Moody Girl)
  CS602 assignment solution idea 2016 Rubaisha(Moody Girl) 0 1,755 11-16-2016, 10:49 AM
Last Post: Rubaisha(Moody Girl)
  CS601 assignment_1 solution 2016 Rubaisha(Moody Girl) 0 1,365 11-16-2016, 10:31 AM
Last Post: Rubaisha(Moody Girl)



Users browsing this thread:
1 Guest(s)