AIS Exam #1, Chapters 1 - 6

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

The relationship between the periodic mode and batch processing is:

Batch processing is the processing of data as a group

Which of the following entities would be considered external to a process in a data flow diagram of a cash receipts process?

Both banks and customers are external entities

What is a physical data flow diagram (DFD)?

A diagram that specifies where, how, and by whom a system's activities are accomplished

Which of the following is a supporting activity in the value chain?

Accounting

When does functional dependence exist?

If a value for the first attribute determines a single value for the second attribute

Which types of updates can be made to master data?

Information processing and data maintenance

If the customer service process were integrated:

Input of the customer name or number gives access to the customer data The system automatically determines the price and the customer's creditworthiness The enterprise system establishes the ATP date by determining whether the item is available in warehouses, scheduled to be manufactured and when it will be available.

Describe the basic differences between ES and NN (expert systems vs neural networks)

NNs develop their own knowledge base and continue to learn

Are the terms system and subsystem synonymous?

No. Each part of a system is known as a subsystem

Structure of tables must comply with several rules called ______ _____ that include specifications that must be met by relational database tables. Failure to follow the rules results in ________ or errors that might occur when adding, changing, or deleting data stored in the database. The goal of normalization is to produce a database model that contains relations that are in ____.

Normal forms anomalies third normal form (3NF).

The relationship between online real-time (OLRT) and immediate mode processing:

OLRT completes all stages of business event data processing in immediate mode

Online transaction entry (OLTE) system and Online real-time (OLRT) systems (or immediate mode)

OLTE is Use of data entry devices to enter business event data directly into the information system at time and place that business event occurs. and OLTR Gathers and records business event data at time of occurrence.

Recursive Relationship

Occurs between two different instances of an entity. Ex) when one employee supervises other employees. a link is created between the employee who is being supervised and the employee who is the supervisor.

If information has reliability, then it is:

Regarded as true and credible

Which software automates sales tasks such as order processing and inventory monitoring?

Sales force automation (SFA) software

Which of the following is a step in the order-to-cash process?

Sales order processing

______ ______ requires summarized and external information.

Strategic management

Which software helps enable the steps in an organization's supply chain?

Supply chain management (SCM) software

A(n) ______ ______ is a graphical representation of a business process.

Systems Flowchart

Legacy systems:

Systems that have existed in an organization over a long period of time and were developed using an organization's previous computer hardware and software platforms

______ ______ require information that is summarized, broader in scope, and need not be accurate

Tactical management

The advantage of a logical DFD is that the focus is on:

The activities that a system performs

business analytics

The analysis of big data is often referred to as BI, and is also sometimes called business analytics

The systems flowchart combines which aspects?

The physical and logical

Which statement is true regarding knowledge management?

The primary enabler is information technology

Classifying and Coding

The process of grouping or categorizing data according to common attributes is CLASSIFYING and coding is the creation of substitute values, or codes, to represent classification categories' long labels.

What is the purpose of a systems flowchart?

The purpose of the systems flowchart is to give the reader a complete picture of a system by combining the physical and logical aspects

What is the purpose of a table of entities and activities?

The table summarizes the narrative so that entities (nouns) and activities (verbs) found in a narrative are clearly identified

Explain when a database designer might use a relationship table in constructing a relational database.

To link two relational tables in a M:N relationship

Why do we need to document an information system?

To understand and improve the system To evaluate the structure of the company's internal controls To comply with regulatory requirements

A ____ contains repeating attributes (fields) within each row (or record).

Unnormalized table

In an automated accounting system, activities include all of the following:

Update AR master data Update GL master data Prepare trial balance

Dependencies cause several problems, called _______ _______:

Update anomalies

Which of the following are activities associated with an automated accounting process?

Update master data

Online real-time (OLRT) systems:

Update the master data essentially instantaneously Provide the results arising from the business event Gather business event data at the time of occurrence,

Add-on modules that complement the core elements of an ERP system do not include:

