On database normalization using user interface normal form

  • Authors:

  • Mohd Zainuri Saringat;Rosziati Ibrahim;Noraini Ibrahim;Tutut Herawan

  • Affiliations:

  • Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia, Johor, Malaysia;Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia, Johor, Malaysia;Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia, Johor, Malaysia;Department of Mathematics Eduction, Universitas Ahmad Dahlan, Yogyakarta, Indonesia

  • Venue:
  • ICIC'10 Proceedings of the 6th international conference on Advanced intelligent computing theories and applications: intelligent computing
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Database is important to ensure the data can be store, update and retrieve back. The famous data modelling using the Entity Relationship Model already introduced more than thirty years. However, designing a good database is still a big issue especially in designing optimum database because it is very hard to do consistency checking between system design and database design to fulfil user needs. In this paper, we propose an alternative method for designing optimum database system based on object oriented methodology. The schema table is extracted from class diagram and then the schema will be compared with the user interface to normalize the structure. Data sanitization is introduced to remove the unused attributes to provide final schema table.