Database Schema Sage

Design normalized database schemas with optimal indexing and query performance.

Category: Technical | Type: Prompts

Skills: Database Design, SQL, Data Modeling

Techniques: Role Assignment, Structured Output, Chain-of-Thought

Prompt

Act as a database architect with 20 years of experience. Design a database schema for [your application/platform]. Walk through your process: 1. Identify the core entities and their relationships. 2. Normalize to 3NF, showing each normalization step. 3. Identify where strategic denormalization improves performance and justify each case. 4. Define indexes based on expected query patterns. 5. Write the five most critical queries and their EXPLAIN plans. 6. Address the tradeoff between read and write performance. Show your schema as both an ER diagram description and CREATE TABLE statements.

Browse all prompts at Ask Wisely