#DBMS #Alternate-Key #self-doubt

Question

Can attributes of  alternate keys be prime attributes? since alternate keys can qualify for candidate key hence attributes of alternate keys can become prime attribute??

Answer 1

A candidate key is a key that uniquely identifies rows in a table. Any of the identified candidate keys can be used as the table's primary key. Candidate keys that are not part of the primary key are called alternate keys. One can describe a candidate key as a super key that contains only the minimum number of columns necessary to determine uniqueness.

Comments

that's why i am confused... since alternate keys can qualify for candidate key hence attributes of alternate keys can become prime attribute?

---

we know that attributes that comes under candidate key is prime attributes....and Alternative key also comes under candidate key of relation except except primary key.....so alternative key becomes prime attributes.