1/38
Looks like no tags are added yet.
Entity
something about which an organization wants to collect and store information
Attribures
Identifying properties of an entity stored in a database
Field
box or space where information is held
Record
Rows of fields associated with an entity describing its attributes
Master file
Permanent file of records that stores cumulative data about an organization. Updated by transaction files
Transaction file
file containing individual business transactions during a fiscal period
Batch Processing
cheaper and more efficient way to process accumulating transactions by processing them in intervals.
Real-time processing
Updating each transaction as they occur
Context Diagram
High level view of a DFD
Level 0 DFD
Level of a DFD that has no significant steps past 1.0, 2.0, 3.0, etc…
Application Programming Interfaces
Structured interface that allows one system to interact with another system offering a data service to other systems.
Input Controls
Controls that control the data entered into a system to confirm their validity
Forms design
Cancellation and storage of documents
Authorization and segregation of duties controls
visual scanning
data entry controls
Forms Design
Good forms design minimizes room for error or omissions through sequentially prenumbered documents and the use of turnaround documents.
Cancellation and Storage of Source Documents
Documents entered into the system should be canceled to avoid duplicates and inadvertent (or intentional) fraud. Digital documents already processed should be flagged as canceled
Data entry Controls
Types of input controls that prevent improper and wrong information form being put into a system
Field check
Sign check
limit check
range check
size check
completeness check
validity check
reasonableness check
Field Check
verifies that the characters entered into a field are the proper type. dollar value —> numbers only
Sign check
Makes sure a number has a correct arithmetic sign. Dollars should not be negative if we are making a sale.
Limit check
creates a limit on how high a number can be entered into a field
Range check
Creates a ceiling and floor limit of a numerical value allowed in a field
Size Check
Ensures that the data value fits into the assigned field for visibility
Completeness Check
makes sure that the required data items are entered
Validity Check
makes sure that data entered matches similar data in a masterfile like the ID number. Compares entered data with masterfile data.
Enter item number 65324 to see if it even exists.
Reasonableness test
Checks the relationship between two data items for logical relationships.
If you haven’t worked past 40 hours there should be no overtime hours logged.
Check Digit
A digit in an ID code that is assigned to items, customers, or profiles of information and appended to the end of that code.
Check digit verification
Recalculation of a check digit to identify data entry errors.
Sequence check
An edit check that determines if a transaction file is in proper numerical or alphabetical order.
Batch Totals
Sum of numerical items to verify completeness of a batch
Financial total
Sums of fields containing monetary values to verify completeness of records
Hash totals
sums of nonfinancial fields that have no other purpose or meaning that to check for completeness.
Record Count
type of batch total that equals the number of records processed at a time
Prompting
online data entry completeness check that requests each required item of input data and then waits for an acceptable response before requesting the next required item.
Closed-loop verification
Checks accuracy of data by displaying drop down menus of related information.
Header Record
A label located at the beginning of each file that contains the file name, expiration date, and other identification data.
Trailer record
Label located at the end of a file that contains batch totals calculated during input. Used to verify accuracy after the system reads the input
Transposition Error
An error in inputting information where two adjacent digits were inadvertently reversed. From 46 to 64
(if a financial or hash total discrepancy is evenly divisibly by 9)
Cross Footing balance test
Processing control that verifies accuracy by comparing two alternative ways of calculating the same total.
Zero Balance Test
Verifies the balance of control account equals zero after all entries to it have been made
Concurrent update controls
Prevents the errors that occur when two people try to update data at the same time
Checksums
data transmission control that uses a hash of a file to verify accuracy