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
