Database Schema Design

What it does

This skill helps design relational database schemas based on provided requirements. It can generate SQL DDL statements to create tables, define relationships (primary keys, foreign keys), and suggest appropriate data types for columns. The resulting schema is optimized for efficiency and data integrity.

When to use it

• You need a database designed from scratch but lack the expertise or time to do so manually.
• You have existing requirements for a database but are unsure how to translate them into a relational schema.
• You want to explore different schema designs quickly, iterating on options based on performance considerations.
• You're building an application and need assistance in defining the underlying data structure.

Key capabilities

• Generates SQL DDL statements.
• Defines table structures with columns and data types.
• Establishes relationships between tables (primary/foreign keys).
• Optimizes schemas for efficiency and integrity.

Example prompts

• "Design a database schema for an online bookstore, including tables for books, authors, customers, and orders."
• "Create a relational database schema to manage student enrollment in courses, with details on students, courses, and their registration status."
• “I need a database schema for tracking inventory of a retail store. Include products, suppliers, and stock levels.”

Tips & gotchas

The quality of the generated schema heavily relies on the clarity and completeness of the provided requirements. Be as specific as possible when describing your data needs to ensure optimal results.