CS614 Data Warehousing Assignment No. 1 Solution and Discussion Fall 2014

[Vuhelper]

CS614 Data Warehousing Assignment No. 1 Solution and Discussion Fall 2014 (Graded)


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:

Scholarship for different universities within Pakistan.
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.

Accepts research proposal and send it to the admission committee
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:


[ATTACH=CONFIG]24081[/ATTACH]

[Vuhelper]

Entity-Relationship Diagram (ERD)
An entity-relationship diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.
The elements of an ERD are:
Entities
Relationships
Attributes
Steps involved in creating an ERD include:
Identifying and defining the entities
Determining all interactions between the entities
Analyzing the nature of interactions/determining the cardinality of the relationships
Creating the ERD

[Vuhelper]

CS614 Data Warehousing Assignment No. 1

[ATTACH=CONFIG]24099[/ATTACH]