Define the term candidate key and foreign key with respect to database.
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Welcome to the ever growing Protoedu family of knowledge seekers and torch bearers. The Protoedu family surpasses the mundane boundaries set by political interests because the Protoeduers (Protoedu family members are fondly known as ) only believe in one concept - Sharing is Growing Asking is Glowing Hearty Welcome once again !!
Answer ( 1 )
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.