What is primary key foreign key alternate key composite key and candidate key?
Answers
Answered by
13
primary key- If you apply it then it does not allow null or same value
Foreign key- a foreign key is a field in one table that uniquely identifies a row of another table or the same table
Alternate key-An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primarykey.
Composite key-In database design, a composite key is a candidate key that consists of two or more attributes that uniquely identify an entity occurrence.
candidate key-a candidate key of a relation is a minimal superkey for that relation; that is, a set of attributes such that: the relation does not have two distinct tuples with the same values
hope it help you
mark as brainliest
happy to help you
my self aditya class 8th
Foreign key- a foreign key is a field in one table that uniquely identifies a row of another table or the same table
Alternate key-An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primarykey.
Composite key-In database design, a composite key is a candidate key that consists of two or more attributes that uniquely identify an entity occurrence.
candidate key-a candidate key of a relation is a minimal superkey for that relation; that is, a set of attributes such that: the relation does not have two distinct tuples with the same values
hope it help you
mark as brainliest
happy to help you
my self aditya class 8th
Similar questions