Q.34
Consider the alternate, artificial, compound and natural key, and explain what are they?
Alternate Key: All the candidate keys are known as Alternate Keys, excluding primary keys.
Artificial Key: If no obvious key either stands alone or compound is available, then the last resort is to, simply create a key, by assigning a number to each record or occurrence. This is known as artificial key.
Compound Key: When no single data element that uniquely defines the occurrence within a construct is there, then integrating multiple elements to create a unique identifier for the construct is known as Compound Key.
Natural Key: Natural key is one of the data element that is stored within a construct, which is utilized as the primary key.