Deadlock and 3NF Basics | Dataford Interview Questions

They asked basic questions like what is deadlock, 3NF and how deadlock occurs and Projects

For the project portion, write a PostgreSQL query that summarizes currently active project assignments while excluding cancelled projects. Include projects with no matching active employees.

Output

One row per non-cancelled project with project_name, status, active_member_count, allocated_hours, and budget_band.
Treat missing assignment totals as zero and classify budgets as High, Medium, or Low.
Order by budget descending, then project name ascending.

Schema

projects

Column	Type	Description
project_idPK	INT	Unique project identifier
project_name	VARCHAR(150)	Project name
status	VARCHAR(30)	Current project status
budget	DECIMAL(12,2)	Approved project budget

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(120)	Employee full name
role	VARCHAR(80)	Employee project role
email	VARCHAR(160)	Employee work email

project_assignments

Column	Type	Description
assignment_idPK	INT	Unique assignment identifier
project_id	INT	Referenced project
employee_id	INT	Referenced employee
hours_allocated	DECIMAL(8,2)	Hours allocated to the assignment
ended_at	DATE	Assignment end date, NULL when active

Your question is Deadlock and 3NF Basics. 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.

Problem