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

How Can Create this table in excel or sql

Please tell me

RSS

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

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

.