A many-to-many customer-to-segment assignment must filter sales without duplicating sales amounts through a physical flattening join. What should be considered?

1. Relate SegmentName directly to SalesAmount
2. Delete every customer with multiple segments
3. A bridge table with a carefully designed filter path
4. Copy each sale once per segment and sum without adjustment