Download Exam #1 | ACCT - Accounting & Information Systems and more Quizzes Accounting in PDF only on Docsity!
Define Schema
Description of the data elements in a database. TERM 2
What are the 3 levels of schema?
DEFINITION 2 External level Conceptual level Internal level TERM 3
Data Processing Cycle
DEFINITION 3 The steps a company must follow to efficiently and effectively process data about its transactions TERM 4
Source Documents
DEFINITION 4 Paper documents used to capture transaction data at its source TERM 5
Turnaround Documents
DEFINITION 5 Records of company data sent to an external party and then returned to the system as input
Source Data Automation
Devices that capture transaction data in machine-readable form at the time and place of their region; e.g. atm's TERM 7
General
Ledger
DEFINITION 7 Contains summary level data for every asset, liability, equity, revenue, and expense account TERM 8
Subsidiary
Ledger
DEFINITION 8 Contains detailed data for any general ledger account with many individual subaccounts TERM 9
Control Account
DEFINITION 9 The GL account corresponding to a subsidiary ledger, where the sum of all subsidiary ledger entries should equal the amount in the GL account TERM 10
Coding
DEFINITION 10 Systematic assignment of numbers or letters to items to classify and organize them
General Journal
Used to record infrequent or non routine transactions TERM 17
Specialized Journal
DEFINITION 17 Used to record large numbers of repetitive transactions TERM 18
Audit Trail
DEFINITION 18 Path of a transaction through a data processing system from point of origin to final output, or backward from final output to point of origin TERM 19
Entity
DEFINITION 19 The item about which information is stored in a record. TERM 20
Attribute
DEFINITION 20 Characteristics of interest that need to be stored
Field
Portion of a data record that contains the data value for a particular attribute, like a cell in a spreadsheet TERM 22
Record
DEFINITION 22 Fields containing data about entity attributes; like a row in a spreadsheet TERM 23
Data Value
DEFINITION 23 Contents of a specific field, such as "Brandon" in a name field TERM 24
Master File
DEFINITION 24 Contains records of individual business transactions that occur during a specific time period TERM 25
Transaction File
DEFINITION 25 Stores cumulative information about an organization; like a ledger in a manual AIS
How can AIS add value to a company?
Reduce costs of products or services Improves quality of products and services Improves efficiency Shares knowledge Improves SCM TERM 32
Define AIS
DEFINITION 32 A system that collects, records, stores, and processes data to produce information for decision makers TERM 33
Disect the term CRUD
DEFINITION 33 C - Creating R - Reading U - Updating D - Deleting TERM 34
Define ERP
DEFINITION 34 Enterprise Resource PlanningIntegrates all aspects of an organization's activities--accounting, finance, marketing, HR, etc.
