Database - The Relational Model and Normalization - Discussion

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

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

Siddhu said:   8 years 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.

Karthik said:   8 years 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.

Lovepreet said:   8 years ago
One table contain multiple candidate key by single primary key.

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

SuchismitaM said:   9 years ago
Candidate key contains no.of attributes which are the candidate to be the primary key (must contain unique value, must not be null). The keys other than primary key is known as non-prime key.

Sathi said:   9 years ago
One of the minimal candidate key that derives all attributes of a relation.

Sathish said:   9 years ago
Only one key existence for a relation called candidate key that will become the primary key that will never reducible.

Madhur said:   9 years ago
One of the candidate key is called primary key.

Pooja manoja said:   1 decade ago
There may be more than one attributes in a relation, which recognizes a tuple uniquely. (each of attributes have a property of primary key) these attributes are called candidate day.

For example :in a student relation sid and regd are primary key.

Post your comments here:

Your comments will be displayed after verification.