Prototype Development of a Dimensional Model of Data Warehouse for the Engineering Education Information System in West Bengal, India

Abhijit Pramanik, Somsubhra Gupta

An attempt had been made to develop a prototype dimensional model of data warehouse for the Engineering Education Information System in West Bengal, India using Kimball’s methodology. A bus matrix has been established using fact tables and some selected dimension table. Depending on this a prototype of dimensional model based on the engineering education system has been established. Validation and testing also be adopted. This model may provide subject oriented data support for query servicing in order to smooth the progress of educational activities.