1 / 2

Understanding Redundancy and Anomalies in Database Normalization

This instructional content by Assistant Professor Lipyeow Lim from the University of Hawaii at Manoa delves into the issues associated with data redundancy in databases. Using hourly employee wage data as a case study, the material highlights examples of functional dependencies, redundant storage, and the potential for update, insertion, and deletion anomalies. By illustrating how these anomalies affect data integrity and management, the text aims to provide a foundational understanding of the importance of normalization and proper database design in the field of Information and Computer Science.

claire
Télécharger la présentation

Understanding Redundancy and Anomalies in Database Normalization

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ICS 321 Fall 2009Schema Refinement & Normal Forms Asst. Prof. Lipyeow Lim Information & Computer Science Department University of Hawaii at Manoa Lipyeow Lim -- University of Hawaii at Manoa

  2. The Problem with Redundancy Hourly_Emps • Suppose hourly wages are determined by rating ( this is an eg of functional dependency) • Redundant storage : (8,10) stored multiple times • Update anomaly : change hourly wages in row 1 • Insertion anomaly : requires knowing hourly wages for the rating • Deletion anomaly : deleting all (8,10) loses info Lipyeow Lim -- University of Hawaii at Manoa

More Related