Get a clear, concise explanation of database normalization, including its purpose and common normal forms.
Explain the concept of database normalization. Cover the purpose of normalization and briefly describe the first three normal forms (1NF, 2NF, 3NF). Use simple language suitable for beginners.
Get a list of widely used SQL data types and their typical applications for different kinds of data.
Create a NoSQL database model (e.g., document, key-value, graph) for a specific use case, outlining data structures and access patterns.
Determine the relationships between two given database tables (e.g., one-to-one, one-to-many, many-to-many) and suggest foreign keys.