designing-database-schemas

Designs normalized database schemas with ERD and SQL output.

• Creates database schemas from user requirements
• Applies normalization principles (1NF to BCNF)
• Generates ERD diagrams using Mermaid
• Produces SQL CREATE statements

• Analyzes data requirements for schema design
• Applies normalization to reduce redundancy
• Maps entity relationships (1:1, 1:M, M:M)
• Generates visual ERD diagrams
• Produces SQL CREATE statements
• Enforces referential integrity with foreign keys
• Adds indexes to improve query performance
• Supports integration with SQL execution and documentation plugins

1. 1.Define data requirements for the application
2. 2.Apply normalization and map relationships between entities
3. 3.Generate an ERD diagram using Mermaid
4. 4.Create SQL CREATE statements for tables, constraints, and indexes