The database of information system of any organization store crucial information. Organizations are considering this stored information as asset, because the information provided by the organization's information system play an important role in its functioning and also in the decision making processes. Depending on the availability of quality of information, administrative authorities of organization can take right decision for its stakeholders and for its better functioning. Keeping this in mind, present paper analysed the database of the University Examination System of Himachal Pradesh University. Data stored in the database of examination system is analysed and number of discrepancies are revealed in the data. There is lot of redundant and inconsistent data stored in the examination database. Upon analysing the data, it was found that there are number of fields in the database that store the redundant data, significant number fields are found empty besides, few constraints has been enforced on the majority of data. Poor database design is one of many factor that contributes to such problems. This paper also analyses the structure of relational table that lead to database of University Examination system and in the last highlight the findings of analysis.

Database, Data Quality, Information System, University Examination System

[1] Judd, Charles and, McCleland, Gary. ''Data Analysis''. Harcourt Brace Jovanovich. ISBN 0-15-516765-0. 1989
[2] O'Neil, Cathy and, Schutt, Rachel. ''Doing Data Science''. O'Reilly. ISBN 978-1-449-35865-5. 2
[3] R. K. Yin . Case Study Research, Design and Methods, 3rd ed. Newbury Park, Sage Publications, 2002.
[4] Huang, Huan-Tsae, Lee, Y. W. and Wang, R. Y. Quality information and knowledge, Prentice Hall PTR. 1999
[5] H. Korth, & A. Silberschatz,., ''Database System Concepts''. 5th ed., McGraw-Hill, ISBN 007-124476-x. 2006
[6] R. Elmasri. B. Navathe., ''Fundamental of Database Systems'', Fifth Edition, Published by Pearson Education, ISBN 978-81-317-1625-0. 2009
[7] A. J. Singh, & R. Chauhan, ''E-Government Databases: A Retrospective Study'', Indian Journal of Computer Science and Engineering, Vol 1 No 2, 66-73, ISSN: 0976-5166. 2011
[8] L. Davidson, ''Ten Common Database Design Mistakes'', http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes.On-line, Accessed on : 22 July, 2010
[9] M. Blaha, ''Referential Integrity is important for databases'', Modelsoft Consulting Corp, www.odbms.org/experts.aspx. 2008 Accessed on: 15 July 2010.
[10] K. Tangwongson, P. Himabindu, M.Kaminsky, '' Efficient Similarity Estimation for Systems Exploiting Data Redundancy''. In Proc. IEEE INFOCOM, (San Diego, CA), Mar. 2010.
[11] Loser, C. Legner, and D. Gizanis, ''Master Data Management for Collaborative ServiceProcesses'', http://www.alexandria.unisg.ch/EXPORT/DL/Christine_Legner/28091.pdf, Accessed on 28 Jan., 2010.