Abstract
The task of designing relational databases has always been the subject of scientific research, as it is associated with a number of interrelated steps. The result of each step is the development of models for presenting the future database with further refinement and, finally, the creation of an adequate relational database as a set of relations with the corresponding links between them. The article focuses on the normalization of databases, as one of the steps to create a datalogical model, namely, the use of the first three Normal Forms. As a result of the analysis carried out in the article, it was concluded that the definition of the Second Normal Form can be modernized and thus achieve two goals: to ensure the correct creation of potential primary keys and, thereafter, the correct external connections between relations, even before creating the data schema in a specific relational database. Moreover, to reconsider the necessity of applying the so-called “strengthened” or a higher version of the Third Normal Form, which speaks of mutual dependencies between key and non-key attributes.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Codd, E.F.: Normalized data base structure: a brief tutorial. In: Proceedings of 1971 ACM-SIGFIDET Workshop on Data Description, Access and Control, pp. 1–17. ACM, New York (1971)
The basics of relational databases. Transl. from eng: Publishing and trading house, Russian Edition (2001). 384 p.
Guschin, A.: Data bases, 2nd edn. corrected and add: teaching aid. Direct-Media, Moscow (2015), 311 p.
Date, C.J.: An Introduction to Database Systems, 6th edn. Addison-Wesley, Reading (1995)
Codd, E.F.: Further Normalization of the Data base Relational Model. In: Data Base Systems, pp. 33–64. Prentice-Hall, New Jersey (1972)
Fagin, R.A.: Normal form for relational databases that is based on domains and keys. ACM Trans. Database Syst. 6(3), 387–415 (1981)
Calenko, M.: Modeling Semantics in Databases. Science, Moscow (1988)
Codd, E.F.: Relational completeness of data base sublanguages. In: Rustin, R.J. (ed.) Data Base Systems, Courant Computer Science Symposia Series 6. Prentice Hall, Englewood Cliffs (1972)
Codd, E.F.: Derivability, redundancy, and consistency of relations stored in large data banks. IBM Research Report RJ599, 19 August 1969
Codd, E.F., Date, C.J.: Much ado about nothing. In: Date, C.J. (ed.) Relational Database Writings 1991–1994. Addison-Wesley, Reading (1995)
Date, C.J.: SQL and Relational Theory: How to Write Accurate SQL Code, 2nd edn., p. 446. O’Reilly Media, Inc., Sebastopol (2012)
Date, C.J.: Database Design and Relational Theory, p. 449. O’Reilly Media, Inc., Sebastapol (2012)
Harrington, J.L.: Relational Database Design and Implementation: Clearly Explained, 3rd edn., p. 418. Morgan Kaufmann, San Francisco (2009)
Date, C.J.: Date on Database: Writings 2000–2006. Apress, Berkeley (2006)
Darwen, H.: The role of functional dependence in query decomposition. In: Date, C.J., Darwen, H. (eds.) Relational Database Writings 1989–1991. Addison-Wesley, Reading (1992)
Date, C.J.: Composite keys. In: Date, C.J., Darwen, H. (eds.) Relational Database Writings 1989–1991. Addison-Wesley, Reading (1992)
Date, C.J.: Database Design and Relational Theory: Normal Forms and All That Jazz, p. 450. APRESS, Healsburg (2019)
Zdanowski, K.: A Unified View on Database Normal Forms: From the Boyce-Codd Normal Form to the Second Normal Form (2NF, 3NF, BCNF), Vertabelo (2015)
Alotaibia, Y., Ramadan, B.: A novel normalization forms for relational database design throughout matching related data attribute. Int. J. Eng. Manuf. (IJEM), 65–72. Published Online September 2017 in MECS
Zhuchenkoa, A.I., Osipab, L.V., Cheropkin, E.S.: Design database for an automated control system of typical wastewater treatment processes. Int. J. Eng. Manuf. (IJEM), pp. 36–50. Published Online July 2017 in MECS
Rizwan Jameel Qureshi, M., Shaik, M.S., Iqbal, N.: Using fuzzy logic to evaluate normalization completeness for an improved database design. Int. J. Inf. Technol. Comput. Sci. (IJITCS), pp. 48–55. Published Online March 2012 in MECS
Dewson, R.: SQL Server 2008 Express for Developers: From Novice to Professional, p. 508. APRESS (2009)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Rolik, O., Amons, O., Ulianytska, K., Kolesnik, V. (2021). Modernization of the Second Normal Form and Boyce-Codd Normal Form for Relational Theory. In: Hu, Z., Petoukhov, S., Dychka, I., He, M. (eds) Advances in Computer Science for Engineering and Education III. ICCSEEA 2020. Advances in Intelligent Systems and Computing, vol 1247. Springer, Cham. https://doi.org/10.1007/978-3-030-55506-1_27
Download citation
DOI: https://doi.org/10.1007/978-3-030-55506-1_27
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-55505-4
Online ISBN: 978-3-030-55506-1
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)