We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS614 - Data Warehousing Assignment No. 1 Solution and Discussion Spring 2017 Due Date: May 04, 2017

You are a Senior Analyst in the IT department of a company manufacturing auto-mobile parts. The marketing VP is complaining about the poor response by IT in providing strategic information. Draft a proposal to him explaining the reasons for the problems and why a data warehouse would be the only viable solution?

Question 1:                                                                                                                                         [10 Marks]

 

Consider the below mentioned ER diagram containing 5 entities (Student, Course, Instructor, Department, and Degree).

Each entity has at least the following attributes:

 

Student: Student ID, Name, Gender, DOB, Address

Course : Course ID, Course Name, Specialization, Degree program

Instructor: Instructor ID, Instructor Name, Course ID, Course Name, Department Name, Degree program

Department: Department Name, Department Head, Degree program

Degree:  Degree Program, Department Name, Campus

 

 

There will be total 5 tables (Student, Course, Instructor, Department and Degree) for this ERD.

You are required to draw these 5 tables, fill them with your own particulars (details), and then De-normalize these tables into a single table using the De-normalization techniques you have studied so far.

 

 

 

 

 

Note: Deadline for Assignment submission is 4th May 2017.

 

Wish you best of Luck!

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 5605

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Attachments:

Replies to This Discussion

solution of this assignment

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

 

 

Assignment No.1

 

Cs614

 

Solution.Solution:

Student: Student ID,Name, Gender,DOB, Address

 

Student ID

Name

Gender

DOB

Address

1

Ali

Male

3-4-1996

House#1,

Street#2,Lahore

2

Amna

Female

5-6-1997

House#5,

Street#8, Karachi

3

Sana

Female

6-9-1995

House#10,

Street#1, Multan

Course:CourseID, CourseName, Specialization, Degreeprogram

 

CourseID

CourseName

Specialization

DegreeProgram

Cs101

Intriduction to

computing

Computer Science

Bs

sta301

Statistics and

probability

Statistics

MCS

Cs201

Introduction to

programming

Computer Science

BCS

 

 

Instructor:InstructorID,Instructor Name, CourseID, CourseName, Department Name, Degreeprogram

 

InstructorID

Instructor

Name

CourseID

Course

Name

Department

Name

Degree

Program

1

Muhammad

Faiz

Cs101

Intriduction to

computing

Computer

Science and

IT

Bs

2

UsmanAslam

sta301

Statistics and

probability

Statistics

MCS

3

Fatima Batool

Cs201

Introduction

to programming

Computer

Science and

IT

BCS

 

Department: Department Name, Department Head, Degreeprogram

 

Department Name

Department Head

DegreeProgram

Computer Science andIT

Muhammad Faisal

Bs

 

 

Statistics

UsnaKhalid

MCS

Computer Science andIT

FarooqKhan

BCS

 

 

 

 

Degree:  DegreeProgram, Department Name, Campus

 

DegreeProgram

Department Name

Campus

Bs

Computer Science andIT

Multan

MCS

Statistics

Karachi

BCS

Computer Science andIT

Lahore

Demonalization:

 

StudentID, Name, Gender, DOB, Address,CourseID, CourseName, Specialization, Degree program,InstructorID,Instructor Name,Department Name, Department Head, Campus

 

 

 

 

 

 

 

 

Thanks 

Thanks Manoo 

ye same ise tra banani h ya sql pay

joint wagra lahnay  hain

Cs614 assignment 1 solution 2017
Solution
Student: Student ID, Name, Gender, DOB, Address

Student ID Name Gender DOB Address
1 Amir Male 3-6-1994 House1 Lahore
2 Imran Male 4-7-1995 House1 Karachi
3 Sikandar Male 5-7-1996 House1 Multan

Course: Course ID, CourseName, Specialization, Degree program

CourseId CourseName Specialization Degree Program
Cs101 Introduction to computing Computer science BS

sTa301 Computing and statics Statics MCS
Cs201 Introduction to programming Computer science BCS

 
Instructor:InstructorID,Instructor Name, CourseID, CourseName, Department Name, Degreeprogram

InstructorID Instructor Name CourseID CourseName Department Name Degree Program
1 Mohammed Ahmed Cs101 Introduction to computing Computer science BS
2 Tan veer sTa301 Statics and computing Statics MCA
3 Usman Cs201 Introduction to programming Computer science BCS

Department: Department Name, Department Head, Degreeprogram

Department Name Department Head Degree program
Computer science Faisal BS
Statics and computing Usman khalid MCS
Computer science Farooq khan BCS


Degree:  DegreeProgram, Department Name, Campus

DegreeProgram Department Name Campus
BS Computer science Lahore
MCS Statics and computing Karachi
BCS Computer science Multan

Demoralization:
 
StudentID, Name, Gender, DOB, Address,CourseID, CourseName, Specialization, Degree program,InstructorID,Instructor Name,Department Name, Department Head, Campus

Any body tell me how can merge student table in any table which are given...... 

no common attribute found....... how can resolve it........

Idea solution:

Attachments:

sql p banani h

Guide line.....

01. first your can enroll student in course table.

02. merge table table student+course 

03. merge department+degree table 

04. merge table instructor+merge result 03

05. merge the table result 02+result 04

Denormalized Table after marging all the 5 tables 

Student ID

Name

Gender

DOB

Address

Course Id

Course Name

Specialization

Degree Program

Instr

ID

Instr

Name

Dep Name

Dep Head

Campus

Bc130402262

Iqbal

Male

24-11-1994

4B model town Lahore

CS101

Intro to

Computing

Computer

Science

BS

1

Muhammad Fiaz

IT

Muhammad

Faisal

Lahore

BC130401556

Wajahat

Male

23-4-1993

14-A st#4 garden town

CS614

Data

Warehousing

Computer

Science

BS

2

Zulfiqar ali

IT

Zulfiqar
ali

Lahore

BC130401555

Zuhaib

Male

4-6-1994

23-D mughalpura lahore

CS611

Software

Quality

Engineering

Computer

Science

BS

3

Abdul Mannan

IT

Abdul

Qadir

Lahore

Attachments:

RSS

Latest Activity

Naser Javed (BBIT-6) replied to + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
19 minutes ago
Naser Javed (BBIT-6) liked + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
20 minutes ago
+++STUDENT+++ commented on + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
32 minutes ago
+++STUDENT+++ liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
33 minutes ago
+++STUDENT+++ liked ϝ ι ყ α's discussion *خواتین.........XD XD *
39 minutes ago
彡JK彡 ❤️ replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
43 minutes ago
+++STUDENT+++ replied to ϝ ι ყ α's discussion What is Microsoft Excel..............???
43 minutes ago
+++STUDENT+++ liked ϝ ι ყ α's discussion What is Microsoft Excel..............???
43 minutes ago
Muhammad Umar replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
53 minutes ago
Muhammad Umar liked 彡JK彡 ❤️'s discussion ............ A public service message...........
54 minutes ago
+++STUDENT+++ replied to zohaib iftikhar's discussion ...* IS K BAGAIR MAIN APNI ZINDAGI KA TASAWER B NAHI KR SAKTA ...*
55 minutes ago
+++STUDENT+++ liked zohaib iftikhar's discussion ...* IS K BAGAIR MAIN APNI ZINDAGI KA TASAWER B NAHI KR SAKTA ...*
58 minutes ago
+++STUDENT+++ liked 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ Iuuoɔǝut+ replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
1 hour ago
+ Iuuoɔǝut+ replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service