What were the benefits of relational database systems versus traditional file-oriented data structures?

What will be an ideal response?


Relational database systems eliminated the shortcomings of traditional file-oriented structures including (1) data redundancy—an employee’s name and address could be stored in many different files; (2) poor data control—if you had access to the file, you had access to all of the data in the file, which may not be desirable because you may want to restrict the data viewed by a particular user; (3) inadequate data manipulation capabilities—it was very difficult to combine the data across files and to easily update and to add new data; and (4) excessive programming effort—any change in the data required extensive changes in the programming that accessed the data. Perhaps, the most significant difference between a file-based system and a relational database system is that data are easily shared.

Business

You might also like to view...

Computer Integrated Manufacturing focuses on reducing the complexity of the physical manufacturing layout of the shop floor

Indicate whether the statement is true or false

Business

Shifting from one production process to another ______.

A. is difficult B. is inexpensive C. can be done quickly D. can be done without human intervention

Business

When a successful brand such as Frito-Lay develops a new product, it will always succeed.

Answer the following statement true (T) or false (F)

Business

In order to enter the Spanish market, a Moroccan firm establishes a store that is entirely owned by the Moroccan firm. This is an example of a(n) ________

A) strategic alliance B) wholly owned subsidiary C) exporting agreement D) joint venture E) contract manufacturing arrangement

Business