DBMS Joins Advantage | Dataford Interview Questions

What are the advantages of DBMS joins?

Asked in the Interview Round 2 stage. Using the provided tables, demonstrate a join that combines related records while retaining every row from the primary table, including rows without a match.

Output

One row per employee or matching assignment
Columns: employee_id, employee_name, assignment_id, module_name, assignment_status
Include employees without assignments, showing NULL assignment fields
Order by employee_id, then assignment_id, with unmatched rows last

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee display name
department	VARCHAR(80)	Employee department

assignments

Column	Type	Description
assignment_idPK	INT	Unique assignment identifier
employee_id	INT	Employee assigned to the module
module_name	VARCHAR(120)	Assigned software module
assignment_status	VARCHAR(30)	Current assignment status

Your question is DBMS Joins Advantage. Start with the requirements and the two 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.

Problem