Coding Prompts

Explain how to normalize a messy table design step by step, from first through third normal form, naming the specific rule violation before each fix.

Explain which Git branching model, GitFlow, GitHub Flow, or trunk-based development, fits a described team size and release cadence, and why the others would not.

Explain a SQL query either clause by clause as written or traced in the actual processing order, from FROM and JOIN through WHERE and SELECT.

Build a full truth table for AND, OR, NOT, or a compound expression, or evaluate an if-statement condition using Python and JavaScript's operator precedence order.

Break down a regular expression token by token, or build one from a plain-English description, with example strings that match and one that fails.

Generate small arithmetic, comparison, or logical operator expressions to predict, then walk through each answer in the real order of operations.

Turn code written in one language into a working translation in another, flagging idioms that don't map directly and explaining the substitute pattern used.

Trace a map, filter, or reduce call element by element, showing the output array or accumulator build up at each step.

Generate a plain-English definition for any programming or computer science term, with a tiny code example if applicable and its most-confused-with word.

Design a full set of REST API endpoints for a given resource, with resource-based URLs, correct HTTP methods, and example JSON request and response bodies.

Recommend localStorage, sessionStorage, or a cookie for a browser storage use case, weighing data lifetime against server visibility, with code to set and read it.

Generate a scoped list of unit tests for a given function, covering happy path, edge cases, and failure cases, without revealing test code until requested.

Map one app feature across unit, integration, and end-to-end testing, showing what each level checks and why the test pyramid favors more of one kind.

Recommend a relational or a specific type of NoSQL database, document, key-value, or column-family, based on the actual shape and structure of a described dataset.

Walk through pasted code in execution order rather than reading order, calibrated to a stated experience level, naming unfamiliar syntax and checking understanding.

Add teaching-style comments into pasted code, explaining the underlying concept behind each line instead of restating what the code says, producing a reusable study aid.

Explain why a slow query scans every row of its table, identify the column an index would target, and show the resulting write-cost tradeoff.

Explain an HTML structure, a block of CSS, or both together, covering the nesting and cascade rules a browser uses to decide what renders.

Explain the difference between a framework and a library through control flow, who calls whose code, using real examples in a chosen programming language.

Generate a scoped mini-project in a stated language, built around a stated interest area, broken into milestones sized to a chosen time commitment.

Explain a classic dynamic programming problem by exposing the naive solution's repeated work, then solving it again with memoization, compared side by side.

Explain a core Node.js concept, such as modules, npm, or the event loop, with a small runnable example showing the concept actually happening.

Build working CSS for a described layout goal, choosing the right method, flexbox, grid, or positioning, and explaining why it fits the goal.

Explain any JavaScript snippet, from plain scripts to React components to Node backend code, either fully or narrowed to its asynchronous and timing behavior.