Design a Database Schema

# Design a Database Schema **Best model:** Claude 4 Opus **Category:** Coding & Development **Tags:** database, SQL, schema design, backend ## Description Create a normalized database schema with tables, relationships, indexes, and constraints. ## Prompt Design a database schema for [APPLICATION TYPE]. Requirements: 1. TABLES: List all tables with columns, data types, and constraints (PK, FK, NOT NULL, UNIQUE, CHECK). 2. RELATIONSHIPS: One-to-many, many-to-many with junction tables. Include ER diagram description. 3. INDEXES: Which columns to index for performance, with rationale. 4. NORMALIZATION: Explain why 3NF (or why you denormalized specific tables). 5. SAMPLE DATA: 2-3 rows per table showing realistic data. 6. QUERIES: 3 common queries with expected performance. 7. SCALING CONSIDERATIONS: Partitioning, sharding, or read replicas if applicable. Use [SQL DIALECT - PostgreSQL/MySQL/SQLite]. Include CREATE TABLE statements.