Describe a scenario where you had to design a database schema to handle complex, relational financial transactions.
