File Processing System: Disadvantages and Limitations Quiz and Flashcards

Study Flashcards Play Quiz

Questions and Answers

What is one of the advantages of the database approach?

Improved data consistency

What is a disadvantage of the file processing system?

Need for explicit backup and recovery

What is an example of a data modeling and design tool?

Automated tool

What is one of the costs of the database approach?

Conversion costs Signup and view all the answers

What is an example of a component of the database environment?

Application Programs Signup and view all the answers

What is a benefit of program-data independence?

Easier modification of application programs Signup and view all the answers

What is responsible for managing the database?

Database Management System (DBMS) Signup and view all the answers

What is included in the database environment?

Data modeling and design tools, repository, DBMS, database, application programs, user interface, data/database administrators, and system developers Signup and view all the answers

What is a major disadvantage of file processing systems?

Program-data dependence which requires metadata maintenance Signup and view all the answers

What is an advantage of the database approach?

Centralized control of data Signup and view all the answers

What is an entity in a data model?

A noun form describing a person, place, object, event, or concept Signup and view all the answers

What is a benefit of program-data independence?

Less program maintenance Signup and view all the answers

What type of relationships are common between entities in a data model?

One-to-many or many-to-many Signup and view all the answers

What is a disadvantage of file processing systems in terms of development?

Programmers must design their own file formats Signup and view all the answers

What is the purpose of a data model?

To capture the nature and relationship of data Signup and view all the answers

What is the primary function of an Enterprise System?

To provide a backbone for an organization Signup and view all the answers

What is a characteristic of relational databases?

Involving tables to represent entities Signup and view all the answers

What type of database is commonly used in Enterprise Systems?

Relational Database Signup and view all the answers

What is a characteristic of a Data Lake?

It does not involve relational databases Signup and view all the answers

What is the primary purpose of a Data Warehouse?

To integrate data from multiple data sources Signup and view all the answers

What is the name of the fictional furniture company used as a case study throughout the book?

Pine Valley Furniture Signup and view all the answers

What is the topic of Chapter 1 in the context of Pine Valley Furniture?

Database Evolution at Pine Valley Furniture Company Signup and view all the answers

What is the advantage of using a Data Warehouse?

It integrates data from multiple data sources Signup and view all the answers

What is the purpose of Figure 1-13 in the context of the book?

To show an example of an Executive Dashboard Signup and view all the answers

Study Notes

Disadvantages of File Processing

Programs maintain metadata for each file they use, leading to program-data dependence
Duplication of data occurs, with different systems/programs having separate copies of the same data
There is limited data sharing, with no centralized control of data
Development times are lengthy, as programmers must design their own file formats
Program maintenance is excessive, with 80% of information systems budget spent on it

The Database Approach

Data models capture the nature and relationship of data
Entities are composed of attributes and can be represented graphically
Relationships between entities can be one-to-many (1: N), many-to-many (M : N), or one-to-one (1:1)
Database technology involves tables (relations) representing entities and primary/foreign keys representing relationships

Advantages of the Database Approach

Program-data independence is achieved
Planned data redundancy improves data consistency
Data sharing is improved, reducing data duplication
Application development productivity increases
Standards are enforced, improving data quality
Data accessibility and responsiveness are improved
Program maintenance is reduced
Decision support is improved

Costs and Risks of the Database Approach

New, specialized personnel may be needed
Installation and management cost and complexity may arise
Conversion costs can be high
Backup and recovery procedures must be implemented
Organizational conflict may occur

Components of the Database Environment

Data modeling and design tools automate database and application design
Repository stores metadata centrally
Database Management System (DBMS) manages the database
Database stores the data
Application programs use the data
User Interface provides a user-friendly interface
Data/Database Administrators maintain the database
System Developers design databases and software
End Users utilize the applications and databases

Types of Enterprise Applications

Enterprise Systems involve relational databases and are the backbone of an organization
Data Warehouses integrate data from multiple sources and maintain historical data
Data Lakes are large, integrated repositories that do not follow a predefined schema

Pine Valley Furniture Company

A fictional furniture company used as a case study throughout the book
Topics covered include database evolution, project planning, analyzing database requirements, designing the database, using the database, administering the database, and the future of databases at PVF