In recent times, data warehousing achieved tremendous attention in various organizations including universities to analyze important aspects of their academic environment. In this paper, we present an automatic design system to integrate the functionality of both the requirement-driven and data-driven approaches. In addition, it is established on the basis of i* framework and Dimensional Fact Model (DFM) which is used to design the actions of actors, and the relationship existing among the

more »

... s in DW (Data Warehouse) environment. Furthermore, the proposed system introduces and illustrates an automatic design technique based on a logical programming to perform the integration of different data sources using UML multidimensional schemas that are reconciled with data sources to improvise the conceptual quality.