How Master table is different from Transaction table? Describe both with examples.
Answers
Answered by
9
Master Table
During database design, the master tables are designed first. Since the purpose of master tables is to capture the system. The design of the master tables i.e. its columns and constraints describe the entities in the system. For example user, account, customer etc. Generally, entities of the system are mapped to master tables.
Transaction Table?
To understand the difference between the two types we need to understand what exactly we mean by a transaction. 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.
During database design, the master tables are designed first. Since the purpose of master tables is to capture the system. The design of the master tables i.e. its columns and constraints describe the entities in the system. For example user, account, customer etc. Generally, entities of the system are mapped to master tables.
Transaction Table?
To understand the difference between the two types we need to understand what exactly we mean by a transaction. 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.
Similar questions