Vendor relationship management (VRM) software But do: Customer relationship management (CRM) software Customer self-service (CSS) software Supply chain management (SCM) software

The difference between wide area networks (WANs) and local area networks (LANs) is:

WANs link local networks into an integrated communications network LANs link shared devices

When is a set of DFDs balanced?

When two DFDs have equivalent external data flows, the DFDs are balanced

An entity is

an accounting system is a resource, event, or agent about which data are collected. (Resources include inventory, equipment, cash) (Events include orders, sales, purchases Agents include customers, employees, vendors)

A table is in ___ if it doesn't contain repeating groups.

first normal form (1NF)

An instance of an entity:

is one specific thing of the type defined entity

Which of the following SAP modules is used to automate the order-to-cash process?

Sales and Distribution (SD)

The four main elements in a relational database?

1) Tables: A place to store data. 2) Queries: Tools that allow users to access the data stored in various tables and to transform data into information. 3) Forms: Onscreen presentations that allow users to view data in tables or collected by queries from one or more tables and input new data. 4) Reports: Printed lists and summaries of data stored in tables or collected by queries from one or more tables.

Strategy for identifying relationships that should be included in a model.

1. Identify users' information requirements to determine if relationships in the data model can fulfill them. 2. Evaluate each of the entities in pairs to determine which entity in the pair provides a better location to include an attribute. 3. Evaluate each entity to determine if there is a need for two occurrences of the same entity type to be linked.

Creating an individual REA diagram

1. identify the event entities 2. identify the resources entities 3. identify agent entities determine associations and cardinalities between entities

Which of the following statements is true concerning normalization?

2NF does not contain partial dependencies

What is a logical DFD?

A diagram that shows what activities the system is performing

Describe all the symbols used in constructing DFDs.

A data flow symbol represents a pathway for data and a data store symbol represents a place where data are stored An external entity symbol portrays a source or a destination of data outside the system A bubble symbol depicts an entity or a process within which incoming data flows are transformed into outgoing data flows

What is a data flow diagram (DFD)?

A diagram that depicts the data flows among the components in a process and the sources, destinations, and storage of data used in the process

Tuple

A set of data that describes a single instance of the entity represented by a relation.

Model

A simplified representation of a complex entity or phenomenon.

Organization, interrelationships, integration, and central objectives must be present in a system because:

A system is a set of interdependent elements that together accomplish specific objectives

What is a context diagram?

A top-level diagram of a system that depicts the system and all its activities as a single bubble

Which of following activities are not considered on a level 0 DFD depicting a particular grouping of the logical activities?

Activities performed by the operations process Actions performed in other-than-normal situations Actions that merely send or receive data rather than transform data

Internet commerce simplifies the world of E-business by:

Allowing the organization to provide templates based on a customer's needs

What is the relationship between an AIS and an IS?

An AIS cannot be distinguished separately from an IS

The purpose of creating flowcharts is to:

Analyze and understand a system Simplify and clarify a narrative Portray a system's logic and implementation

Intelligent Agents:

Are sometimes called "bots" Are frequently used by search engines Perform their tasks without further direction from the user

Significant digit coding:

Assigns meanings to specific digits.

Sequential (serial) coding

Assigns numbers to objects in chronological sequence. Provides limited flexibility and tells nothing about the object's attributes. Limitations with adding and deleting exist.

Relationships

Associations between entities. Entities must be logically linked to show relationships.

Key Attribute

Attribute whose value is unique for every entity that will ever appear in the database. Most meaningful way of identifying each entity. Becomes the primary key.

Composite Attribute

Attributes that consist of multiple sub-attributes (e.g., City and State for Address attribute).

An enterprise system can support the functioning of an organization's processes by enhancing all of the following:

Automation of business processes Systems integration Communication with the organization

Timeliness

Available to a decision maker before it loses relevance.

In a data flow diagram (DFD), a(n) ______ symbol depicts an entity or a process within which incoming data flows are transformed into outgoing data flows.

Bubble

