Analysis of Database of University Examination System: A Case Study

Authors

  • Singh B Research Scholar, Department of Computer Science H.P.U. Shimla
  • AJ Singh Professor, Department of Computer Science H.P.U. Shimla
  • Chauhan R System Administrator, Dept. UIIT, H.P.U. Shimla

Keywords:

Database, Data Quality, Information System, University Examination System

Abstract

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.

References

Judd, Charles and, McCleland, Gary. ''Data Analysis''. Harcourt Brace Jovanovich. ISBN 0-15-516765-0. 1989

O'Neil, Cathy and, Schutt, Rachel. ''Doing Data Science''. O'Reilly. ISBN 978-1-449-35865-5. 2

R. K. Yin . Case Study Research, Design and Methods, 3rd ed. Newbury Park, Sage Publications, 2002.

Huang, Huan-Tsae, Lee, Y. W. and Wang, R. Y. Quality information and knowledge, Prentice Hall PTR. 1999

H. Korth, & A. Silberschatz,., ''Database System Concepts''. 5th ed., McGraw-Hill, ISBN 007-124476-x. 2006

R. Elmasri. B. Navathe., ''Fundamental of Database Systems'', Fifth Edition, Published by Pearson Education, ISBN 978-81-317-1625-0. 2009

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

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

M. Blaha, ''Referential Integrity is important for databases'', Modelsoft Consulting Corp, www.odbms.org/experts.aspx. 2008 Accessed on: 15 July 2010.

K. Tangwongson, P. Himabindu, M.Kaminsky, '' Efficient Similarity Estimation for Systems Exploiting Data Redundancy''. In Proc. IEEE INFOCOM, (San Diego, CA), Mar. 2010.

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.

Downloads

Published

2025-11-11

How to Cite

[1]
B. Singh, A. Singh, and R. Chauhan, “Analysis of Database of University Examination System: A Case Study”, Int. J. Comp. Sci. Eng., vol. 4, no. 5, pp. 34–40, Nov. 2025.

Issue

Vol. 4 No. 5 (2016): IJCSE Special Issue July Edition

Section

Survey Article

License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.