Designing a schema is hard. Let AI handle the normalization (1NF, 2NF, 3NF).
“Act as a Lead Database Architect. I need a schema for [App Description – e.g., Multi-vendor Marketplace].
1. Provide the SQL DDL commands.
2. Explain the relationships (One-to-Many, Many-to-Many).
3. Suggest indexes for high-read performance.
4. Create a sample complex JOIN query to fetch [Specific Report].”