A data flow diagram consists of which of the following symbols?

Bubble Symbol Data Store Symbol Data Flow Symbol

All of the following is true of databases:

Business event data are copied periodically into a separate database (a data warehouse). A collection of data within an interconnected series of files is a centralized database A collection of data within one or more files is a database NOT: Decentralized data is when the system must store and maintain multiple versions of the same data in different files

Business processes include:

Business operations, events processing, management decision making

Which of the following is NOT one of the main ways users can access information stored in a DBMS(database managements systems)?

By downloading the information onto a separate data drive

Relation

Collection of data representing multiple occurrences of a resource, event, or agent. Correspond to entities in the E-R and REA models

All of the following are true about add-on modules to an ERP system except that they:

Can be used to enhance the interface with business partners but not with customers

Data redundancy:

Can cause conditions which violate data integrity Is a problem that can be solved when using the centralized database approach Is a major issue with the applications approach

Value-added networks (VANs):

Can perform translation services Can perform communication services Operates as a hub by linking many business partners together

Relevance

Capable of making a difference in a decision-making situation by reducing uncertainty or increasing knowledge.

Check digit

Code that includes an extra digit that can be used to check the accuracy of the code.

10 elements are included in the study of AIS:

Communications, accounting and auditing principles Technology, databases, reporting, control Business operations, events processing, management decision making, systems development and operation

What are the limitations of the centralized database approach to business information systems?

Companies that have adopted the centralized database approach have found it necessary to create a database administrator function

B2B systems are limited to:

Companies that sell predominantly over the Internet Retail stores which rely heavily on B2B Companies such as Walmart

Value-added networks (VANs) are used to simplify EDI between two or more companies by:

Connecting directly to a VAN service Using a VAN for translation services Using a VAN for communication services

Lack of systems integration may result in the same data having to be put in multiple times into the systems. This can weaken which of the following data characteristics?

Consistency, accuracy and completeness

What factors distinguish DSS from EIS?

DSSs can provide "recommendations", but EISs do not usually do so

Accuracy

Correspondence or agreement between the information and the actual events or objects it represents.

Which software builds and maintains an organization's customer-related database?

Customer relationship management (CRM) software

Which software and allows a customer to inquire, perform a task, or troubleshoot problems without the help of the organization's employees?

Customer self-service (CSS) software

A(n) ______ ______ depicts a system's components; the data flows among the components; and the sources, destinations, and storage of data.

Data Flow DFD

Which if the following is a graphical representation of systems documentation for a process?

Data flow diagram

A major difference between the centralized database approach and the applications approach is decoupling, also known as _______ ______:

Data independence

All of the following are benefits of a centralized database approach:

Data integrity Data independence Ease of data maintenance

Factors that distinguish data from information are all of the following:

Data must be transformed into information Information is data Data are facts or figures in raw form

Information is all of the following:

Data presented in a form that is useful in a decision-making activity Reduces uncertainty and increases knowledge about a particular area of concern Has value to the decision maker

In a data flow diagram (DFD), a(n) ______ symbol represents a place where data are stored.

Data store

______ ______ is the process of making choices.

Decision making

Block Coding

Dedicates groups of numbers to particular object characteristics. Numbers within each block are generally assigned sequentially. Leads to some of the same adding and deleting limitations as sequential coding.

Completeness

Degree to which information includes data about every relevant object or event necessary to make a decision and includes that information only once.

What roles can an accountant assume/fill in relation to the AIS?

Designer, Auditor, User

The first step in E-R modeling is to:

Determine users' requirements for the database

In entity-relationship modeling the designer:

Draws a diagram of the relational model Identifies the entities Identifies how the things are related to each other

______ ______ is the use of electronic networks (including the Internet) to enable business processes between individuals and organizations.

E-Business

Which of the following is true about enterprise application integration (EAI)?

EAI is an approach that combines processes, software, standards, and hardware to link two or more systems together.

Methods of conducting E-business sometimes do not include:

