short-paper

Facilitating Learning by Practice and Examples: a Tool for Learning Table Normalization

Authors:

Junhu Wang,

Bela StanticAuthors Info & Claims

BCI'19: Proceedings of the 9th Balkan Conference on Informatics

Article No.: 35, Pages 1 - 4

https://doi.org/10.1145/3351556.3351589

Published: 26 September 2019 Publication History

Get Access

Abstract

We describe the design and evaluation of a web-based tool to help students learn database normalization, which is an important topic in relational database design. Compared with existing systems, our tool has the advantage of allowing a user to practice with as many examples as he/she likes, at all possible levels of difficulty, showing the detailed steps for each solution, and allowing users to upload existing examples and saving their own examples for later reference. Our user survey and observation indicate that the tool is well liked by those who used it, and the tool has impacted them positively in their learning.

References

[1]

C. Begg and T. Connolly. 2014. Database Systems: A Practical Approach to Design, Implementation, and Management (6e). PEARSON.

Google Scholar

[2]

Hongbo Du and Laurent Wery. 1999. Micro: A normalization tool for relational database designers. Journal of Network and Computer Applications 22, 4 (1999), 215--232.

Digital Library

Google Scholar

[3]

R. Elmasri and S. B. Navathe. 2010. Fundamentals of Database Systems (6e). Addison-Wesley.

Digital Library

Google Scholar

[4]

O. Folorunso and A. Akinwale. 2010. Developing visualization support system for teaching/learning database normalization. Campus-Wide Information Systems 27, 1 (2010), 25--39.

Crossref

Google Scholar

[5]

H. Fry, S. Ketteridge, and S. Marshall. 2009. A Handbook for Teaching and Learning in Higher Education. Routledge.

Google Scholar

[6]

Nikolay Georgiev. 2008. A Web-Based Environment for Learning Normalization of Relational Database Schemata. Master's thesis. Umea University.

Google Scholar

[7]

N. Hativa. 2001. Teaching for Effective Learning in Higher Education. Kluwer Academic Publishers.

Google Scholar

[8]

H. Kung and H. Tung. 2006. A web-based tool to enhance teaching/learning database normalization. In SAIS 2006 Proceedings. http://www.visible.com/Products/Analyst/vadbengineer.htm

Google Scholar

[9]

A. Mitrovic. 2001. NORMIT: a Web-Enabled Tutor for Database Normalization. Retrieved September 15, 2017 from http://ir.canterbury.ac.nz/bitstream/10092/335/1/12584595_normit.pdf

Google Scholar

[10]

G. C. Philip. 2007. Teaching Database Modeling and Design: Areas of Confusion and Helpful Hints. Journal of Information Technology Education 6 (2007), 481--497.

Crossref

Google Scholar

[11]

A. Ramakrisnan. 2005. Database Management Systems. McGraw-Hill.

Digital Library

Google Scholar

[12]

A. Silberschatz, H. F. Korth, and S. Sudarshan. 2010. Database Systems Concepts (6e). McGraw-Hill.

Google Scholar

[13]

P. Tan, M. Steinbach, and V. Kumar. 2006. Introduction to Data Minging. Addison-Wesley.

Digital Library

Google Scholar

Cited By

View all

Jamil H(2023)Online Tutoring and Plagiarism-Aware Authentic Assessment of Database Design Assignments2023 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE)10.1109/TALE56641.2023.10398350(1-5)Online publication date: 28-Nov-2023
https://doi.org/10.1109/TALE56641.2023.10398350
Jamil HShawon F(2023)Automatic and Authentic eAssessment of Online Database Design Theory AssignmentsAdvances in Web-Based Learning – ICWL 202310.1007/978-981-99-8385-8_7(77-91)Online publication date: 24-Nov-2023
https://doi.org/10.1007/978-981-99-8385-8_7

Index Terms

Facilitating Learning by Practice and Examples: a Tool for Learning Table Normalization
1. Social and professional topics
  1. Professional topics
    1. Management of computing and information systems
      1. Information system economics

Recommendations

An interactive tool for teaching and learning database normalization
PCI '16: Proceedings of the 20th Pan-Hellenic Conference on Informatics

This paper presents a software tool that automates the process of relational database normalization. In particular, based on a user-given table and a set of functional dependencies, it outputs a set of BCNF normalized tables. The design goal of our ...
Normalization in a rough relational database
RSFDGrC'05: Proceedings of the 10th international conference on Rough Sets, Fuzzy Sets, Data Mining, and Granular Computing - Volume Part I

The rough relational database model was developed for the management of uncertainty in relational databases. In this paper we discuss rough functional dependencies and the normalization process used with them. Normalization is an important part of the ...
Applying Learning Analytics to Predict the Student's Learning Outcome Based on Online Learning Activities
ICFET '24: Proceedings of the 2024 10th International Conference on Frontiers of Educational Technologies

Applying machine learning techniques to predict learning outcomes through learning analytics is a research direction of current interest, especially in online courses. In this paper, we present the results from experimenting with machine learning ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

BCI'19: Proceedings of the 9th Balkan Conference on Informatics

September 2019

225 pages

ISBN:9781450371933

DOI:10.1145/3351556

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

In-Cooperation

Technical University of Sofia

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 26 September 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Short-paper
Research
Refereed limited

Conference

BCI'19

BCI'19: 9th Balkan Conference in Informatics

September 26 - 28, 2019

Sofia, Bulgaria

Acceptance Rates

BCI'19 Paper Acceptance Rate 24 of 73 submissions, 33%;

Overall Acceptance Rate 97 of 250 submissions, 39%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
121
Total Downloads

Downloads (Last 12 months)26
Downloads (Last 6 weeks)1

Reflects downloads up to 22 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Jamil H(2023)Online Tutoring and Plagiarism-Aware Authentic Assessment of Database Design Assignments2023 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE)10.1109/TALE56641.2023.10398350(1-5)Online publication date: 28-Nov-2023
https://doi.org/10.1109/TALE56641.2023.10398350
Jamil HShawon F(2023)Automatic and Authentic eAssessment of Online Database Design Theory AssignmentsAdvances in Web-Based Learning – ICWL 202310.1007/978-981-99-8385-8_7(77-91)Online publication date: 24-Nov-2023
https://doi.org/10.1007/978-981-99-8385-8_7

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

An interactive tool for teaching and learning database normalization

Normalization in a rough relational database

Applying Learning Analytics to Predict the Student's Learning Outcome Based on Online Learning Activities