hrcak mascot   Srce   HID

Pregledni rad

Bernstein Algorithm for Vertical Normalization to 3NF Using Synthesis

Matija Varga ; The Faculty of Teacher Education of the University of Zagreb

Puni tekst: hrvatski, pdf (221 KB) str. 315-322 preuzimanja: 599* citiraj
APA 6th Edition
Varga, M. (2013). Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom. Ekonomski vjesnik, XXVI (1), 315-322. Preuzeto s https://hrcak.srce.hr/108225
MLA 8th Edition
Varga, Matija. "Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom." Ekonomski vjesnik, vol. XXVI, br. 1, 2013, str. 315-322. https://hrcak.srce.hr/108225. Citirano 04.08.2020.
Chicago 17th Edition
Varga, Matija. "Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom." Ekonomski vjesnik XXVI, br. 1 (2013): 315-322. https://hrcak.srce.hr/108225
Harvard
Varga, M. (2013). 'Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom', Ekonomski vjesnik, XXVI(1), str. 315-322. Preuzeto s: https://hrcak.srce.hr/108225 (Datum pristupa: 04.08.2020.)
Vancouver
Varga M. Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom. Ekonomski vjesnik [Internet]. 2013 [pristupljeno 04.08.2020.];XXVI(1):315-322. Dostupno na: https://hrcak.srce.hr/108225
IEEE
M. Varga, "Bernsteinov algoritam za vertikalnu 3NF normalizaciju sintezom", Ekonomski vjesnik, vol.XXVI, br. 1, str. 315-322, 2013. [Online]. Dostupno na: https://hrcak.srce.hr/108225. [Citirano: 04.08.2020.]

Sažetak
This paper demonstrates the use of Bernstein algorithm for vertical normalization to 3NF using synthesis. The aim of the paper is to provide an algorithm for database normalization and present a set of steps which minimize redundancy in order to increase the database management efficiency, and specify tests and algorithms for testing and proving the reversibility (i.e., proving that the normalization did not cause loss of information). Using Bernstein algorithm steps, the paper gives examples of vertical normalization to 3NF through synthesis and proposes a test and an algorithm to demonstrate decomposition reversibility. This paper also sets out to explain that the reasons for generating normal forms are to facilitate data search, eliminate data redundancy as well as delete, insert and update anomalies and explain how anomalies develop using examples-

Ključne riječi
functional dependency; relation schema; normalization; normalization using synthesis; decomposition; Bernstein algorithm; loss of information

Hrčak ID: 108225

URI
https://hrcak.srce.hr/108225

[hrvatski]

Posjeta: 1.463 *