EDM (electronic document management) but do include: E-mail, Electronic data interchange (EDI) and internet commerce

______ ______ are software packages that can be used to support enterprise systems.

ERP Systems (Enterprise Resource Planning Systems)

The difference between system and subsystem is:

Each part of a system is known as a subsystem

What are the main advantages of using a centralized database approach when designing and implementing business information systems?

Ease of data maintenance Eliminating data redundancy Reduced labor and storage costs

Comparability

Enables users to identify similarities and differences between two pieces of information.

Understandability

Enables users to perceive significance and permits application by the user in a decision-making situation.

E-business is all of the following:

Enabling organizations to become part of new value chains A paper-trail Electronic business events (NOT: E-Commerce)

______ ______ integrate the business processes and information from all of an organization's functional areas.

Enterprise Systems

Themes of this textbook

Enterprise Systems E-Business Controls

The ________ _______ is the central repository for all the data related to the enterprise's business activities and resources:

Enterprise database

Why are some entities found in a narrative included in the context diagram as external entities, whereas others are included as internal entities?

Entities that do not perform any information processing activities are external entities; the remaining entities are internal

Where are error and exception routines shown on systems flowcharts?

Errors and Exceptions are noted on the flowchart with an annotation

Third-party modules are connected to ERP systems using middleware (software for connecting two or more software applications or modules)

Ex) Application programming interface (API) is provided by the application developer. Enterprise application integration (EAI) combines processes, software, standards, and hardware to link two or more systems together, allowing them to act as one.

To improve decision making and operations companies combine their data resources with:

Executive information systems Decision-support systems Group decision systems

The information system is important to the success of the organization by:

Facilitating operations processes and providing information for the organization's management

If information has integrity, then it is:

Free of error and complete

Steps in the order-to-cash process do not include:

Goods receipt

What are the guidelines for grouping logical activities for a logical DFD?

Group activities if they occur in the same place and at the same time Group activities if they occur at the same time but at different places Group activities that seem to be logically related

Risks of Internet commerce include all of the following:

Hackers attempting to access sensitive information such as customer lists Illegal access to customer credit card information Denial-of-service attacks NOT: Organizational change

If information has confidentiality, then it is:

Has restricted access

Verifiability

High degree of consensus about the information among independent measurers using the same measurement methods.

Benefits of EDM (electronic document management) systems include all of the following:

Improved staff productivity Superior customer service Enhanced management of operational workflow

Centralized databases have:

Improved the efficiency of processing business event data

Predictive or feedback value:

Improves the decision maker's capacity to predict, confirm, or correct earlier expectations.

What are the differences among a context diagram, a logical DFD, and a physical DFD?

In a logical DFD (versus a physical or context DFD) we can concentrate on the activities that a system performs. In a logical DFD, (versus a physical or context DFD) bubbles can be broken down into more detail.

Mnemonic coding:

Includes letters as some or all of the code which is done to help humans remember them.

The Sales and Distribution (SD) module in SAP:

Includes recording customer orders, shipping goods to the customer, and billing customers

What are information processing activities?

Information processing activities retrieve data from storage, transform data, or file data.

The following are key features/characteristics of an enterprise resource planning (ERP) system :

Integration of the major business processes Automation or computerization of business process **Consists of modules**

The following are key features/characteristics of an enterprise system:

Integration of the major business processes Automation or computerization of business processes

Qualities of information include all of the following

Integrity, Relevance, Understandability

What are the three steps in decision making?

Intelligence, Design, Choice

______ ______ is a process designed to provide confidence that the organization is achieving its objectives.

Internal Control

A knowledge base:

Is a collection of a company's files and documents Generally contains proprietary information Is analogous (comparable/similar) to a database

Web Services:

Is a software application

WebTrust:

Is displayed by a seal on the client's webpage. Was developed by accountants Is designed to provide assurance

Data warehousing:

Is the use of information systems facilities Is typically created by copying data periodically from the transaction databases Provides users with easy access to large quantities of varied data

A primary key:

