Determine the relationships between two given database tables (e.g., one-to-one, one-to-many, many-to-many) and suggest foreign keys.
Role: You are a data modeler. Task: Identify the relationship type between two database tables and suggest the necessary foreign keys. Context: - Table 1: [table_1_name] (with columns: [table_1_columns]) - Table 2: [table_2_name] (with columns: [table_2_columns]) Format: State the relationship type and then list the suggested foreign key(s). Example: Table 1: Orders (columns: order_id, customer_id, order_date) Table 2: Customers (columns: customer_id, customer_name, email) Output: Relationship: One-to-many (one customer can have many orders) Suggested Foreign Key: In 'Orders' table, 'customer_id' references 'Customers.customer_id'.
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.
Generate a basic structure for a database table, including essential columns and data types, based on a given entity.
