Database - The Relational Model and Normalization - Discussion

Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 5)
5.
The primary key is selected from the:
composite keys.
determinants.
candidate keys.
foreign keys.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
15 comments Page 2 of 2.

Rahul said:   1 decade ago
Guys. Does candidate or unique key has got the same property or features of Primary key?

Lovepreet said:   1 decade ago
One table contain multiple candidate key by single primary key.

Karthik said:   1 decade ago
Candidate key is a combination of two or more attributes (emp name, emp street), from which primary key will be derived, primary key derived from set of candidate keys.

Siddhu said:   1 decade ago
A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table.

Each Candidate Key can qualify as Primary Key. Primary Key " A Primary Key is a column or a combination of columns that uniquely identify a record.

Elias joseph said:   8 years ago
Minimum super key is called candidate key so primary key is the part of the candidate key.


Post your comments here:

Your comments will be displayed after verification.