In: Accounting
The difference between different types of table and data stored in these table:
Master table : During data base design, the master tables are designed at first .The design of the master tables describe the entities in the system. Entities of the system are mapped to master tables.
Examples: user, account,customer etc.
Transaction table: A transaction is an activity performed by entities ( master tables) within the system .These activities are captured in transaction tables. Transaction entries have foreign keys to master records.
Examples: Pie chart, line charts, graphs are drawn using transaction tables.
Reference table: In the context of data base design a table in which an enumerated set of possible values of a certain field data type is divested, called reference table. It is also called Domin table.
Example : In a data base model of a warehouse the item may have a field called 'status' with values such as sold,unsold, In-stock, out of stock divested in reference table.
A. Master table data less likely to change. But transactions table data frequently changes.
B. Master table and reference table may not required timestamp.Transaction table data requires that.
C.Master table data less compared with transactions table. But transaction table data more compared to master tables.
D. Vertical partitioning in case of master table and reference table for normalization, horizontal partitioning in case of transaction table.
E. Master table contains store system information and transaction table contains captured system events.
F. Master table contains no index usually but transaction table contains index.