COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Foreign key
|
|
|
Primary key
|
|
|
Alternate key
|
|
|
Candidate key.
|
Detailed explanation-1: -A candidate key not selected as a primary key is called alternate or secondary key. Candidate key is an attribute or set of attributes that you can consider as a Primary key.
Detailed explanation-2: -An alternate key (Alt key) is a key that is present on most computer keyboards and is considered a modifier key that can used similarly to the shift or control keys. In other words, the alternate key provides alternate input and operations when pressed in combination with other keys.
Detailed explanation-3: -A super key is a group of single or multiple keys which identifies rows in a table. A column or group of columns in a table which helps us to uniquely identifies every row in that table is called a primary key. All the different keys in DBMS which are not primary key are called an alternate key.