Question

define primary key candidate key, foreign key​

Answer 1

Answer:

Primary Key - is a column or group of columns in a table that uniquely identify every row in that table.

Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes.

Answer 2

$\huge{\mathcal{\purple{A}\green{N}\pink{S}\blue{W}\purple{E}\green{R}\pink{!!}}}$

$\huge\star{\green{\underline{\mathfrak{Primary\:key}}}}$

A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.

$\huge\star{\green{\underline{\mathfrak{Candidate\:key}}}}$

CANDIDATE KEY is a set of attributes that uniquely identify tuples in a table.

$\huge\star{\green{\underline{\mathfrak{Foreign\:key}}}}$

A foreign key is a key used to link two tables together.

$\huge{\underline{\underline{\tt{\orange{Fol.Low\:\:me}}}}}$

$\huge{\boxed{\boxed{\underline{\rm{\red{Sk\:\:Here}}}}}}$