Explain how you would structure database tables and write SQL queries to handle high-volume transactional data.