Explain your experience with database design and write a query to retrieve specific transaction records from a multi-table schema.
