Term
3 Things companies Collect Data about: |
|
Definition
1. Events (Sale of Inventory)
2. Resources Affected by events (amt of inv)
3. Agents who part in the event (salesperson) |
|
|
Term
|
Definition
|
|
Term
|
Definition
data that has been processed into something meaningful |
|
|
Term
7 Characteristics that make information meaningful and useful... |
|
Definition
1. Relevant -Allow user to predict what will happen+ see what DID happen
2. Reliable - accurate + free of errors + bias
3. Completeness - everything important is included
4. Timeliness - available when necessary
5. Understandability - in a format that is understandable to the user
6. Verifiability - different users using the same approach will reach the same conclusion
7. Accessibility - The info is available when needed |
|
|
Term
|
Definition
1. Collect + Store data (about events, resources, agents)
2. Process the data into meaningful information
3. Provide adequate controls over the organization's assets, inc its data, to safeguard from theft, ensure availability, and ensure accuracy + reliability |
|
|
Term
Types of Value Chain activities + defs |
|
Definition
Primary - Directly provide value to the customer
or
Secondary - Allow the primary acts to occur efficiently and effectively |
|
|
Term
Primary Value Chain Activities (5) |
|
Definition
1. Inbound Logistics - receiving, storage + distribution the material used to make a prod)
2. Operations - activities related to transforming the mat into a prod
3. Outbound Logistics - activities related to getting teh prod/service to customers
4. Marketing + Sales
5. Service |
|
|
Term
Supporting Activities (4) |
|
Definition
1. Firm infrastructure (acct, legal, ais)
2. Technology
3. HR
4. Purchasing |
|
|
Term
Decision making can be based on either... |
|
Definition
|
|
Term
Structured decisions (types + defs) |
|
Definition
1. Structured - repetitive, routine + recurring
2. Semi-Structured - no obvious answer, some objective judgement
3. Unstructured - not recurring/routine, reqs a lot of subjective judgment |
|
|
Term
Scope decisions (types + defs) |
|
Definition
1. Operational Control Decisions - relate to specific day to day tasks (ordering inv)
2. Management Control Decisions - 'how do we use the resources of the org to meet the org objective?'
3. Strategic Planning Decisions - deal w/setting the org's objectives + creating policies used to meet them |
|
|
Term
5 Common Transaction Cycles |
|
Definition
1. Revenue Cycle - trans involving custs
2. Expenditure Cycle - trans involving supplies/vendors (can include utils)
3. Production Cycle - trans where mat/labor converted into finished prod
4. HR/Payroll Cycle - trans involving employees
5. Financing Cycle - Trans involving stockholders |
|
|
Term
Steps in the Data Processing Cycle |
|
Definition
1. Data Input
2. Data Storage
3. Data Processing
4. Information Output |
|
|
Term
|
Definition
deals w/capturing and entering data into the system
to improve data entry/accuracy:
1. Use turnaround docs
2. Source Data Automation
3. Pre-numbering source docs |
|
|
Term
Data Storage (def + info) |
|
Definition
storing data in a way that it can be easily accessed when needed.
storage places:
Ledger + general Ledger |
|
|
Term
|
Definition
Summary Level view of all accounts of the company |
|
|
Term
|
Definition
provides detailed data about specific accounts |
|
|
Term
|
Definition
a systematic assignment of letters _ numbers to organize + store items
types:
Sequential coding: items numbed sequentially...
Block coding: blocks of #'s w/in a sequence represent specific items - ex: Chart of accounts |
|
|
Term
|
Definition
exists when when a trans can be TRACED from source docs to ledger and SOURCED from ledger to source docs (don't need to know these i think...) |
|
|
Term
Computer Based Storage (files?) |
|
Definition
1. Entity - something abotu which data is collected + stored
2. Attribute - characteristics of an entity
3. Field - place to enter attributes
4. Record - a group of related fields
5. File - a group of related records
6. Database - a set of inter-related, centrall located files |
|
|
Term
|
Definition
steps taken to transform data into relevant meaningful info |
|
|
Term
Information Output (to...) |
|
Definition
Financial Docs
and
managment reports |
|
|
Term
|
Definition
Auditors are req to understand the automatic and manual procedures of a company.
can do this by documenting the company's internal controls
SarBox - req corp officers + auditors to continually test the co's internal controls |
|
|
Term
4 Basic elements of the DFD |
|
Definition
1. Data sources + destinations - ppl + orgs who provide data to the system - Square
2. Data flows - the movement of data btwn sources, destinations, processes + data stores - only label if not to/from a store
3. Transformation Processes - processes performed on the data to transform it into information - Circle
4. Data Store - a permanent or temprorary repository for data - Parallel Lines |
|
|
Term
|
Definition
represents the highest lvl DFD
provides a summary lvl view of the system
does NOT show data stores
shows 1 processesing system, sources + destinations |
|
|
Term
|
Definition
'Explodes' the processing system to show each process performed
# each transformation (1.0, 2.0, etc)
Shows data stores
can be exploded by process into a lvl 1 dfd |
|
|
Term
|
Definition
An analytical tool using a set of standard symbols to describe some aspect of an IS |
|
|
Term
|
Definition
1. Document Flow Chart - describes the flow of docs + info among diff depts w/in the org - weaknesses in the system become clearly evident
2. System Flow Chart - used to describe the relationship between inputs, processes, + outputs of an AIS
3. Program Flow Chart - used to describe the sequence of ops performed by a computer in executing a program |
|
|
Term
4 Categories of Flowcharting Symbols: |
|
Definition
1. Input/Output Symbols - devices used to put data into/take data from a ssytem
2. Processing Symbols - devices used to process data or indicate if data is processed manually
3. Storage Symbols - devices used to store data when it is not being used
4. Flow + Miscelaneous Symbols - tells us where the decisions are made (decisions = Diamond) |
|
|
Term
Problems before databases |
|
Definition
1. required a lot of space
2. became difficult to access the data when needed
3. same data was stored in multiple files
4. data became inconsistent |
|
|
Term
Parts of a database system (3) |
|
Definition
1. The database where the info is stored
2. The application programs that access the data in the DB
3. the DBMS (database management system) which acts as an interface between the app progs + the DB |
|
|
Term
Advantages of a DB system (7) |
|
Definition
1. Data Integration
2. Data Sharing
3. Reporting Flexibility (easy to make + change reports)
4. minimizes data redundency + inconsistencies
5. Data Independence - data maintained separately from the progs that access it
6. One central manager of the data
7. Separates the logical view from the physical view of the data |
|
|
Term
|
Definition
Represents how the users organize and see the data |
|
|
Term
|
Definition
relates to how/where the data is stored |
|
|
Term
Advantage of having 2 views: |
|
Definition
1. allows the user to query the DB w/o needing to know how/where teh data is stored
2. allows for changes in 1 view w/o having to change the other |
|
|
Term
|
Definition
the logical structure of a DB |
|
|
Term
|
Definition
1. Conceptual - wide view of all datta elements in the DB
2. External - consists of a set of logical views held by users who access the DB (each lgical view is a sub-schema)
3. Interal - a low level view of the data describing how/where it's stored |
|
|
Term
Required Funtions of a DB (3 langs) |
|
Definition
1. Creating the DB - Database Definition Language (DDL)
2. changing the database - Data Manupulation Language (DML)
3. Querying the Db - Data Query Language (DQL)
(things in () = DBMS Languages |
|
|
Term
DDL (DB Definition Language) |
|
Definition
a set of commands used to create the DB, establish the logical views of users, and impose security restrictions on who can access what parts of the DB |
|
|
Term
DML (DB Manipulation Language) |
|
Definition
a set of commands used to update, change, and delete data in the database |
|
|
Term
|
Definition
a set of commands that allows the users to access the data in the DB |
|
|
Term
|
Definition
an Abstract representation of the data in a relational DB |
|
|
Term
|
Definition
visualizes data as being stored in Tables |
|
|
Term
|
Definition
a row in a Table - contains data about a specific entity
each column contains attributes |
|
|
Term
|
Definition
an attirbute or combination of attributes that uniquely identify each row in a table |
|
|
Term
|
Definition
A column (atribute) in one table that serves as teh primary key in another table (to link them together) |
|
|
Term
4 key points for creating relational DB Tables: |
|
Definition
1. every cell in every table can only have 1 data value
2. the primary key can't be Null
3. Foreign keys can be null or match the data in the corresponding table where the attribute it a primary key
4. All non-key data values should describe a characteristic related to teh object identified as the primary key |
|
|