DBMS Functional Dependencies

Question

Will a single attribute key considered as a prime attribute as well?

I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC}

But if I have only 1 Candidate key in my relation (A) then will A also be a prime attribute or not?

Also if multiple single attribute keys are there then what happens (Say {A}, {B} are both candidates) with the prime attributes?

Answer 1

If A is only one candidate key then A, AB,AC will be prime attributes

Comments

Part of the candidate key is a prime attribute, so I dont think AB and AC are going to be prime attributes.

---

Exactly