Application of Technology Acceptance Model on Database Normalizer

Normalization is one of the most important activities in database designing. The good database design is the database that meets user requirements and designed its structure carefully. Therefore, this study focused on developing a database normalization application that helps database designers to p...

Full description

Saved in:

Bibliographic Details
Main Author:	Al-Absi, Ahmed Abdulhakim Ahmed
Format:	Thesis
Language:	eng eng
Published:	2011
Subjects:	QA76 Computer software
Online Access:	https://etd.uum.edu.my/2816/1/Ahmed_Abdulhakim.pdf https://etd.uum.edu.my/2816/2/1.Ahmed_Abdulhakim.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uum-etd.2816
record_format	uketd_dc
institution	Universiti Utara Malaysia
collection	UUM ETD
language	eng eng
advisor	Gulamdin, Abdul Ghani
topic	QA76 Computer software
spellingShingle	QA76 Computer software Al-Absi, Ahmed Abdulhakim Ahmed Application of Technology Acceptance Model on Database Normalizer
description	Normalization is one of the most important activities in database designing. The good database design is the database that meets user requirements and designed its structure carefully. Therefore, this study focused on developing a database normalization application that helps database designers to perform the normalization process automatically and improves the database designing by avoiding the problems of carrying out normalization manually which has many drawbacks such as time consuming, prone to errors and requires more than one skilled user. The main objective of this study is to develop a database normalizer application to normalize the database tables up to the third normal form (3NF). This study provides a normalization algorithm to perform the 1NF, 2NF, and 3NF automatically based on Microsoft Access and SQL Server databases. Experiment was conducted to check the functionality in performing the normalization process. The experiment result showed that the prototype achieved the result successfully as expected and fulfills the requirements and rules of normalization processes. Moreover, a questionnaire based on the Technology Acceptance Model technique has been adopted to ensure of the prototype level in terms of easiness of use, and satisfaction.
format	Thesis
qualification_name	masters
qualification_level	Master's degree
author	Al-Absi, Ahmed Abdulhakim Ahmed
author_facet	Al-Absi, Ahmed Abdulhakim Ahmed
author_sort	Al-Absi, Ahmed Abdulhakim Ahmed
title	Application of Technology Acceptance Model on Database Normalizer
title_short	Application of Technology Acceptance Model on Database Normalizer
title_full	Application of Technology Acceptance Model on Database Normalizer
title_fullStr	Application of Technology Acceptance Model on Database Normalizer
title_full_unstemmed	Application of Technology Acceptance Model on Database Normalizer
title_sort	application of technology acceptance model on database normalizer
granting_institution	Universiti Utara Malaysia
granting_department	Awang Had Salleh Graduate School of Arts & Sciences
publishDate	2011
url	https://etd.uum.edu.my/2816/1/Ahmed_Abdulhakim.pdf https://etd.uum.edu.my/2816/2/1.Ahmed_Abdulhakim.pdf
_version_	1747827436490326016
spelling	my-uum-etd.28162022-04-12T00:04:53Z Application of Technology Acceptance Model on Database Normalizer 2011 Al-Absi, Ahmed Abdulhakim Ahmed Gulamdin, Abdul Ghani Awang Had Salleh Graduate School of Arts & Sciences Awang Had Salleh Graduate School of Sciences QA76 Computer software Normalization is one of the most important activities in database designing. The good database design is the database that meets user requirements and designed its structure carefully. Therefore, this study focused on developing a database normalization application that helps database designers to perform the normalization process automatically and improves the database designing by avoiding the problems of carrying out normalization manually which has many drawbacks such as time consuming, prone to errors and requires more than one skilled user. The main objective of this study is to develop a database normalizer application to normalize the database tables up to the third normal form (3NF). This study provides a normalization algorithm to perform the 1NF, 2NF, and 3NF automatically based on Microsoft Access and SQL Server databases. Experiment was conducted to check the functionality in performing the normalization process. The experiment result showed that the prototype achieved the result successfully as expected and fulfills the requirements and rules of normalization processes. Moreover, a questionnaire based on the Technology Acceptance Model technique has been adopted to ensure of the prototype level in terms of easiness of use, and satisfaction. 2011 Thesis https://etd.uum.edu.my/2816/ https://etd.uum.edu.my/2816/1/Ahmed_Abdulhakim.pdf text eng public https://etd.uum.edu.my/2816/2/1.Ahmed_Abdulhakim.pdf text eng public masters masters Universiti Utara Malaysia Akehurst, D., Bordbar, B., Rodgers, P., & Dalgliesh, N. (2002). Automatic normalization via Metamodelling, In Proceedings of the ASE Declarative Meta Programming to Support Software Developmen, held on September 23-24, 2002 at Edinburgh, UK (pp. 23-27). Edinburgh: IEEE. Babar, M., Winkler D., & Biffl, S. (2007). Evaluating the usefulness and ease of use of a groupware tool for the software architecture evaluation process. In Proceedings of the first international symposium on empirical software engineering and measurement, ESEM 2007, held on September 20-21, 2007 at Madrid, Spain (pp. 430-439). CA: IEEE Computer Society. Bahmani, A., Naghibzadeh, M., & Bahmani, B. (2008). Automatic database normalization and primary key generation. In proceedings of the 21st Canadian Conference on Electrical and Computer Engineering, held on May 4-7, 2008 at Ontario, Canada (pp. 11-16). CA: IEEE CCECE. Bahmani, A., Shekofteh, S., Naghibzadeh, M., & Deldari, H. (2010). Parallel algorithms for automatic database normalization. Computer and Automation Engineering, 2(1), 157-161 Bahrami, A. (1999). Object-Oriented Systems Development: Using the Unified Modeling Language. New York: McGraw-Hill. Barclay, K., & Savage, J. (2004). Object-Oriented design with UML and Java. Burlington, USA: Elsevier Butterworth-Heinemann. Bennett, S., McRobb, S., & Farmer, R. (2002). Object-oriented system analysis and design (2nd ed.). UK: McGraw Hill. Bhavsar, C. (2008). Comparison between Windows Forms and Web Applications. Retrieved March 30, 2011, from http://www.eggheadcafe.com/community/aspnet/2/10036174/whats the major difference between windows and web applications.aspx Berenbach, B., Paulish, D., Kazmeier, J., & Rudorfer, R. (2009). Software & systems requirements engineering in practice. New York: McGraw-Hill. Best, J., & Kahn, J. (2006). Research in Education (10th ed.). New York: Pearson Education Inc. Chan, H.C., & Teo, H.-H. (2007). Evaluating the boundary conditions of the technology acceptance model: An exploratory investigation. ACM Transactions on Computer-Human Interaction, 14(2), 1-22. Connolly, T., & Begg, C. (2004). Database solutions: A step-by-step approach to building databases (2nd ed.). Boston: Pearson. Connolly, T., & Begg, C. (2010). Database Systems: A practical approach to design, implementation, and management (5th ed.). Boston: Pearson. Daintith, J. (2009). Systems design a dictionary of computing. Retrieved May 15, 2011, from http://www.encyclopedia.com/doc/1O11-systemdesign.html. Davis, F. (1989). Technology Acceptance Model for Empirically Testing New End-User Information Systems: Theory and Results. Boston, MA: Massachussetts Institute of Technology. Dennis, A., Wixom, B., & Tegarden, D. (2005). System analysis and design with UML version 2.0: an object-oriented approach with UML (2nd ed.). Hoboken, NJ: John Wiley and Sons, Inc. Dongare, Y., Dhabe, P., & Deshmukh, S. (2011). RDBNorma: A semi-automated tool for relational database schema normalization. International Journal of Database Management Systems, 3(1), 133-154. Egeberg, M. (2006). The mobile phone as a contactless ticket. Master’s thesis, Norwegian University of Science and Technology, Norway. Erdil, K., Finn, E., Keating, K., Meattle, J., Park, S., & Yoon, D. (2003). Software maintenance as part of the software life cycle (Department of Computer ScienceTufts University Technical Report No. Comp-180). Retrieved March 29, 2011, from http://www.hepguru.com/maintenance/Final_1.pdf Field, A. P. (2006). Discovering statistics using SPSS (2nd ed.). London: Sage. Jivan, E. & Gruner, S. (2009).Tool support for more precise use-case specifications. In Proceedings of Warm-Up Workshop for ACM, WUP/ISS 2009, held on April 1-3, 2009 at Cape Town, South Africa (pp. 29-32). Cape Town: ACM. Johan, K. (2004). Information system analysis and design. Retrieved May 11, 2011, from http://www.cs.toronto.edu/jm/3405/slides2/sequenceD.pdf. Hoffer, J., George, J., &Valacich, J. (2002). Modern Systems Analysis and Design (3rd ed.). Upper Saddle River, New Jersey: Prentice Hall. Hoffer, J., Prescott, M., & McFadden, F. (2007). Modern Database Management (8th ed.). Upper Saddle River, New Jersey: Prentice Hall. Holzinger, A. (2005). Usability Engineering Methods for Software Developers. Communications of the ACM,48(1),71-74. Kern, J., & Garrett, C. (2003). Effective Sequence Diagram Generation: Effective Use of Options with Borland Together Technologies. Retrieved May 27, 2011, from http:www.borland.com/resources/en/pdf/white_papers/20263.pdf Krishnan, H., & Samuel, P. (2010). Relative Extraction Methodology for Class Diagram Generation using Dependency Graph. In Proceedings of the International Conference on Communication, Control and Computing Technologies, ICCCCT 2010, held on October 7-9, 2010 at Kanyakumari, Tamilnadu (pp. 815-820). Tamilnadu: IEEE. Kung, H., & Tung, H. (2006). A web based tool to enhance teaching/Learning database normalization. In Proceedings of international conference of southern association for information system, SAIS 2006.30-38. Martin, F., & Kendall, S. (2000). UML Distilled: Brief guide to the standard object modeling language (2nd ed.). Boston, USA: Addison-Wesley Longman Publishing. McConnell, S. (1999, August). Open-Source Methodology: Ready for Prime Time? [Electronic version]. IEEE Software, 16(4). 6-11. Mitrovic, A. (2002). NORMIT: a web-enabled tutor for database normalization. In Proceedings of the International Conference on Computers in Education ICCE, 2002, held on December 3-6, 2002 at Auckland, New Zealand (pp. 275-80). CA: IEEE Computer Society. Nielsen, J., & Levy, J. (1994). Measuring usability: Preference vs. performance. Communications of the ACM, 37(4), 66-75. Norshuhada, S., & Shahizan, H. (2010). Design research in software development: constructing and linking research questions, objectives, methods and outcomes. Sintok: University Utara Malaysia Press. Patton, M. Q. (2002). Qualitative research and evaluation methods (3rd ed.). Thousand Oaks, CA: Sage. Peters, D. & Parnas, L. (2002). Requirements based monitors for real time systems. IEEE Transactions on software engineering, 28(2), 146-158. Ram, S. (2008). Teaching data normalization: Traditional classroom methods versus online visual methods – a Literature review. In Proceedings of the 21st Annual Conference of the National Advisory Committee on Computing Qualifications (NACCQ 2008), held on July 4-7, 2008 at Auckland, New Zealand (pp. 327-330). Auckland: NACCQ. Rob, P., & Coronel, C. (2009). Database Systems: Design, Implementation, and Management (8th ed.). Boston: Course Technology. Rubin, H. J. & Rubin, I. S. (2005). Qualitative interviewing: The art of hearing data. Thousand Oaks, CA: Sage. Shelly, G. B., Cashman, T. J., & Rosenblatt, H. J. (2009). Systems Analysis and Design (8th ed.). Boston, MA: Course Technology. Srikanth, S., & Sudarshan, D. (2001). Database management Systems. (1st ed.). Bangalore: Subhas. Teorey, T., Lightstone, S., Nadeau, T., & Jagadish, H. (2011). Database Modeling and Design: Logical Design (5th ed.). Morgan Kaufmann: Morgan Kaufmann. Vaishnavi, V. & Kuechler, W. (2008). Design science research methods and patterns innovating information and communication technology research in information systems. New York: Auerbach. Whitten, J., Bentley, L., & Dittman, K. (2001). Systems analysis and design methods (5th ed.). New York: McGraw-Hill. Yazici, A., & Karakaya, Z. (2007). JMathNorm: A database normalization tool using mathematica. In Proceedings of International conference on computational science, 2007, held on May 27-30, 2007 at Beijing, China (pp. 186-193). Beijing: Springer-Verlag Berlin Heidelberg. Yi, T., Wu, F., & Gan, C. (2005). A comparison of metrics for UML class diagrams. ACM SIGSOFT Software Engineering Notes, 29(5). 1–6. Yu, C. H. (2000). An introduction to computing and interpreting Cronbach Coefficient Alpha in SAS (Arizona State University Technical Report No. 246-26). Retrieved May 27, 2011, from http://www2.sas.com/proceedings/sugi26/p246-26.pdf.

Application of Technology Acceptance Model on Database Normalizer

Similar Items