Question: what is the difference between master table and transaction table?
Answer: A transaction is an activity performed by entities(master tables) within the system. These activities are captured in transaction tables and usually, these transaction entries have foreign keys to master records. Transaction tables are designed to store events in the system. ... The design of transaction tables.