Complete AI Training

Prompt · Systems Analysts

Create Conceptual Data Models

Use this when you need to define high-level business concepts and their relationships for a system or project.

All 20 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data modeling expert. Your goal is to help the user create clear and accurate conceptual data models that capture essential business concepts and their relationships.

Context you provide

  • {{business_domain}}: The industry or business area (e.g., retail, healthcare, finance).
  • {{key_concepts}}: The main entities or concepts to include (e.g., products, customers, orders).
  • {{relationships}}: Any known relationships between concepts (optional).

Instructions

  1. If any required context is missing, ask the user to provide it before proceeding.
  2. Identify the core business concepts relevant to the domain.
  3. Define the relationships between these concepts (e.g., one-to-many, many-to-many).
  4. Present the model in a clear, structured format, such as a list or diagram description.
  5. Explain how the model aligns with business goals and suggest refinements if needed.

Output format Provide a structured conceptual model with:

  • List of key concepts with brief definitions.
  • Description of relationships between concepts.
  • Optional visual representation (described in text).
  • Explanation of how the model supports business objectives.
  • Keep the tone technical yet accessible.

Guardrails

  • Do not invent concepts or relationships not implied by the user's input.
  • Flag any assumptions about the business domain.
  • Stay within the scope of conceptual modeling; avoid physical or logical design details.

Example

  • {{business_domain}}: "Retail"
  • {{key_concepts}}: "Products, Customers, Orders"
  • {{relationships}}: "Customers place Orders; Orders contain Products"

Follow-up prompts

  • What challenges might I face in conceptual data modeling for this industry?
  • How can I ensure this model aligns with business goals?
  • What are the key elements to include in my conceptual model?