skills.rest
Arnutt-N
Arnutt-NCOMMUNITY
Explore all skills by this author →
GitHub

Database Design & ER Diagram

Designs normalized relational databases and creates Mermaid ER diagrams.

Updated Jan 8, 2026
Search Tags:#mermaid#normalization#relational-database#data-modeling#erd#database-design#er-diagram
One-click install
npx skills add https://github.com/Arnutt-N/hr-ims --skill database-design-er-diagram
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Design & ER Diagram
Source: https://github.com/Arnutt-N/hr-ims/tree/main/.agents/skills/database-design-erd
Command: npx skills add https://github.com/Arnutt-N/hr-ims --skill database-design-er-diagram

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing relational databases and producing clear ER diagrams can be complex, error-prone, and hard to translate requirements into a scalable data model.

Core Features & Use Cases

  • Normalization guidance (1NF, 2NF, 3NF) to reduce redundancy and preserve data integrity.
  • Entity-relationship modeling and Mermaid ER diagrams to visualize schemas.
  • Practical best practices for naming conventions, auditing fields, indexing, and security.
  • Hands-on workshops and exercises to apply concepts to real-world data modeling tasks.

Quick Start

Follow this guide to design a normalized relational model for a sample domain and render its ER diagram using Mermaid to solidify your understanding.

Frequently Asked Questions about Database Design & ER Diagram

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a relational database and generate an ER diagram?▼

To design a relational database and generate an ER diagram, you model entities and relationships, apply normalization rules, and render the schema using Mermaid for clear visualization.

What is database normalization and how do 1NF, 2NF, and 3NF reduce data redundancy?▼

Database normalization applies 1NF, 2NF, and 3NF rules to relational database schemas to eliminate data redundancy and preserve integrity by structuring tables and relationships correctly.

How do I create a Mermaid ER diagram for my data modeling tasks?▼

You create a Mermaid ER diagram by defining your entities, attributes, and relationships during data modeling, then translating that relational database structure into Mermaid syntax for rendering.

What are the best practices for naming conventions and indexing in database design?▼

Best practices for database design include adopting consistent naming conventions for entities and attributes, defining auditing fields, and applying indexing strategies to optimize data retrieval.

Can I use this relational database design approach for academic training environments?▼

Yes, this relational database design approach suits academic and training environments by providing hands-on workshops and exercises to apply normalization and ER diagram concepts to real-world tasks.

Related Skills

Explore More Software Engineering Skills→
KentoShimizuKentoShimizu
7

db-logical-design

Define relational schemas with keys, constraints, and referential integrity.

Community
Advanced
ref-docsref-docs

database-schema-designer

Design database schemas with ER diagrams, normalization, and DDL generation.

Official
Advanced
OKHP3OKHP3
2

okhp3-mermaid-data

Generate entity-relationship and class diagrams in Mermaid syntax for database schemas.

Community
Intermediate
DauQuangThanhDauQuangThanh
14

database-design

Design relational and NoSQL database schemas from business requirements.

Community
Advanced