What is the difference between data and information?
Data is facts whereas information is facts within a context
Information is only facts
decisions are made based off of information
decisions are made based off of data and information
Select the characteristics of information
The Production Cycle consists of getting labor and giving materials
What is the Business Cycle: Getting materials and giving cash
What does an AIS fulfill?
Collection of Data
Turning data into information
Providing adequate controls
Making decisions based off of decisions
An AIS adds value by improving the quality and efficiency of decision making, as well as reduce cost, share knowledge and improve internal controls
Which of the following is NOT an example of a Primary Activity of an AIS in a value chain?
Marketing and Sales
Which of the following is NOT an example of a support activity for an AIS in a value chain?
Primary activities of an AIS in a value chain provides value to the customer
The steps in processing data input are:
1. transaction data
2. make sure captured data is
3. ensure are followed
Which of the following is an example of a turnaround document?
A code where two or more subgroups of digits are used to code the item is considered a ___ Code
What are the general rules for the characteristics of code?
Consistency with intended use
Consistent with company
consistent with personal ideals
What is not a characteristic of a general ledger?
summary level information
asset and liabilities shown
used for financial statements
contains control accounts
The sum of subsidiary account balances should be ____ to the balance in the control account
General Journals are used to record what types of transactions?
non routine transactions
journals record repetitive transactions
Which of the following journals are not an example of a speciality journal?
Why is a master file similar to a ledger in a manual AIS?
Exists across only 1 fiscal period
Changes can't be made to file
What makes a transaction file unique?
Files are temporary
Files are permanent
Files are maintained for one fiscal period
Files maintained over many fiscal periods
Which of the following is NOT part of CRUD database processing?
Creating new records
Reading existing data
Updating previous records
Batch processing: documents are stored in batches and periodically entered into the computer system. The temporary file is then run agains the master file to update the master and the output is printed along with error reports.
What is the difference between online batch processing and online real time processing?
Master file is immediately updated in the batch processing
Master file is immediately updated in transaction processing
Output is printed in transaction but not in batch
Transactions are entered as they occur for real time processing
Which of the following is NOT an advantage of an ERP?
Integrated enterprises (better flow of the information)
Data captured only once
Improve access of control through security settings
What is the biggest disadvantage of an ERP?
Significant amount of time
disruptive to company's business cycle
Why were databases created?
Duplicated information in many master files
data integration was difficult
organization-wide view of data was hard to acheive
The physical view of teh database is at the level, this is how the data is stored in the system
Who would NOT typically look at a database at its logical view?
The ER diagram is typically used at the level because it shows the schema of the database with the entities connected by a diamond.
Which of the following is NOT a characteristic of DDL? (Data Definition Language)
Builds the data dictionary
Creates the Database
describes the logical view
changes the content in the database
specifies recor or field security constraints
A key is the attribute or combination of attributes that uniquely define a specific row in a table
Say student A is shown in the database 3 times. You need to change their phone number, you only do it on the first row. In doing so, you forget to change the other 2 rows with the old phone number. What kind of anomoly is this?
Being unable to add a record to the database is considered what kind of anomoly?
A key links the tables in a database together.
Which of the following is NOT a rule for relational databases?
Every column in a row must have a single value
Primary keys can be empty
Foreign keys can be empty, BUT if not empty the value must correspond to a primary key in another table
all attributes must describe characteristics of the object identified by the primary key
Cardinality is the max number of instances of that may be related to of another entity
Modality is the number of instance of one entity that can be related to a specific instance of another entity