Normalization is a technique for determining the optimal logical design of an integrated database, based on the obser vation that certain groupings of entities exhibit better proper ties in storage operations than do other groupings containing the same data. The basic principles of normalization theory are reviewed and the advantages it offers are illustrated. The author concludes by discussing the feasibility and desirabil ity of a division of labour in database administration with information scientists and computer scientists respectively managing the logical representation of the database and the physical maintenance of the database.
W. Frank King .Relational database systems, where we stand today, in: S.H. Lavington, ed., Information Processing 80 (North-Holland, Amsterdam, 1980) pp. 369-381.
4.
G. Sandberg , A Primer on relational data base concepts, IBM Systems J.20(1) (1981) 23-40.
5.
E.F. Codd , A relational model of data for large shared data banks, Comm. ACM13 (6) (1970) 377-387.
6.
F.F. Codd, Further normalization of the data base relational model, in: R. Rustin, ed., Courant Computer Science Symposia, Vol. 6: Data Base Systems (Prentice-Hall, Englewood Cliffs, NJ, 1972) pp. 33-64.
7.
E.F. Codd, Recent investigations in relational data base systems, in: Information Processing 74 (North-Holland, Amsterdam, 1974) pp. 1017-1021.
8.
E.F. Codd, op. cit. (1970).
9.
E.F. Codd, op. cit. (1972).
10.
D.C. Tsichritzis and F.H. Lochovsky, Database Management Systems (Academic Press, New York, 1977) p. 47.
11.
C.J. Date, An Introduction to Database Systems, 2nd ed. (Addison-Wesley, Reading, MA, 1977) p. 157.
12.
S.M. Deen, Fundamentals of Data Base Systems (Macmillan Press, London and Basingstoke. 1977) p. 136.
13.
E.F. Codd, op. cit. (1972).
14.
D.C. Tsichritzis et al., op. cit. p. 48.
15.
S.M. Deen, op. cit. p. 138.
16.
C.J. Date, op. cit. p. 160.
17.
E.F. Codd, op. cit. (1972).
18.
D.C. Tsichritzis et al., op. cit. p. 51.
19.
C.J. Date, op. cit. p. 162.
20.
E.F. Codd, op. cit. (1974).
21.
D.C. Tsichritzis et al., op. cit p. 52.
22.
C.J. Date, op. cit. p. 163.
23.
ibid. p. 156.
24.
Fagin.Multivalued dependencies and a new normal form for relational databases, ACM Trans. Database Systems2 (3) (1977) 262-278.
25.
C. Zaniolo, Analysis and design of relational schemata for database systems, Doctoral dissertation, Computer Science Department, University of California . Los Angeles ( 1976).
26.
C.J. Date.op. cit. p. 168.
27.
ibid. p. 169.
28.
P.A. Bernstein , Synthesizing third normal form relations from functional dependencies, ACM Trans. Database Systems1 (4) (1976) 227-298.
29.
C. Beeri et al., A sophisticate's introduction to database normalization theory , in: Proc. of the Fourth International Conference on Very Large Databases (IEEE, New York, 1978) pp. 113-124.
30.
R.Y. Fadous, Decomposition of a relation into fourth normal forms, in: Proc. of the IEEE Computer Society International Computer Software and Applications Conference (IEEE, New York, 1979) pp. 404-408.
31.
P.A. Bernstein and N. Goodman, What does Boyce-Codd normal form do?, in: Proc. of the Sixth International Conference on Very Large Databases (IEEE, New York, 1980) pp. 245-259.
32.
J. Martin, Computer Data-base Organization, 2nd ed. (Prentice-Hall, Fnglewood Cliffs, NJ, 1977) p. 243.
33.
ibid. p. 226.
34.
M.M. Zloof, Query-By-Example: a data base language, IBM Systems J.16 (4) (1977) 324-343.
35.
Interactive Management and Planning System : User Guide. SBII-5220, IBM Corporation .
36.
N.W. Blagsen , System R: An architectural overview, IBM Systems J.20 (1) (1981) 41-62.
37.
N.W. Blagsen , System R: An architectural overview, IBM Systems J.20 (1) (1981) 41-62.
M.E. Senko, Classification: A basic tool for data bases and information systems, in: Data Base Technology, Vol. 2. (Infotech , Maidenhead, 1978) pp. 301-315.
40.
J.C. Thomas and J.D. Gould, A psychological study of query by example, AFIPS Conference Proc. 44 (1975) 439-445.
