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


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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 Follow the New Added Discussions at Your Mail Address?

+ 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: 5622

.

+ 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

+ M.Tariq Malik liked + M.Tariq Malik's discussion Mid Term Past Papers Made By WAQAR & Solved By HADI
1 minute ago
+ M.Tariq Malik's 5 discussions were featured
1 minute ago
+ M.Tariq Malik posted discussions
1 minute ago
+ ! ! ! ! ! ! ! ! ! ! ! ! ! replied to Alishba's discussion Nikkah Mubarak To <3 !! 'JS' !! <3
14 minutes ago
MIRZA UMER BAIG liked Saniya Shahbaz's profile
16 minutes ago
MIRZA UMER BAIG left a comment for Saniya Shahbaz
17 minutes ago
Charming HaDi liked ++PrInCeSss++'s profile
25 minutes ago
hareem mughal posted a photo
30 minutes ago
+ " J ɨ y α •" ⋆ replied to + " J ɨ y α •" ⋆'s discussion Let's celebrate the Birthday of our Beloved Mod + "αяsαℓ " Ќąƶµяɨ •"
30 minutes ago
khaaniii posted a photo
30 minutes ago
+¢αяєℓєѕѕ gιяℓ liked Alishba's discussion Nikkah Mubarak To <3 !! 'JS' !! <3
31 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to Alishba's discussion Nikkah Mubarak To <3 !! 'JS' !! <3
31 minutes ago

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

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

.