Primary Key vs Foreign Key | Dataford Interview Questions

What is the difference between a primary key and a foreign key?

Using the provided order table, identify the column serving as the primary key and the column serving as the foreign key. Explain how each key supports data integrity and relationships between tables.

Output

One row per order, with columns order_id and customer_id
Sort by order_id in ascending order

Schema

orders

Column	Type	Description
order_idPK	INT	Unique identifier for each order
customer_id	INT	Identifier of the customer associated with the order, referencing customers.customer_id

Your question is Primary Key vs Foreign Key. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

What is the difference between a primary key and a foreign key?

Output

One row per order, with columns order_id and customer_id
Sort by order_id in ascending order

Schema

orders

Column	Type	Description
order_idPK	INT	Unique identifier for each order
customer_id	INT	Identifier of the customer associated with the order, referencing customers.customer_id

Your question is Primary Key vs Foreign Key. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.