Question

6. What is the composite key, candidate key, primary key and foreign key?

Answer 1

$\huge{\underline{\underline{\bf{\color{blue}{Answer ｡.ﾟ+ ⟵}}}}}$

───────────────────────

$\sf{\underline{\pink{Composite \: Key ↴}}}$

Composite Key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row).

───────────────────────

$\sf\underline\pink{Candidate \: Key ↴}$

Candidate Key is also a unique key, which identifies record uniquely, but, a table can have multiple candidate keys.

───────────────────────

$\sf\underline\pink{Primary \: Key↴}$

Primary Key is a field in a table which uniquely identifies each row/record in a database table.

A table can have only one primary key.

───────────────────────

$\sf\underline\pink{Foreign \: Key ↴}$

Foreign Key is a column (or columns) in a table which references with a column (most often primary key) of another table.

━━━━━━━━━━━━━━━━━━━━━━

Mark as brainliest ✔