Is used for linking database tables together

What are the most important limitations of the applications approach to business information system design?

It is more likely to lead to some data being out of date than when using the centralized database approach It can potentially lead to data integrity problems It can lead to data redundancy

Which of the following is an advantage of eliminating redundant data?

It usually leads to reduced labor and storage costs

Attribute

Item of data that characterizes an entity or relationship. For example, Name, Address, Contact_Person for a CLIENT entity.

The basic subprocesses completed in processing business event data using OLRT processing do NOT include:

Journalize the business event

The basic subprocesses completed in processing business event data using batch processing do NOT include:

Journalize the business event

Which of the following are activities associated with a manual accounting process?

Journalize the business event

Why have knowledge management systems become important?

Knowledge management systems help capture, store, organize, present, distribute, and control access to the knowledge base

On DFD exception routines:

Left on another page of the flowchart

Which of the following cannot be the maximum cardinalities of two relational tables?

M:0

A(n) ______ ______shows the flows of data into and out of the processes and data stores.

Logical DFD

What are three logical components of a business process?

Management, operations and information processes

The difference between business event data and master data is:

Master data is relatively permanent data

Which of the following SAP modules is used to automate the purchase-to-pay process?

Materials Management (MM)

Amazon.com's e-business model is based on:

Online shopping carts Secure transaction software Sophisticated data-analysis programs

How do horizontal and vertical information flows differ?

Operations and information flows are both horizontal and vertical

______ ______ require information that is an aggregate of data related to several business events

Operations managers

The ______ ______is a system consisting of the people, equipment, organization, policies, and procedures whose objective is to accomplish the work of the organization.

Operations process

Hierarchical coding:

Orders items in descending order where each successive rank order is a subset of the rank above it. Specific meaning is attached to particular positions.

Costs of Internet commerce include all the following:

Organizational change to a completely different way of doing business Staffing and training employees to work in a technology-driven environment Buying/leasing equipment and maintaining connection to the Internet NOT: Mailroom and other document preparation and handling costs are eliminated

A(n) ______ ______ shows the system's internal and external entities and the flows of data into and out of these entities.

Physical DFD

A(n) ______ ______ specify where, how, and by whom a system's activities are accomplished.

Physical DFD

Service-oriented architecture is:

Plug-and-play components

SQL

Powerful database language that can be used to define database systems, query the database for information, generate reports from the database, and access databases from within programs.

How are the applications approach and the centralized database approach to business event processing different?

Powerful features that protect the database from unauthorized users compared to the applications approach Decreased need for continuous data protection compared to the applications approach Ease of data maintenance compared to the applications approach

Two types of activities in the value chain are known as:

Primary and supporting

For WebTrust certification a Web site must meet which of the following principles?

Privacy Availability Processing integrity

Which software manages product data during a product's life?

Product life-cycle management (PLM) software

Which of the following is a primary activity in the value chain?

Production

Network providers:

Provide a link to the Internet

Internet assurance services:

Provide limited assurance to users of the vendor's Web site that the site is in fact reliable and event data security is reasonable

An enterprise system:

Provides a central information resource for the organization Makes possible the coordinated operation of the organization's functions Integrates and automates business process functionality and information in an organization

Business Intelligence (BI)

Provides analytical and reporting capability to enable the analysis of data warehouses and to help managers make the best possible decisions for their companies. BI systems are specifically designed to support managers in making tactical and strategic decisions. BI is often installed into an existing ERP as an additional module.

How has technology supported Amazon.com's growth?

Providing Web Services Provide services to competitors Provides "almost-in-time" inventory

E-mail can be adapted to a more structured form to aid in capturing business event data by:

Providing a link to an electronic order form that removes the need for an e-mail message containing an order

Which of the following is a step in the purchase-to-pay process?

Purchase order processing

The use of online transaction entry (OLTE) can increase efficiency by:

Reduces the redundancies in periodic mode processing

E-Business changes organizational processes through:

