SQLBeginner#keys

What is a composite key?

A primary key built from two or more columns, used when no single column is unique on its own.

Example
CREATE TABLE enrollment (
  student_id INT,
  course_id INT,
  PRIMARY KEY (student_id, course_id)
);

Related Questions

1
SQLIntermediate#keys

What is a candidate key and a super key?

Open
2
SQLIntermediate#normalization

What is normalization? Explain 1NF, 2NF and 3NF.

Open
3
SQLAdvanced#normalization

What is BCNF?

Open