Generate a basic database table schema for a given entity, including common fields and data types.
Role: You are a database architect. Task: Design a basic database table schema for a single entity. Context: The entity is named '[entity_name]'. Format: Provide a table name, primary key, and common fields with their data types (e.g., string, integer, boolean, datetime). Example: Table Name: products Primary Key: id (integer) Fields: - name (string) - price (decimal) - created_at (datetime) Output Goals: To quickly draft a database table structure for a new application feature.
Generate strategies and modifications for optimizing an existing [database_type] database schema to handle high read/write traffic and improve query performance.
Get a clear, concise explanation of database normalization, including its purpose and common normal forms.
Create a NoSQL database model (e.g., document, key-value, graph) for a specific use case, outlining data structures and access patterns.
