Matching

1.Subsidiary Ledger a record of a transaction or other company data EX: checks, purchase requisitions

2.Query The portion of a data record where the data value for a particular attribute is stored

3.Document a ledger used to record detailed data for a general ledger account with many individual subaccounts, such as A/R, inventory, and A/P

4.Master File a request for the data base to provide the information needed to deal with a problem or answer a question. The information is retrieved, displayed or printed, and/or analyzed as requested

5.Field a permanent file of records that stores cumulative data about an organization. As transactions take place, individual records within master files are updated to keep them current

Multiple choice questions

The properties, identifying numbers, and characteristics of interest of an entity that is stored in a database

A. Data Value

B. Master File

C. Data Processing Cycle

D. Attributes

Two or more subgroups of digits that are used to code an item. a group code is often used in conjunction with a block code

A Group Code

B General Ledger

C Block Code

D Mnemonic Code

Blocks of numbers that are reserved for specific categories of data, thereby helping to organize the data. EX: Chart of Accounts

A Group Code

B Mnemonic Code

C Record

D Block Code

The item about which information is stored in a record

A Date Value

B File

C Query

D Entity

The systematic assignment of numbers or letters to items to classify and organize them

A Entity

B Document

C Field

D Coding

True / False Questions

a path that allows a transaction to be traced through a data processing system from point of origin to output or backwards from output to point of origin. It is used to check the accuracy and validity of ledger postings and to trace changes in general ledger accounts from their

beginning balance to their ending balance Master File

True

False

Letters and numbers that are interspersed to identify an item. Derived from the description of the item and is usually easy to memorize Group Code

True

False

Title given to a general ledger account that summarizes the total amounts recorded in a subsidiary ledger. Control Account

True

False

Accumulating transaction records into groups or batches for processing at regular interval such as daily or weekly. The records are usually sorted into some sequence (such as numerically or alphabetically) before processing Batch Processing

True

False

Employee #, Pay Rate, Name and address Example of an Attribute

True

False