Question

In: Accounting

Differentiate between types of table and the data stored in these tables (Master, Transaction, and Reference...

  1. Differentiate between types of table and the data stored in these tables (Master, Transaction, and Reference tables)

Solutions

Expert Solution

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.


Related Solutions

Task 2 (1 mark) Transformation of data stored in the relational tables into data stored in...
Task 2 (1 mark) Transformation of data stored in the relational tables into data stored in BSON collection.
Differentiate between the four types of interviews. (12)
Differentiate between the four types of interviews. (12)
Explain the differences between primitive and reference data types. Define the scope of a variable (hint:...
Explain the differences between primitive and reference data types. Define the scope of a variable (hint: local and global variable) Why is initialization of variables required. Differentiate between static, instance and local variables. Differentiate between widening and narrowing casting in java. the following table shows data type, its size, default value and the range. Filling in the missing values. TYPE SIZE (IN BYTES) DEFAULT RANGE boolean 1 bit true, false Char 2 ‘\0000’ to ‘\ffff’ Byte 0 Short 0 -215...
Implement a stored procedure to handle a complete transaction. Also implement a trigger to validate data...
Implement a stored procedure to handle a complete transaction. Also implement a trigger to validate data before a transaction is permitted to execute. Schema: Customer Table CustomerID (PK). FirstName (NOT NULL). LastName (NOT NULL). Address. City. State. Zip. Country. Phone. Email (UNIQUE and NOT NULL). Username (UNIQUE and NOT NULL). Password (NOT NULL). Order Table OrderID (PK). CustomerID (FK). OrderDate. ShipDate. Order Detail Table OrderDetailID (PK). OrderID (FK). ProductID (FK). Price. Quantity (CHECK > 0). Product Table ProductID (PK). CategoryID...
Differentiate between the three main types of audits and auditors.
Differentiate between the three main types of audits and auditors.
Differentiate between two types of nephrons found in kidneys
Differentiate between two types of nephrons found in kidneys
COURSE: IT Decision Support Systems Differentiate between Descriptive and Prescriptive Analytics. What types of tools/data are...
COURSE: IT Decision Support Systems Differentiate between Descriptive and Prescriptive Analytics. What types of tools/data are used in each of these analytics?
3. Identify the following as master data or transaction data Create New Customer Create Contact Person...
3. Identify the following as master data or transaction data Create New Customer Create Contact Person for Customer Create BP relationship Create Customer Inquiry Create Customer Quotation Create Sales Order Referencing a Quotation Check Stock Status Display Sales Order Start Delivery Process Check Stock Status Pick Materials on Delivery Note Post Goods Issue Check Stock Status Create Invoice for Customer Display Billing Document and Customer Invoice Post Receipt of Customer Payment Review Document Flow
Which of the following files is a temporary file? a. transaction file b. master file c. reference file d. none of the above
Which of the following files is a temporary file? a. transaction fileb. master filec. reference filed. none of the above
Create a table in SQL with foreign key reference: 1.Create the three tables without any columns...
Create a table in SQL with foreign key reference: 1.Create the three tables without any columns 2.Alter the tables to add the columns 3.Alter the tables to create the primary and foreign keys
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT