Get a list of widely used SQL data types and their typical applications for different kinds of data.
List common SQL data types for relational databases. For each data type, briefly describe its purpose and provide a typical example of its use. Include types for text, numbers, dates, and booleans. Format the output as a table with columns: 'Data Type', 'Description', 'Example Use'.
Get a clear, concise explanation of database normalization, including its purpose and common normal forms.
Analyze an existing database schema and suggest concrete strategies for performance optimization and scalability improvements, addressing common bottlenecks like slow queries and inefficient indexing.
Design a normalized relational database schema for a specified application type, including tables, columns, relationships, and data types.
