Functional Dependency and Other Related Dependencies

Functional Dependency and Other Related Dependencies

Robert A. Schultz (Woodbury University, USA)
DOI: 10.4018/978-1-59140-553-5.ch217
OnDemand PDF Download:
$37.50

Abstract

The invention and rise of the relational database starting in the 1960s was accompanied by the remarkable development of canonical design techniques, making it possible to avoid many database designs with unintended bad consequences (Codd, 1970, 1971). These techniques, called “normal forms,” prevent the occurrence of what are called “anomalies.” If a database design contains an anomaly, the implemented database will behave in unintended ways. If there is a deletion anomaly, data will unexpectedly disappear; an insertion anomaly will produce difficulties in adding data; and a modification anomaly will result in extra and unexpected operations in the course of changing data in the database (Kroenke, 2002).

Complete Chapter List

Search this Book:
Reset