Query Employees in Department | Dataford Interview Questions

Design employee and department tables (one-to-many, then many-to-many) and write a query listing all employees in a specific department.

Asked in the Round 2 stage.

Output

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name
department_description	VARCHAR(255)	Optional department description

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(150)	Employee full name
employee_email	VARCHAR(255)	Employee email address
primary_department_id	INT	Optional primary department for the one-to-many design

employee_departments

Column	Type	Description
employee_idPK	INT	Employee participating in the department assignment
department_idPK	INT	Department participating in the employee assignment
assignment_type	VARCHAR(30)	Type of department assignment

Your question is Query Employees in Department. Start with the requirements and the three tables 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.