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

How Can Create this table in excel or sql

Please tell me

RSS

Latest Activity

+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked + !! SARAH's discussion Beauty Of Fear !!
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to + Iuuoɔǝut+'s discussion mard ka dil...
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked + Iuuoɔǝut+'s discussion mard ka dil...
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked 彡JK彡 ❤️'s discussion ............ A public service message...........
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked Whispering Soul's discussion شاہی جوڑے کی رکشہ میں آمد
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to +++LEARNER+++'s discussion Naseeb
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked +++LEARNER+++'s discussion Naseeb
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ replied to ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ ! ❤SΕNSΙТΙVΕ(∂ΕSΕЯТ ΡЯΙNCΕSS)❤ liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ Intel replied to + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ Intel liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
1 hour ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion Twaja farmaen
1 hour ago
+ Iuuoɔǝut+ liked + Iuuoɔǝut+'s discussion Internship Report on IBF Meezan Bank Pakistan
1 hour ago
+ Iuuoɔǝut+ posted discussions
1 hour ago
+ M.Tariq Malik left a comment for ghulam hussain
2 hours ago
+ M.Tariq Malik liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
2 hours ago
+ Iuuoɔǝut+ liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
2 hours ago
+ !! ATHER replied to + !! SARAH's discussion Beauty Of Fear !!
2 hours ago
+ M.Tariq Malik liked 2.O's discussion Difference B/w Null and Undefined (Only Devs can understand) :P :P
2 hours ago

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

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