Excel-database converting system using data normalization technique

This paper is intended to present an application system which can facilitate users in converting from Excel spreadsheet to database structure by using data normalization technique. It provides users with an automated system that can develop a database in its third normal form (3NF) from an Excel spr...

Full description

Main Authors: Ahmad, R., Saknakosnak, P., Hooi, Y.K.
Format: Article
Institution: Universiti Teknologi Petronas
Record Id / ISBN-0: utp-eprints.31715 /
Published: Springer Verlag 2014
Online Access: https://www.scopus.com/inward/record.uri?eid=2-s2.0-84958550996&doi=10.1007%2f978-981-4585-18-7_3&partnerID=40&md5=e7307132c998e1dd9f2cdc65a33c5883
http://eprints.utp.edu.my/31715/
Tags: Add Tag
No Tags, Be the first to tag this record!
id utp-eprints.31715
recordtype eprints
spelling utp-eprints.317152022-03-29T03:35:55Z Excel-database converting system using data normalization technique Ahmad, R. Saknakosnak, P. Hooi, Y.K. This paper is intended to present an application system which can facilitate users in converting from Excel spreadsheet to database structure by using data normalization technique. It provides users with an automated system that can develop a database in its third normal form (3NF) from an Excel spreadsheet. There are two major problems of Excel spreadsheet that are emphasized in this project which are data redundancy and update anomaly. Prototyping-based methodology is used in order to develop this system. The system just creates the SQL codes for creating the database structure and populating the database; however, how the users make use of it such as interface for database interaction is not covered at this stage of project. Based on its functionalities, accuracy and performance, this system is able to bring more benefit and convenience for its users. © Springer Science+Business Media Singapore 2014. Springer Verlag 2014 Article NonPeerReviewed https://www.scopus.com/inward/record.uri?eid=2-s2.0-84958550996&doi=10.1007%2f978-981-4585-18-7_3&partnerID=40&md5=e7307132c998e1dd9f2cdc65a33c5883 Ahmad, R. and Saknakosnak, P. and Hooi, Y.K. (2014) Excel-database converting system using data normalization technique. Lecture Notes in Electrical Engineering, 285 LN . pp. 23-30. http://eprints.utp.edu.my/31715/
institution Universiti Teknologi Petronas
collection UTP Institutional Repository
description This paper is intended to present an application system which can facilitate users in converting from Excel spreadsheet to database structure by using data normalization technique. It provides users with an automated system that can develop a database in its third normal form (3NF) from an Excel spreadsheet. There are two major problems of Excel spreadsheet that are emphasized in this project which are data redundancy and update anomaly. Prototyping-based methodology is used in order to develop this system. The system just creates the SQL codes for creating the database structure and populating the database; however, how the users make use of it such as interface for database interaction is not covered at this stage of project. Based on its functionalities, accuracy and performance, this system is able to bring more benefit and convenience for its users. © Springer Science+Business Media Singapore 2014.
format Article
author Ahmad, R.
Saknakosnak, P.
Hooi, Y.K.
spellingShingle Ahmad, R.
Saknakosnak, P.
Hooi, Y.K.
Excel-database converting system using data normalization technique
author_sort Ahmad, R.
title Excel-database converting system using data normalization technique
title_short Excel-database converting system using data normalization technique
title_full Excel-database converting system using data normalization technique
title_fullStr Excel-database converting system using data normalization technique
title_full_unstemmed Excel-database converting system using data normalization technique
title_sort excel-database converting system using data normalization technique
publisher Springer Verlag
publishDate 2014
url https://www.scopus.com/inward/record.uri?eid=2-s2.0-84958550996&doi=10.1007%2f978-981-4585-18-7_3&partnerID=40&md5=e7307132c998e1dd9f2cdc65a33c5883
http://eprints.utp.edu.my/31715/
_version_ 1741197623736401920
score 11.62408

Similar Items