1) What is Primary Key?
Ans: - The column or attribute that is uniquely identifying the row of the table is called as Primary Key.
2) What is Foreign Key?
Ans: - A column in one table whose values can be matches to the primary key of another table is called as Foreign Key.
3) What is Candidate Key?
Ans: - Any column or attribute that uniquely identifies a row in a table is a candidate for the primary key such as attribute or column is called as Candidate Key.
4) What is Alternate Key?
Ans: - Any column or attribute that is a candidate for the primary key but not the primary key is called as the Alternate Key.
5) What is Composite Key?
Ans:- When a Key that uniquely identifies the rows of the table is made up of more than one attribute is called as Composite Key.
No comments:
Post a Comment