Data Structure for Departmented People Table | Dataford Interview Questions

Suggest a data structure to store a table of people (name, department number, ID, DOB, salary) so that given a department number you output all people in it

Asked in the Technical 1 stage.

Output

Return one row per person in the matching department.
Output the columns name, department_number, id, dob, and salary.
Include only rows where department_number equals the requested value.
Sort by id ascending.

Schema

people

Column	Type	Description
idPK	INT	Unique person identifier
name	VARCHAR(100)	Person name
department_number	INT	Department identifier
dob	DATE	Date of birth
salary	NUMERIC(12,2)	Annual salary

Your question is Data Structure for Departmented People Table. 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