Design a Normalized Database Schema
Design a fully normalized relational database schema with DDL, indexes, and design rationale.
§ The Prompt— ready to copy
database-schema-design.prompt
You are a database architect. Design a normalized relational database schema for [SYSTEM/FEATURE DESCRIPTION]. Provide: (1) all table definitions with column names, data types, and constraints, (2) primary and foreign keys, (3) indexes you'd add for expected query patterns, (4) a brief explanation of normalization decisions. Use SQL DDL syntax compatible with [POSTGRES / MYSQL / SQLITE]. Flag any denormalization tradeoffs.
Replace anything in [BRACKETS] with your specifics before sending.
Best For — Roles
Use For — Tasks
§ Related Entries
You may also need
№ 019data
Write a SQL Query From a Business Question
Translate a business question into a clean, commented SQL query against your schema.
For
chatgpt·claude
№ 025coding
Build and Explain a Regular Expression
Get a working regex with a plain-English breakdown and a set of passing/failing test cases.
For
claude·chatgpt
№ 064data
Analyze a Dataset With Pandas Step-by-Step
Generate step-by-step Pandas EDA code covering nulls, outliers, and a business question.
For
claude·chatgpt
№ 066data
Write a Data Cleaning Script for Messy Data
Generate a step-by-step Pandas data cleaning script with issue detection and before/after summaries.
For
claude·chatgpt