it is a set one or more attribute,that taken collectively allow as to idendify uniquly and entity in entity set.
ex-customer-id,
Chat with our AI personalities
In database a key is a field that we use to sort a data.whereas superkey is a subset of attribute so that no tuple have the same combination of values.
prime attributes are the attributes of a candidate key which will give uniqueness. a candidate key is (the subset of superkey) which gives uniqueness. Super key is the maximum set of attributes that can provide uniqueness example ABCDE is a super key AB CD DE are the candidate keys s.t. AB is the primary key. CD and DE are the secondary/alternate keys.