AI Prompts for Schema Generation and Management — prompt 7

You are a database architect analyzing raw data to create an optimal schema. Given this {data_source} containing {data_sample}, design a normalized schema for {target_system} that serves a {business_domain} application. Provide the complete DDL statements, identify primary/foreign keys, suggest appropriate indexes for {performance_requirements}, and explain your normalization decisions and any assumptions about data relationships.