A simple guide to five normal forms in relational database theory

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

A simple guide to five normal forms in relational database theory

Full text

Pdf (603 KB)

Source

Communications of the ACM archive
Volume 26 , Issue 2 (February 1983) table of contents

Pages: 120 - 125

Year of Publication: 1983

ISSN:0001-0782

Author

William Kent

International Business Machines Corp., San Jose, CA

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 47, Downloads (12 Months): 391, Citation Count: 17

Additional Information:

abstract references cited by index terms collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/358024.358054 What is a DOI?

ABSTRACT

The concepts behind the five principal normal forms in relational database theory are presented in simple terms.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
	2	Codd, E.F. Normalized data base structure: A brief tutorial. ACM SIG- FIDET Workshop on Data Description, Access, and Control. Nov. 11-12, 1971, San Diego, California. E.F. Codd and A.L Dean (Eds.)
	3	Codd, E.F. Further normalization of the data base relational model. R. Rustin (Ed.), Data Base Systems (Courant Computer Science Symposia 6). Prentice-Hall, Englewood Cliffs, NJ, 1972. Also IBM Research Report R J909.
	4	C. J. Date, An introduction to database systems: vol. I (4th ed.), Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1986
	5	Ronald Fagin, Multivalued dependencies and a new normal form for relational databases, ACM Transactions on Database Systems (TODS), v.2 n.3, p.262-278, Sept. 1977 [doi>10.1145/320557.320571]
	6	Ronald Fagin, Normal forms and relational database operators, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts [doi>10.1145/582095.582120]
	7	Kent, W. A primer of normal forms. IBM Technical Report TR02.608, Dec. 1973.
	8	Tok-Wang Ling , Frank W. Tompa , Tiko Kameda, An improved third normal form for relational databases, ACM Transactions on Database Systems (TODS), v.6 n.2, p.329-346, June 1981 [doi>10.1145/319566.319583]

CITED BY 18

	James V. Hansen , William F. Messier, A relational approach to decision support for EDP auditing, Communications of the ACM, v.27 n.11, p.1129-1133, Nov. 1984
	William Kent, The universal relation revisited (technical correspondence), ACM Transactions on Database Systems (TODS), v.8 n.4, p.644-648, Dec. 1983
	Richard B. Wilmot, Foreign keys decrease adaptability of database designs, Communications of the ACM, v.27 n.12, p.1237-1243, Dec. 1984
	Margaret S. Wu, The practical need for fourth normal form, ACM SIGCSE Bulletin, v.24 n.1, p.19-23, March 1992
	S. Ceri , G. Gottlob, Normalization of relations and PROLOG, Communications of the ACM, v.29 n.6, p.524-544, June 1986
	Mark N. Haynie, Tutorial: The relational data model for Design Automation, Proceedings of the 20th conference on Design automation, p.599-607, June 27-29, 1983, Miami Beach, Florida, United States
	Henry C. Smith, Database design: composing fully normalized tables from a rigorous dependency diagram, Communications of the ACM, v.28 n.8, p.826-838, Aug. 1985
	Priti Mishra , Margaret H. Eich, Join processing in relational databases, ACM Computing Surveys (CSUR), v.24 n.1, p.63-113, March 1992
	S. Ceri , S. Crespi-Reghizzi, Relational data bases in the design of program construction systems, ACM SIGSOFT Software Engineering Notes, v.8 n.3, p.17-29, July 1983
	S. Ceri , S. Crespi-Reghizzi, Relational data bases in the design of program construction systems, ACM SIGPLAN Notices, v.18 n.11, November 1983
	E. A. Unger , Cleopas O. Angaye, A synthesis algorithm for a class of 4NF, ACM SIGSMALL/PC Notes, v.13 n.4, p.3-31, Nov. 1987
	Alessandro Bianchi , Danilo Caivano , Vittorio Marengo , Giuseppe Visaggio, Iterative Reengineering of Legacy Systems, IEEE Transactions on Software Engineering, v.29 n.3, p.225-241, March 2003
	S. Ceri , S. Crespi-Reghizzi , A. D. Maio , L. A. Lavazza, Software Prototyping by Relational Techniques: Experiences with Program Construction Systems, IEEE Transactions on Software Engineering, v.14 n.11, p.1597-1609, November 1988
	Hai Zhuge , Erlin Yao , Yunpeng Xing , Jie Liu, Extended resource space model, Future Generation Computer Systems, v.21 n.1, p.189-198, 1 January 2005
	Amir Pourabdollah , Michael Hartley, Gathering unstructured workflow data into relational database model using process definition language, Proceedings of the 24th IASTED international conference on Database and applications, p.32-37, February 13-15, 2006, Innsbruck, Austria
	William Kent, Choices in Practical Data Design, Proceedings of the 8th International Conference on Very Large Data Bases, p.165-180, September 08-10, 1982
	Peretz Shoval , Moshe Even-Chaime, Database schema design: an experimental comparison between normalization and information analysis, ACM SIGMIS Database, v.18 n.3, p.30-39, March 1987
	J. R. Dash , R. N. Ojala, IBM database 2 in an information management system environment, IBM Systems Journal, v.23 n.2, p.165-177, June 1984