Walk me through how you would design a database schema to track vendor performance metrics over time.
