Procedural Database Normalization Level Validation for Electronic Certificate Issuance

Authors

  • Mohammad Hanif Farhad
  • Hafiz Mohd Sarim
  • Bahari Bin Idrus

Keywords:

database normalization levels, fields recognition and the replacement, database efficiency enhancement for normalization, validation procedure.

Abstract

The Ministry of Communication and IT (MCIT) conducts computer training course in seven provinces of Afghanistan. These six months training courses taught computer packages for the employees of the Ministry and others sectors. At the end of this course, each participant receives a computer certificate called ECP (Electronic Certificate Printing). The current ECP issuance process faces severe problems due to the lack of procedures to validate database normalization levels in databases sent by training centers. Importation of data from non-verified database into the ECP Database has produced a mass of redundant data in an active system that cannot be redesigned from scratch. The primary consequence of this problem is that the officials in the administration office cannot find the relevant data about each student quickly, because the proper field and tables from the unverified database couldn

References

A. Embong, Normalization .Database system.Kuantan.Prnerbit.2010, PP. 215-179-170-100-99-98-21.

A. Jaya. and G Sunitha. A Knowledge Based Approach for Automatic Database Normalization, International Journal of Advanced Research in Computer Engineering &Technology (IJARCET) Volume 2. No 5. May.2013,PP. 1816.

Adacore, Yannick Moy, Emmanuel Ledinot. Dassault. Herv

C. Vitalie. Determination of the normalization level of database schemas through equivalence classes of attributes, Computer Science, Journal 2008, Moldova, vol.17, no,2(50), PP. 125.

E.M. Arvacheh. A Study of Segmentation and Normalization for Iris Recognition System. Thesis Presented to the University of Waterloo. Ontario, Canada, 2006, PP. 5-6.

J. Morufu .SQL Database, Information Technology. SQL Database, thesis. June. 2010, PP. 16-17

J. Patel. Turbocharging DBMS Buffer Pool Using SSDs Jaeyoun do University of Wisconsin-Madison. DonghuiZhang MicrosoftJimGraySystems Lab. University ofWisconsin Madison11.June, 2010, PP 12-16.

M. Demba. Algorithm for Relation Database Normalization up to 3N International Journal of Database

Management Systems Department of Computer Science & Information. Aljouf University Sakaka. Kingdom of Saudi Arabia IJDMS Vol.5. No.3. June 2013. PP 39.

M. Patwardhan. Dhabe, and Asavari. LEVEL Diagrammatic approach for Complete Automation of Relation

DatabaseNormalization at Conceptual Level,International Journal. Nov 2010, PP. 141-142- 143.

P.B Alappanavar. Radhika. G and Srishti Hunjan. Automating The Normalization Process For Relational

Database Model, International Journal February 2013, PP. 1826-1827.

Downloads

Published

2014-06-01

How to Cite

Farhad, M. H., Sarim, H. M., & Idrus, B. B. (2014). Procedural Database Normalization Level Validation for Electronic Certificate Issuance. International Journal of Sciences: Basic and Applied Research (IJSBAR), 16(1), 251–260. Retrieved from https://gssrr.org/index.php/JournalOfBasicAndApplied/article/view/2286

Issue

Vol. 16 No. 1 (2014)

Section

Articles

License

Authors who submit papers with this journal agree to the following terms.