Assignment No. 2
Semester Fall 2015
The assignment has been designed to develop your ability to design star schema and to estimate the rows in fact table.
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS614@vu.edu.pk
Do not post queries related to assignment on MDB.
Question 1 [15 Marks]
The Future Tech College has to design a star schema related to the grades for courses completed by the students. The tables with the attributes are as given below.
You have to;
You may use the MS Vision or any other similar tool to draw the Star Schema.
+ 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)
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.
i even can't understand the question. what does it mean by "Major".
any body who could give the better idea about this assignment
Handout notes page 104 - 118, just go through these pages.
ye schema bnana kis software main haii
you may use the MS Vision or any other similar tool to draw the Star Schema.
ap online bhi bna sakte hen .