Database Architecture and End-to-End Design | Dataford Interview Questions

Tell me about a project where you owned end-to-end architecture, including database architecture and related database decisions.

For the SQL exercise, write a query that summarizes architecture decisions and their review outcomes by project. Include only projects with at least two decisions. Reviews with a NULL status count as not approved.

Output

One row per qualifying project with project_name, decision_count, approved_decisions, and latest_decision_date.
Order by approved decisions descending, decision count descending, and project name ascending.

Schema

projects

Column	Type	Description
project_idPK	INT	Unique project identifier
project_name	VARCHAR(100)	Project name
owner_team	VARCHAR(80)	Team responsible for the project

architecture_decisions

Column	Type	Description
decision_idPK	INT	Unique architecture decision identifier
project_id	INT	Referenced project
decision_title	VARCHAR(150)	Short description of the decision
decision_date	DATE	Date the decision was recorded
decision_type	VARCHAR(60)	Architecture decision category

decision_reviews

Column	Type	Description
review_idPK	INT	Unique review identifier
decision_id	INT	Referenced architecture decision
review_status	VARCHAR(30)	Review outcome
reviewed_at	DATE	Date of review

Your question is Database Architecture and End-to-End Design. 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