</>SkillRecallRECALL WHAT YOU KNOW
Prepare for an interviewExplore Library
Databases & SQLData Modeling & Normalization

6 items

1

Two Primary Keys in One Table

Code Quiz
2

Foreign Keys and Indexing Basics

Quiz
3

Foreign Key Referencing Wrong Column

Code Quiz
4

Primary Keys vs Unique Constraints

Quiz
5

Denormalized Updates in NoSQL

Code Quiz
6

SQL vs NoSQL Modeling Tradeoffs

Quiz
QuizAdvanced

Foreign Keys and Indexing Basics

Understanding the role of a foreign key when designing related database tables.

In a relational schema, an Orders table has a customer_id column referencing the Customers table's primary key. What is the primary purpose of defining customer_id as a foreign key?