The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Functional Dependency and Other Related Dependencies
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
Christine Kosmopoulos.
© 2022.
22 pages.
|
Melkamu Beyene, Solomon Mekonnen Tekle, Daniel Gelaw Alemneh.
© 2022.
21 pages.
|
Rajkumari Sofia Devi, Ch. Ibohal Singh.
© 2022.
21 pages.
|
Ida Fajar Priyanto.
© 2022.
16 pages.
|
Murtala Ismail Adakawa.
© 2022.
27 pages.
|
Shimelis Getu Assefa.
© 2022.
17 pages.
|
Angela Y. Ford, Daniel Gelaw Alemneh.
© 2022.
22 pages.
|
|
|