文章基本信息

标题：ALEGEREA CHEILOR PRIMARE ÎNTR-O BAZĂ DE DATE – PROBLEME SPECIFICE ŞI CONSECINŢE
本地全文：下载
作者：Florin MIHAI ; Florin MIHAI ; Ofelia ALECA 等
期刊名称：Contabilitate şi Informatică de Gestiune
印刷版ISSN：1583-4387
出版年度：2009
卷号：8
期号：1
页码：109-119
语种：English
出版社：Bucharest University of Economic Studies
摘要：This article 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 only the consistency and coherence of information, but also 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, we expose the consequences that arise from choosing a primary key as it will be reflected in the future evolution of the database model.
关键词：Databases; primary key; candidate key; surrogate key; foreign key; Normal Forms; Functional Dependency (FD)