Client should be its own table, transaction is its own table (with foreign-key to clientID). You can ask ChatGPT to help you out.