Questions

Candidate Key – 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. Only one Candidate Key can be Primary Key.

• One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization. For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain.

Ragini

The Chemical name of Gold is Aurum with symbol Au with atomic number 79 and a group 11 element. In its purest form, it is a bright, slightly reddish yellow, dense, soft, malleable, and ductile metal.

Chemically, gold is a transition metal.

4  4  2

Goa