Prompt lesson · 20 prompts
Data Modeling prompts for Systems Analysts
20 ready-to-use prompts from our AI for Systems Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Create Entity-Relationship Diagrams
Use this when you need to visualize and analyze the relationships between entities in a database to design or refine an ERD.
Role You are a database designer who helps create and refine Entity-Relationship Diagrams by analyzing entities, attributes, and relationships.
Context you provide
- {{entities}}: List of entities or a dataset description (e.g., customers, orders, products).
- {{relationships}}: Any known relationships or business rules (optional).
- {{database_schema}}: Existing schema if you want to identify redundancies (optional).
Instructions
- If inputs are missing, ask for them before proceeding.
- Identify all entities and their key attributes from the provided information.
- Determine relationships between entities, including cardinality (one-to-many, many-to-many) and participation constraints.
- Suggest a hierarchical structure if inheritance relationships are relevant.
- Identify any redundant or unnecessary entities and recommend removals for a streamlined design.
Output format Provide a text-based ERD description: list entities with attributes, then relationships with cardinality and participation. Include a summary of recommendations. Use clear, structured formatting.
Guardrails
- Do not invent entities or attributes not implied by the input.
- Flag assumptions about business rules.
- Focus on logical design, not physical implementation details.
Example Entities: Customer, Order, Product; relationships: Customer places Order, Order contains Product.
Open this prompt Creating · Intermediate
Database Normalization and Redundancy Analysis
Use this when you need to analyze a database or dataset for redundancy, inconsistencies, or anomalies and plan a normalization strategy.
Role You are a data management expert specializing in database normalization and data integrity. Your goal is to help me identify redundancy, inconsistencies, and anomalies in my data and provide actionable normalization strategies.
Context you provide
- {{database_description}}: A brief description of the database schema, tables, and relationships, or a sample of the dataset.
- {{dataset_sample}}: A sample of the data (if not covered by the database description) to analyze for formatting inconsistencies or anomalies.
- {{data_types_structures}}: Any specific data types or structures that need special consideration.
Instructions
- If any of the required context is missing, ask me to provide it before proceeding.
- Analyze the provided database or dataset to identify duplicate records, redundant data entries, formatting inconsistencies, and potential anomalies.
- For each issue found, explain how it impacts data integrity and consistency.
- Recommend normalization techniques (e.g., 1NF, 2NF, 3NF) and specific steps to eliminate redundancy and ensure data integrity.
- If requested, provide a script or pseudocode to automate the normalization process, considering the given data types and structures.
Output format Provide a structured report with sections: Summary of Findings, Detailed Issues, Normalization Recommendations, and (if applicable) Automation Script. Use clear headings and bullet points. Keep the tone professional and concise.
Guardrails
- Do not invent data or issues not present in the provided context.
- Flag any assumptions you make about the data or schema.
- Stay focused on normalization and data integrity; do not provide unrelated database advice.
Example
- {{database_description}}: "A customer database with tables: Customers, Orders, and Products. Orders contain customer names and product names directly."
Open this prompt Analysis · Intermediate
Define Data Attributes
Use this when you need to identify and define the key attributes for data entities in a system.
Open this prompt Creating · Intermediate
Compare Data Modeling Tools
Use this when you need to evaluate and compare data modeling tools to select the best fit for your project requirements.
Open this prompt Analysis · Intermediate
Data Modeling Best Practices
Use this when you need to design, optimize, or validate a data model for efficiency, scalability, and accuracy.
Open this prompt Analysis · Intermediate
Data Modeling Documentation Guide
Use this when you need to document data modeling processes, including steps, relationships, and outputs.
Open this prompt Writing · Intermediate
Data Model Validation
Use this when you need to validate a data model against industry standards, regulatory requirements, or operational needs.
Open this prompt Analysis · Intermediate
Domain-Specific Data Modeling Guidance
Use this when you need tailored data modeling strategies for a specific industry or domain.
Open this prompt Planning · Intermediate
Entity-Relationship Diagram Design
Use this when you need to design or refine an entity-relationship diagram for a system or database.
Open this prompt Creating · Intermediate
Create Data Flow Diagrams
Use this when you need to visualize how data moves through a system, including sources, processes, and destinations.
Open this prompt Creating · Intermediate
Create Conceptual Data Models
Use this when you need to define high-level business concepts and their relationships for a system or project.
Open this prompt Creating · Intermediate
Design Logical Data Models
Use this when you need to create a logical data model that defines the structure and relationships of data elements for a system.
Open this prompt Creating · Advanced
Physical Data Model Design
Use this when you need to design a physical data model for a system, including tables, relationships, data types, and indexes.
Open this prompt Creating · Intermediate
Create Data Dictionaries
Use this when you need to generate a data dictionary that defines data elements and their attributes for a system.
Open this prompt Creating · Intermediate
Map Data Integration Processes
Use this when you need to analyze and map how data from different sources will integrate into a target system.
Open this prompt Analysis · Intermediate
Assess Data Quality
Use this when you need to evaluate a dataset for accuracy, completeness, and consistency, and get recommendations for improvement.
Open this prompt Analysis · Intermediate
Define Data Transformation Rules
Use this when you need to specify how data will be transformed from source to target systems during integration or migration.
Open this prompt Creating · Intermediate
Plan Data Migration
Use this when you need to plan a data migration project, including steps, risks, and best practices.
Open this prompt Planning · Intermediate
Design a Data Warehouse Model
Use this when you need to design a data warehouse model for a specific industry or business domain.
Open this prompt Creating · Intermediate
Master Data Management Strategy
Use this when you need to develop or improve your master data management strategy, including governance, quality, and cleansing processes.
Open this prompt Planning · Intermediate