Reengineering its business processes Participating in new value chains Enabling more efficient operations

Steps in the purchase-to-pay process include:

Requirements determination Payment processing Purchase order processing

Lack of information systems integration when receiving a customer order over the phone can cause all of the following problems :

Sales person may not be able to determine the items current price. Sales person may have to put the customer on hold while checking with another department. Sales person may not be able to determine a customer's creditworthiness. (BUT CAN: determine whether or not an item is available)

Which of the following is NOT one of the five primary schemes for coding data?

Schema

Coding schemes on relational databases include:

Significant digit coding, mnemonic coding, hierarchical coding

Organizations use a database management system to:

Simplify the tasks of creating, accessing, and managing a centralized database Provide data useful to managers Coordinate the activities of functional areas

All of the following are advantages of enterprise systems:

Single database Standardization of business processes

Referential integrity

Specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

Participation constraint

Specifies the degree of minimum participation of one entity in a relationship with the other entity. Constraint is either 1 or 0. Provides more information but is used less frequently than the cardinality constraint.

In a data flow diagram (DFD), a(n) ______ symbol portrays a source or a destination of data outside the system.

Square

______is the degree of repetition and routine in the decision.

Structure

What is structure as it relates to decisions?

Structure is the degree of repetition and routine in the decision

Which software manages the interactions with the organizations that supply the goods and services to an enterprise?

Supplier relationship management (SRM) software

One of the most important functions provided by an enterprise system is:

The coordination of value activities in the value chain

How will systems documentation differ between business processes that employ an enterprise system and those that do not?

The data stores would be replaced by one data store labeled "Enterprise database" The context diagram and the logical DFD would not change There might be replacement of paper reports

What is data?

The measurements of objects and events, Can be transformed into information, Facts or figures in raw form

Where are error and exception routines shown on logical DFDs?

They are shown below the level 0 DFD with reject stubs that indicate that exceptional processing must be performed

What advantages do intelligent agents have in the operation of a decision support system?

They can perform time-consuming tasks They can collect specific information from the Internet or large data warehouses They can identify factors that should be considered when using a system for decision making

Which of the following is true of value chains?

They consist of activities performed by the organization to transform inputs into outputs valued by the customer.

Two major functions of an information system are:

This information can supplement accounting information and can assist managers in their decision making

It is important to capture the who, what, where, and when in describing business events because:

This information can supplement accounting information and can assist managers in their decision making.

Cardinality is the degree to which each entity participates in a relationship.

Three relationship types are: 1:N (one-to-many) M:N (many-to-many) 1:1 (one-to-one):

On a physical DFD, reading computer data stores and writing to computer data stores must go:

Through a computer bubble

Which questions do accountants address when designing AIS?

What will be recorded? What controls are necessary? What reports will be produced?

What is a partial dependency?

When an attribute is dependent on a portion of the primary key, not on the entire key

Data captured as business events unfold should be related to the four Ws, which are:

Who, What, Where, When

Best of Breed approach

combines modules from various vendors to create an information system that better meets an organization's needs than a standard ERP system.

What is an entity-relationship model (E-R model)?

diagram of the relational model

REA (Resources-Event-Agents)

helps database designers define a complete set of entities and attributes.

Object-relational databases

include a relational DBMS framework with the capability to store complex data types.

A table is in ___ if it is in 1NF and has no partial dependencies. That is, no non-key attributes that are dependent on only a portion of the primary key.

second normal form (2NF)

In a DFD the customer would be represented by:

square

A table is in ___ if it is in 2NF and has no transitive dependencies.

third normal form (3NF)

Functional dependencies cause several problems called

update anomalies (Updates may require: changes to multiple rows. Data may be inconsistent. Additions and deletions are problematic.)


संबंधित स्टडी सेट्स

4th Grade Social Studies: States of the Southeast Region

View Set

chapter 11: stockholders' equity

View Set

N204 Midterm Exam Prep Questions

View Set

Chapter 36 - Coronary Artery Disease (Questions)

View Set