Exp	PROJECT DESCRIPTION: The project was aimed at creating a Data Mart to provide Educational department to analyze educational history of an inmate the moment he enters the prison as well as tracks whether the Inmate completed his mandatory education programs or not. The enhancement was done on legacy system where they were unable to track the historical data of educational programs of inmates in the Database. Legacy non-integrated databases are a core to business processing which overrides the existing data instead of updating it. New Data Mart was designed, and Source and Target Data were Mapped to ensure that business rules were imposed to get an updated status history of the Inmates as well as their history. Integrated system would provide ease of access, analysis, transparency and enhanced reporting capabilities which had the complete details of the Education level of an Inmate when he enters the prison and whether the Inmate completed his mandate education while he was serving inside the prison.