Normalization Shootout: A Competitive Game That Impacts Student Learning

Fanguy, Ronnie; Kleen, Betty A.

doi:10.48009/1_iis_2005_21-27

Cited by 2 publications

(1 citation statement)

References 6 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Mitrovic (2002) developed an online smart education system called NORMIT to teach the concepts of normalization. Similarly, Fanguy et al (2005) used gamification in their teaching methods. Soler et al (2006) developed a normalization problem generator and asked for a design in Boyce-Codd normal form.…”

Section: Literature Review On Automatic Normalizationmentioning

confidence: 99%

A Novel Automatic Relational Database Normalization Method

Akadal¹,

Satman²

2022

AIP

View full text Add to dashboard Cite

The increase in data diversity and the fact that database design is a difficult process make it practically impossible to design a unique database schema for all datasets encountered. In this paper, we introduce a fully automatic genetic algorithm-based relational database normalization method for revealing the right database schema using a raw dataset and without the need for any prior knowledge. For measuring the performance of the algorithm, we perform a simulation study using 250 datasets produced using 50 well-known databases. A total of 2500 simulations are carried out, ten times for each of five denormalized variations of all database designs containing different synthetic contents. The results of the simulation study show that the proposed algorithm discovers exactly 72% of the unknown database schemas. The performance can be improved by fine-tuning the optimization parameters. The results of the simulation study also show that the devised algorithm can be used in many datasets to reveal structs of databases when only a raw dataset is available at hand.

show abstract

Section: Literature Review On Automatic Normalizationmentioning

confidence: 99%