CS614 Assignment No. 1 Solution and Discussion Fall 2014 (Graded)Due Date 18-11-2014
Data warehousing (CS614)
Assignment # 1 (GRADED)
Total marks = 20
Deadline Date: 18-11-2014
Please carefully read the following instructions before attempting the assignment.
Rules for Marking
It should be clear that your assignment would not get any credit if:
1) You should consult recommended books to clarify your concepts as handouts are not sufficient.
2) You are supposed to submit your assignment in .doc format. Any other formats like scan images, PDF, Zip, rar, bmp, docx etc will not be accepted
3) You are advised to upload your assignment at least two days before Due date.
4) This assignment file comprises of Seven (3) pages.
5) Assignment is non graded and will not contribute any marks in final grades
Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the deadline to avoid inconvenience later on.
For any query please contact: CS614@vu.edu.pk
VUScholarship Management system
VUScholarship is a financial grant database for students from all areas of Pakistan. We will secure all corners of the country to locate awards that will design to assist students who want to gain financial add/grant regarding higher education and professional degrees.
Our system will mainly manage two types of scholarship:
The whole scenario/procedure will be as follows:
The applicant will first apply for membership of the system by entering his/her information. When he/she becomes a member of our system, he/ she would be able to view different scholarships available currently.
After choosing scholarship type (within Pakistan or abroad the country), he/she will have to fill a form by entering detail information (Personal, academics, publications etc), name of country in case of foreign scholarship and name of his / her proposed adviser in the concern department. The applicant must submit the filled application form along with his / her research proposal. VUScholarship system will check the eligibility of the applicant for the applied scholarship and if found eligible our system will transfer the application to the concerned department of the chosen university.
The adviser will review his / her research proposal, and will take one of the two actions.
In case, faculty advisor accepts the proposal, he will send letter of support to the applicant and to the admission committee, if it is not the case the applicant will update his / her proposal and will send the updated proposal again to the faculty advisor.
The committee then accepts or rejects the admission and informs the applicant about his status.
A rough diagram of the system is given below:
Consider the above scenario and draw a comprehensive ERD.
+ 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)
koi tu comlete solution upload kr do
i think its not ERD its Class Diagram ......
what you say ?
It came with a short period of time.
Someone, Please upload the solution
Please upload the solution
ye check ker dy koe nd mistakes bta dy plzzzzzzzzz
sir Waleed ap sirf compliment hi de ry ho
khud kuch kr k dikha do
ya teek ni h asgnment coz is m kch b explain ni h tek sy DBMS waly relationship show ni keye h
1 to 1
1 to many etc waly atributes r entities b ni complet na scholarship add ni keya h kch related ni h asgnments sy is m