Abstract
In his seminal paper on the relational data model, E.F. Codd formulated a number of design principles for a relational database (Codd, 1970). These principles were expressed in terms of three normal forms. The process of transforming a database design through these three normal forms is known as normalisation. By the mid-1970s third normal form was shown to have certain inadequacies and a stronger normal form, known as Boyce-Codd normal form was introduced (Codd, 1974). Subsequently, Fagin introduced fourth normal form and fifth normal form (Fagin 1977, 1979).
Preview
Unable to display preview. Download preview PDF.
Bibliography
Beynon-Davies P. (1996). Database Systems. Macmillan Press, Basingstoke.
Codd E.F. (1970). ‘A Relational Model for Large Shared Data Banks’. CACM. 13 (1). 377–387.
Codd E.F. (1974). ‘Recent Investigations into Relational Database Systems’. Proc. IFIP Congress.
Fagin R. (1977). ‘Multi-Valued Dependencies and a New Normal Form for Relational Databases’. ACM Trans. on Database Systems. 2(1).
Fagin R. (1979). ‘Normal Forms and Relational Database Operators’. ACM SIGMOD Int. Symposium on the Management of Data. 153–160.
Author information
Authors and Affiliations
Copyright information
© 1998 P. Beynon-Davies
About this chapter
Cite this chapter
Beynon-Davies, P. (1998). Normalisation. In: Information Systems Development. Macmillan Computer Science Series. Palgrave, London. https://doi.org/10.1007/978-1-349-14931-5_15
Download citation
DOI: https://doi.org/10.1007/978-1-349-14931-5_15
Publisher Name: Palgrave, London
Print ISBN: 978-0-333-74481-9
Online ISBN: 978-1-349-14931-5
eBook Packages: EngineeringEngineering (R0)