Ch 6 Questions Flashcards
What are the issues associated with a traditional file system?
1) Data Redundancy
2) Data Inconsistency
3) Program-Data Dependence
4) Lack of Flexibility
5) Poor Security
6) Lack of Data Sharing and Availability
What is data redundancy?
The same data is stored in more than one place or location.
What is data inconsitency?
The same attribute has different values.
What is program-data dependence?
The coupling of data stored in files and the specific programs required to update and maintain those files.
Changes in its program requires changes to the data.
What is poor security?
Management may have no way of knowing who is accessing or even making changes to the organization’s data.
What is lack of data sharing and availability?
Pieces of information are in different files in different parts of the organization, making it virtually impossible for information to be shared or accessed in a timely manner.
What are the benefits of a database management system (DBMS)?
Reduces data redundancy and inconsistency by minimizing isolated files in which the same data are repeated.
Access and availability of information will be increased, and program development and maintenance costs reduced because users perform queries of the database.
Data sharing throughout the organization is easier because the data are presented to users as being in a single location rather than fragmented in many different systems and files.
What is a data warehouse?
A database that stores current and historical data of potential interest to decision makers throughout the company.
The data warehouse makes the data available for anyone to access as needed, but the data cannot be altered.
