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.
This is type of ERD. It should be acceptable I think.
Is it graded or non-graded
See instructor's reply in MDB;
|Subject: First Assignment|
Also please tell is first assignment Graded ?
Yes All the assignments will be graded.
tu phir assignment file main rules for marking mai sir ne ye kiyon likha
MDB mn hr jaga yahe likha hy k'Graded hy', Assignment mn 2 baten ki huen hn. But v should make it for practice n revision.
Hamda kia ye cOmplete solution hai ????
Gud work Humda. Thx fr sharing. keep it up.
Humda 1 entity typ ki relation ship thek nae lg rhe. Member ship view scholarship then how can scholarship aply for proposal?
Member can aply fr proposal is it not?
Yes we can uze Composite attributes in ERD.
Yesh ya complete solution h