CS614 Data Warehousing Assignment 1 Solution Fall 2014

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:

  1. Scholarship for different universities within Pakistan.
  2. Scholarship for different universities abroad Pakistan.

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.

  1. Accepts research proposal and send it to the  admission committee
  2. Proposed certain changes to be made in research proposal.

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:

 

Question:

Consider the above scenario and draw a comprehensive ERD.

DOWNLOAD SOLUTION HERE
loading...