BuyFindarrow_forward

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
ISBN: 9781285196145

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
ISBN: 9781285196145
Textbook Problem

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.9. (The file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy is the likely occurrence of data inconsistencies—two different initials have been entered for the teacher named Maria Cordoza.)

FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9–10

images

Program Plan Intro

Data redundancy:

  • Data redundancy is the presence of repeated data in the storage device. It consists of duplicate data that is additional to the actual data.
  • In this case, the data related to a folder can be seen in other folders. For example, file related to science folder can be seen in mathematics or social.
Program Explanation

Data redundancy found in the given file structure:

  • In the given file structure, the teacher named Maria occurs three times which means the records related to the teacher name will repeat...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Solutions

Find more solutions based on key concepts

Show solutions add

What is a virtual machine?

Fundamentals of Information Systems

What is a table, and what role does it play in the relational model?

Database Systems: Design, Implementation, & Management

What two functions can the lathe tailstock perform?

Precision Machining Technology (MindTap Course List)

What part of the AC generator is the rotating magnetic field? Stator Rotor Brushes Poles

Automotive Technology: A Systems Approach (MindTap Course List)

Which represents more power, kilowatt, or horsepower?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Should the IT director report to the company president, or somewhere else? Does it matter?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Check the adequacy of the bolts. The given load is a service load. a. Use LRFD. b. Use ASD.

Steel Design (Activate Learning with these NEW titles from Engineering!)