Alegerea unei chei primare – probleme specifice si consecinte (Selection of primary key – specific issues and consequences)

Citation

Mihai, F., Aleca, O., Stanciu, A. and Ionescu, I. (2009), "Alegerea unei chei primare – probleme specifice si consecinte (Selection of primary key – specific issues and consequences)", International Journal of Accounting & Information Management, Vol. 17 No. 1. https://doi.org/10.1108/ijaim.2009.36617aad.008

Alegerea unei chei primare – probleme specifice si consecinte (Selection of primary key – specific issues and consequences)

Article Type: AMIS statement and abstracts From: International Journal of Accounting and Information Management, Volume 17, Issue 1

This paper discusses many general and particular aspects concerning the primary key selection in relational databases. Considering the essential role of the primary key in designing relational models, the article sustain that making the correct selection will influence not onlyalso all other related concepts: foreign keys, normal forms and referential integrity. Therefore, choosing the best solution for primary keys will affect on long term the entire database model. The paper identifies specific issues and makes comparative analysis for the main practices in primary key selection. Also, the paper exposes the consequences that arise from choosing a primary key as it will be reflected in the future evolution of the database model.

Keywords: Databases, Primary key, Candidate key, Surrogate key

Florin Mihai, Ofelia Aleca, Andrei Stanciu and Iuliana IonescuAcademia de Studii Economice din Bucuresti, Bucuresti, Romania