IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Functional Dependency and Other Related Dependencies

Functional Dependency and Other Related Dependencies
View Sample PDF
Author(s): Robert A. Schultz (Woodbury University, USA)
Copyright: 2005
Pages: 5
Source title: Encyclopedia of Information Science and Technology, First Edition
Source Author(s)/Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59140-553-5.ch217

Purchase

View Functional Dependency and Other Related Dependencies on the publisher's website for pricing and purchasing information.

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).

Related Content

Adeyinka Tella, Oluwakemi Titilola Olaniyi, Aderinola Ololade Dunmade. © 2021. 24 pages.
Md. Maidul Islam. © 2021. 17 pages.
Peterson Dewah. © 2021. 23 pages.
Lungile Precious Luthuli, Thobekile K. Buthelezi. © 2021. 14 pages.
Delight Promise Udochukwu, Chidimma Oraekwe. © 2021. 13 pages.
Julie Moloi. © 2021. 18 pages.
Mandisa Msomi, Lungile Preciouse Luthuli, Trywell Kalusopa. © 2021. 17 pages.
Body Bottom