Chapter 5- Database Management Systems(Correctly
solved)
Data Warehouse correct answers larger organizations copying data into a separate database
Data Mining correct answers allows managers to analyze important data using analyzing tools
Two Approaches to Business Event Processing correct answers - Centralized database approach
- Applications approach
Centralized Database Approach correct answers - facts about events are stored in relational
database tables instead of separate files
- eliminates data redundancy and improves data integrity
Applications Approach correct answers - traditional view that concentrates on the process being
performed
- data plays a secondary role to the programs
- each application collects and manages its own data files
Data Redundancy correct answers - consequence of the applications approach
- data stored in multiple locations, can cause inconsistencies
Data Redundancy Effects correct answers - increased labor and storage cost because data must
be entered into the server more than once
- data can be inconsistent when information is updated in one file and not in the other files
Centralized Data (Data Independence) correct answers - to decouple the data from the system
applications
- doesn't rely on a application to be able to work
Centralized Data (Three Tier Architecture) correct answers - often used by systems that use
decoupling
- User or presentation
- application or business ("middleware"
- data or database
Centralized Database overcoming Applications approach limitations correct answers - eliminates
data redundancy
- ease of maintenance since data is only stored once, changes to data are made easily
- reduced labor and storage cost
- data integrity- consistency in the data without errors
- data independence
- privacy- since data is all in one place
solved)
Data Warehouse correct answers larger organizations copying data into a separate database
Data Mining correct answers allows managers to analyze important data using analyzing tools
Two Approaches to Business Event Processing correct answers - Centralized database approach
- Applications approach
Centralized Database Approach correct answers - facts about events are stored in relational
database tables instead of separate files
- eliminates data redundancy and improves data integrity
Applications Approach correct answers - traditional view that concentrates on the process being
performed
- data plays a secondary role to the programs
- each application collects and manages its own data files
Data Redundancy correct answers - consequence of the applications approach
- data stored in multiple locations, can cause inconsistencies
Data Redundancy Effects correct answers - increased labor and storage cost because data must
be entered into the server more than once
- data can be inconsistent when information is updated in one file and not in the other files
Centralized Data (Data Independence) correct answers - to decouple the data from the system
applications
- doesn't rely on a application to be able to work
Centralized Data (Three Tier Architecture) correct answers - often used by systems that use
decoupling
- User or presentation
- application or business ("middleware"
- data or database
Centralized Database overcoming Applications approach limitations correct answers - eliminates
data redundancy
- ease of maintenance since data is only stored once, changes to data are made easily
- reduced labor and storage cost
- data integrity- consistency in the data without errors
- data independence
- privacy- since data is all in one place
