197k views
1 vote
14. The term used to describe an attribute that can function like a primary key is a?​

User Deltics
by
8.6k points

1 Answer

8 votes

Answer:

The answer to this question is given below in this explanation section.

Step-by-step explanation:

In the relationship model of database a primary key is a specific choice of a minimal set of attributes that uniquely specific a tuple in a relation.Informally a primary key is which attribute and in simple cases are simple a single attribute.More formally a primary key is a choice of candidate key any other candidate key is an alternate key.

A primary key may consists of real word observable in which way it is called natural key,while an attribute created to function as a key and not use for identification outside the database is called a surrogate key.For example for a database of people time and location of birth could be a natural key.National identification number is another example of an attribute that may be used as an natural key.

User Joseph Charles
by
8.1k points

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.