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