Chapter 5 HW

Centralized databases have

Improved efficiency of processing business event data

Which statement is true regarding knowledge management?

The primary enabler is information technology

Which of the following cannot be the maximum cardinalities of two relational tables? M:N 1:1 M:0 N:1

M:0

Describe the basic differences between ES and NN

NN's develop their own knowledge base and continue to learn

Coding Schemes on Relational Databases DO NOT include

Normalized coding

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

Dependencies cause several problems called

Update Anomolies

Knowledge Base

Analogous to Database A collection of a company's files and documents Generally contains proprietary information

Organizations use a database management system to

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

What factors distinguish DSS from EIS?

DSS's can provide "recommendations", but EIS's do not usually do so

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

Data Independence

Benefits of a centralized database approach

Data Independence Data Integrity Ease of data maintenance

The first step in E-R modeling is to

Determine user's 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

Intelligent Agents

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

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

Group Decision Systems Executive Information Systems Decision-Support Systems

Coding Schemes on Relational Databases include

Hierarchical coding Significant Digit coding Mnemonic coding

When does functional dependence exist?

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

Why have knowledge management systems become more important?

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

Advantages 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

What is a Partial Dependency?

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