Transcript Document
PROJECT ”Development of Software for Online Information System on Personnel Management in ICAR.” INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Objectives To design and develop database required for Manpower of ICAR set up. To design and develop user interface for online data entry and updating. To design and develop reports and queries for manpower information management. INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 ARCHITECTURE The system is a web-based application Based on client-server three tier distributed structure technology Can be accessed from any node on the Internet through a web-browser INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Methodology 1. Client Side Interface Layer (CSIL) 2. Server Side Application Layer (SSAL) 3. Database Layer (DBL) CSIL (HTML, VBScript) Web-Browsers CSIL-SSAL Interface SSAL (ASP) SSAL-DBL Interface Server ODBC DBL (SQL Server) Database Server INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Development of the Database Database has been developed using SQL server 2000. The Relational Database approach is used to design the database. The fundamentals of Normalization theory have been used to normalize the different tables of the database. The main 39 entities of personal information from referential, personal and professional constitutes different tables with full attributes. Ten master tables are designed to provide the real world values. INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 ARCHITECTURE System is a web-based application, based on ClientServer three tier distributed structure technology. INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Organisation of Information http://www.iasri.res.in/permisnet (Home Page) Management Reports Data Management Authentication Form (Authorized user from institute) Divisional Reports Institute Reports ICAR Reports Add/Update Institute Information Scientist Scientific Services has been classified under 68 agricultural disciplines Add/Update Personnel Information ( personal, professional and referential attributes ) Type of Service Individual Personnel Reports User Customized Reports Technical Technical services has been classified under 9 functional groups. Administration, Accounts and Supporting staff These services have been classified under Administration and Finance & Accounts. INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 System Design System has been designed into two modules: Data Management Deals with online entry and updating of information. Management Reports Provides information to managers at different levels to support the decision making process. INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Data Management Institute’s information on personnel and on institutional parameters are entered and updated by nodal officer at the institute, authorized by DBA Council’s parameters are entered by DBA Deletion of records can only be done by DBA INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Reports INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Management Reports at ICAR Level INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Management Reports at SMD Level INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Management Reports at Institute Level INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 User Customized Reports INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012 Data Status Available on 26,494 personnel. Scientists : 4,385 Technical : 7,386 Admin., Fin., Sup. : 14,723 On 18/10/05 INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE, NEW DELHI-110012