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

Saved in:
Bibliographic Details
Main Authors: Ahmad, R., Saknakosnak, P., Hooi, Y.K.
Format: Article
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!
Institution: Universiti Teknologi Petronas
id my.utp.eprints.31715
record_format eprints
spelling my.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
building UTP Resource Centre
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Petronas
content_source UTP Institutional Repository
url_provider http://eprints.utp.edu.my/
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_facet Ahmad, R.
Saknakosnak, P.
Hooi, Y.K.
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_ 1738657286347292672