eprintid: 4510
rev_number: 2
eprint_status: archive
userid: 1
dir: disk0/00/00/45/10
datestamp: 2023-11-09 16:16:11
lastmod: 2023-11-09 16:16:11
status_changed: 2023-11-09 15:58:35
type: article
metadata_visibility: show
creators_name: Ahmad, R.
creators_name: Saknakosnak, P.
creators_name: Hooi, Y.K.
title: Excel-database converting system using data normalization technique
ispublished: pub
keywords: Automation; Spreadsheets, Data normalization; Excel spreadsheets; Functional dependency; Normal form; SQL commands, Database systems
note: cited By 2; Conference of 1st International Conference on Advanced Data and Information Engineering, DaEng 2013 ; Conference Date: 16 December 2013 Through 18 December 2013; Conference Code:102583
abstract: 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.
date: 2014
publisher: Springer Verlag
official_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
id_number: 10.1007/978-981-4585-18-7₃
full_text_status: none
publication: Lecture Notes in Electrical Engineering
volume: 285 LN
place_of_pub: Kuala Lumpur
pagerange: 23-30
refereed: TRUE
isbn: 9789814585170
issn: 18761100
citation:   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.  ISSN 18761100