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

What is the purpose of creating this discussion?

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.

Anyone have idea about this assignment ????

please give some idea for solve this assignment ?????????

Batool and sara if u have any idea then please share 

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... How to Find Your Subject Study Group & Join .... 

After De-Normalization the Final Table 

Student ID, Student Name, Gender, DOB Address, Course ID, Course Name, Specialization, Degree Program, Instructor ID, Instructor Name, Department Name, Department Head, Campus.

Discuss if i'm wrong 

Dani YOur solution seems to be good according to pre-joining technique 

I need Solution Please Help 

please solve this assignment my fellows.

Dear How Can I do 

guise plz help

RSS

Latest Activity

+ "αяsαℓ " Ќąƶµяɨ •" replied to +¢αяєℓєѕѕ gιяℓ's discussion Jin sey Mohabbat Ho.....
12 seconds ago
+ "αяsαℓ " Ќąƶµяɨ •" liked +¢αяєℓєѕѕ gιяℓ's discussion Jin sey Mohabbat Ho.....
23 seconds ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + ! ! nO pAnGa's discussion Read this out Loud !!!!!!!!!
44 seconds ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + ! ! nO pAnGa's discussion Read this out Loud !!!!!!!!!
51 seconds ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
1 minute ago
+ "αяsαℓ " Ќąƶµяɨ •" liked 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
1 minute ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion غیر پھر غیر، درگزر کر دے - کون روکے زبان اپنوں کی
1 minute ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + M.Tariq Malik's discussion غیر پھر غیر، درگزر کر دے - کون روکے زبان اپنوں کی
2 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + Iuuoɔǝut+'s discussion عشق
2 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + Iuuoɔǝut+'s discussion عشق
2 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion Follow the Main Forum & Study Groups New Added Discussions at Your Mail Address
2 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + M.Tariq Malik's discussion Follow the Main Forum & Study Groups New Added Discussions at Your Mail Address
2 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion VIRTUAL UNIVERSITY OF PAKISTAN ORGANIZED AAOU 2019
3 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + M.Tariq Malik's discussion VIRTUAL UNIVERSITY OF PAKISTAN ORGANIZED AAOU 2019
3 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion Fall 2019- 2nd Merit List of Candidates Eligible for Admission
3 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion ENG201 Handouts With Highlights Important Questions + MCQs
3 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + M.Tariq Malik's discussion Fall 2019- 2nd Merit List of Candidates Eligible for Admission
3 minutes ago
+ M.Tariq Malik's 3 discussions were featured
3 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion Fall 2019 2nd Merit List of Candidates Eligible for Admission
3 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" liked + M.Tariq Malik's discussion Fall 2019 2nd Merit List of Candidates Eligible for Admission
4 minutes ago

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

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