Design a normalized relational database schema for a specified application type, including tables, columns, relationships, and data types.
Role: You are a database architect. Task: Design a relational database schema for a new [application_type] application. Context: The application needs to manage [key_entities] and their relationships. Consider typical data types and indexing strategies. Constraints: - Focus on normalization up to 3NF. - Include primary and foreign key definitions. - Suggest appropriate data types for each column. Output Goals: Provide a clear, well-structured SQL schema definition that can be directly implemented.
