Designing database schema takes hours. AI creates normalized schema with relationships instantly.
The Prompt:
Design database schema for: [Describe your application] Requirements: 1. Normalized (3NF minimum) 2. Include primary keys, foreign keys 3. Add indexes for common queries 4. Specify data types (be specific) 5. Add constraints (NOT NULL, UNIQUE, etc.) 6. Show relationships (1:1, 1:N, N:M) 7. Generate CREATE TABLE SQL statements Target database: [PostgreSQL/MySQL/SQL Server]
Example:
"E-commerce site with products, categories, users, orders, and reviews"
AI Generates:
– Complete ERD
– All tables with proper relationships
– Indexes for performance
– Ready-to-run SQL CREATE statements
– Explanation of design decisions