Chapter 5
Centralized databases have
Improve the efficiency of processing business event a
A knowledge base
Is a collection of a companies files and documents, generally contains proprietary information, is analogous to a database
Which of the following cannot be the maximum cardinality of two relational tables
M:0
Describe the basic differences between ES and NN
NNs develop their own knowledge base and continue to learn
Coding schemes on relational databases do not include
Normalized coding
Which statement is true regarding knowledge management
The primary enabler is information technology
Explain when I database designer might use a relationship table in constructing a relational database
To link two relational tables in a M:N relationship
Dependencies call several problems called
Update anomalies
What are the main advantages of using a centralized database approach when designing and implementing business information systems
Where does labor and storage cost, it's about a maintenance, elimination of data redundancy
Which of the following statements is true concerning normalization
2NF does not contain partial dependencies
What is an entity relationship model
A diagram of the relational model
Intelligent agents
Are frequently used by search engines, perform their tasks without further direction from the user, are sometimes called bots
Which of the following is not one of the main Waze users can access information stored in a database management system
By downloading the information onto a separate add a drive
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
What factors distinguish DSS from EIS
DSS can provide recommendations but AIS do not usually do so
A major difference between the centralize database approach in the applications approach is decoupling also known as
Data independence
All of the following are benefits of a centralized database approach except
Data redundancy
All of the following is true of databases except
Decentralized data is when the system a store and maintain multiple versions of the same data in different files
The first step in ER modeling is two
Determine users requirements for the database
Which of the following is not one of the four main elements in a relational database
Flow charts
To improve decision making an operations companies combine their data resources with
Group decision systems, executive information systems, decision support systems
An entity relationship modeling the designer
Identifies the entities, draws a diagram of the relational model, identifies how the things are related to each other
When does functional dependence exist
If I value for the first attribute determines a single value for the second attribute
How are the applications approach and centralized database approach to business event processing different
Is a data maintenance compared to the applications approach, decreased need for continuous data protection compared to the applications approach, powerful features that protect the database from unauthorized users compared to the applications approach
Data redundancy
Is a major issue with the applications approach, can cause conditions with violate data integrity, is a problem that can be solved when using the centralized database approach
Data warehousing
Is typically created by copying data periodically from the transaction databases, provides users with easy access to large quantities of very data, is the use of information systems facilities
A primary key
Is used for a linking database tables together
What are the most important limitations of the applications approach to business information system design
It can lead to data redundancy, it is more likely to lead to some data being out of date then when using these centralized database approach, it could potentially lead to a data integrity problem
Which of the following is a advantage of eliminating redundant data
It usually leads to reduce labor and storage costs
Why have knowledge management systems become important
Knowledge management systems help capture, store, organized, present, distribute, and control access to the knowledge base
Organizations use a database management system to
Provide data useful to managers, simplify the task of creating accessing and managing a centralized database, coordinating the activities of functional areas
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 warehouse is, 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 the entire key
Which of the following is not one of the Five primary schemes for coding data
schema
