Detailed explanation and options for the selected question.
The FOREIGN KEY constraint defines relationships between tables. PRIMARY KEY ensures uniqueness, UNIQUE ensures distinct values, and NOT NULL prevents NULL values.