Prompt lesson · 15 prompts
Database Design Fundamentals prompts for Database Administrators
15 ready-to-use prompts from our AI for Database Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Compare Data Modeling Tools
Use this when you're choosing a data modeling tool or need step-by-step help building a model in one.
Open this prompt Research · Intermediate
Database Design Documentation Guidelines
Use this when you need best practices for documenting database designs, including ERDs, data dictionaries, and schema diagrams.
Open this prompt Creating · Intermediate
Database Design Patterns
Use this when you need to understand a specific database design pattern, its benefits, and how to apply it to a concrete use case.
Open this prompt Writing · Beginner
Database Design Review and Optimization
Use this when you need a systematic evaluation of an existing database schema to improve performance, scalability, security, or reporting.
Open this prompt Analysis · Advanced
Database Schema Design
Use this when you need to design a relational database schema for a new application, including tables, relationships, and referential integrity.
Open this prompt Creating · Intermediate
Database Schema Design for Applications
Use this when you need to design a normalized database schema for a new application or system.
Open this prompt Creating · Intermediate
Design An Entity-Relationship Model
Use this when you need to map out entities and relationships before building a database schema.
Open this prompt Planning · Intermediate
Draft Database Integrity Constraints
Use this when you need to design referential integrity, default value, or null-handling rules for a database schema.
Open this prompt Coding · Intermediate
Entity-Relationship Diagram Generator
Use this when you need to design an ER diagram for a database, specifying entities, attributes, and relationships for a given domain.
Open this prompt Creating · Intermediate
Explain And Apply Database Normalization
Use this when you need to understand or apply normalization rules to clean up a database schema.
Open this prompt Learning · Intermediate
Explain Database Normalization Techniques
Use this when you need a clear explanation of normalization concepts (functional, partial, transitive dependencies) with examples from your specific database scenario.
Open this prompt Learning · Intermediate
Explain Database Types And Constraints
Use this when you need a clear explanation of which data types and constraints to use for a specific database design.
Open this prompt Learning · Intermediate
Optimize Database Performance with Modeling
Use this when you need guidance on denormalization, partitioning, caching, or other schema design techniques to boost database performance.
Open this prompt Creating · Advanced
Recommend Database Indexing Strategy
Use this when you need to decide where to add, avoid, or optimize indexes for a database's query performance.
Open this prompt Analysis · Advanced
Review Database Design Best Practices
Use this when you're designing or reviewing a database and want a check against best practices for integrity, scalability, and performance.
Open this prompt Analysis · Advanced