Design a normalized database schema for [APPLICATION TYPE].
Requirements: [LIST KEY FEATURES]
Provide:
1. Entity-relationship diagram (describe in text format)
2. Complete SQL CREATE TABLE statements with appropriate data types, constraints, primary/foreign keys, indexes
3. Sample queries for the 5 most common operations
4. Migration strategy from [CURRENT STATE] if applicable
5. Scaling considerations (partitioning, read replicas, caching layer)
Use PostgreSQL syntax. Optimize for read-heavy workloads unless specified otherwise.
Design a normalized database schema for [APPLICATION TYPE].
Requirements: [LIST KEY FEATURES]
Provide:
1. Entity-relationship diagram (describe in text format)
2. Complete SQL CREATE TABLE statements with appropriate data types, constraints, primary/foreign keys, indexes
3. Sample queries for the 5 most common operations
4. Migration strategy from [CURRENT STATE] if applicable
5. Scaling considerations (partitioning, read replicas, caching layer)
Use PostgreSQL syntax. Optimize for read-heavy workloads unless specified otherwise.
How to use this prompt
Copy the prompt above and paste it into ChatGPT, Claude, Gemini, or any AI assistant. Replace the bracketed placeholders with your specific details.
Leave a Review
Tried this prompt? Let us know how it worked — your reviews help other users find the best prompts.