Chapter 9, Problem 1Q

Program Plan Intro

What are the problems in Mario’s system and why same problems did not occur in Danica’s system?

Explanation of Solution

Given Information: There are two Auto shops similar to each other but with different information systems. Mario’s Auto shop used two file-oriented system and Danica’s Auto shop used database management system.

Explanation:

Mario’s system is divided into two file processing systems in order to manage the business. These two systems required two different files for data storage without having any link to each other. These two separate storages make that data inconsistent. That was the problem with Mario’s system. For example, there are three data items associated with Mario’s system named as Mechanic id, Name and Pay rate. These three items are stored in both the files of system which will cause redundancy of data and hence will impact the quality of data and integrity.

The same problem did not occur in Danica’s system because it used a database management system with two tables linked to each other. So, it would not cause any duplicity of data items and hence would not impact the quality of the data.