AIS - Exam 1 (Chapters 1-6)

Centralized databases have:

Improved the efficiency of processing business event data

Which statement is true regarding knowledge management?

The primary enabler is information technology

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

Through a computer bubble

When does functional dependence exist?

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

Describe the basic differences between ES and NN

NNs develop their own knowledge base and continue to learn

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

Systems Flowchart

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

The activities that a system performs

The systems flowchart combines which aspects?

The physical and logical

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

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

a. Actions that merely send or receive data rather than transform data b. Activities performed by the operations process c. All of these choices d. Actions performed in other-than-normal situations C.

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

a. All of these choices b. Group decision systems c. Decision-support systems d. Executive information systems A.

In entity-relationship modeling the designer:

a. All of these choices b. Identifies how the things are related to each other c. Identifies the entities d. Draws a diagram of the relational model A.

Organizations use a database management system to:

a. Coordinate the activities of functional areas b. Simplify the tasks of creating, accessing, and managing a centralized database c. All of these choices d. Provide data useful to managers C.

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

a. Data flow symbol b. Data store symbol c. All of these choices d. Bubble symbol C.

A knowledge base:

a. Generally contains proprietary information b. Is analogous to a database c. All of these choices d. Is a collection of a company's files and documents

Intelligent agents:

a. Perform their tasks without further direction from the user b. Are frequently used by search engines c. Are sometimes called "bots" d. All of these choices

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

a. They can perform time-consuming tasks b. They can identify factors that should be considered when using a system for decision making c. They can collect specific information from the Internet or large data warehouses d. All of these choices are advantages D.

Relationships are

associations between entities

Coding schemes on relational databases do not include:

normalized coding

Which of the following is not one of the three components of the SQL SELECT statement?

A PULL clause that sets the conditions for extracting the desired data

A tuple is not:

A collection of data representing multiple occurrences of a resource, event, or agent.

In a DFD the customer would be represented by:

A square

Which of the following is true about business intelligence (BI)?

BI uses simplified business models to help managers make better decisions

What factors distinguish DSS from EIS?

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

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

Data Flow DFD

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 except:

Data Redundancy

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

Data flow diagram

The first step in E-R modeling is to:

Determine users' requirements for the database

Where are error and exception routines shown on systems flowcharts?

Errors and Exceptions are noted on the flowchart with an annotation

Which of the following is true about an entity in a relational database?

Is represented as a table

A key attribute

Is the attribute whose value is unique

Which of the following is false about attributes?

It is one specific thing of the type defined by the entity

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

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

Which of the following is not one the steps in the three step strategy for effectively identifying the relationships that should be included in a database model?

Specify the degree of minimum participation of one entity in the relationship with the other entity

Which of the following is true about recursive relationships?

They occur between two different instances of an entity

What is a partial dependency?

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

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.

a bubble

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

square

Dependencies cause several problems, called _______ _______:

update anomalies