Primary Key and Foreign Key | Dataford Interview Questions

What is a Primary Key and what is a Foreign Key?

Asked in the Skill interview stage. Use the provided schema to identify the column serving as the primary key and the column serving as a foreign key.

Output

Return one row per employee.
Include employee_id as primary_key_value, manager_id as foreign_key_value, and employee_name.
Order by employee_id ascending.

Schema

antra_employees

Column	Type	Description
employee_idPK	INT	Unique identifier for an employee
employee_name	VARCHAR(100)	Employee's name
manager_id	INT	Optional employee_id of the employee's manager

Your question is Primary Key and 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