0 votes 0 votes 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?? debasree88 asked Apr 23, 2019 • edited Apr 23, 2019 by debasree88 debasree88 274 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 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. Gateasp2020 answered Apr 23, 2019 Gateasp2020 comment Share Follow See all 2 Comments See all 2 2 Comments reply debasree88 commented Apr 23, 2019 reply Follow Share that's why i am confused... since alternate keys can qualify for candidate key hence attributes of alternate keys can become prime attribute? 0 votes 0 votes Gateasp2020 commented Apr 23, 2019 reply Follow Share 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. 0 votes 0 votes Please log in or register to add a comment.