Document (#18232)

Author

Bock, D.B.

Title

Entity-relationship modelling and normalization errors

Source

Journal of database management. 8(1997) no.1, S.4-12

Year

1997

Abstract

Examines different types of entity-relationship (E-R) modelling errors in order to understand when they arise. Outlines situations where errors in E-R models can result in non-normalised table structures. Sets out keys to avoiding E-R modelling errors

Similar documents (author)

1. Bock, K.: RSWK oder der Sündenkatalog (1988) 5.87

   5.871439 = sum of:
     5.871439 = weight(author_txt:bock in 7) [ClassicSimilarity], result of:
       5.871439 = fieldWeight in 7, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.394302 = idf(docFreq=9, maxDocs=44218)
         0.625 = fieldNorm(doc=7)
   

2. Bock, K.: RSWK und die enttäuschte Liebe : ein Nachtrag (1988) 5.87

   5.871439 = sum of:
     5.871439 = weight(author_txt:bock in 8) [ClassicSimilarity], result of:
       5.871439 = fieldWeight in 8, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.394302 = idf(docFreq=9, maxDocs=44218)
         0.625 = fieldNorm(doc=8)
   

3. Bock, F.: Zur Geschichte des Schlagwortkatalogs in Praxis und Theorie (1923) 5.87

   5.871439 = sum of:
     5.871439 = weight(author_txt:bock in 2375) [ClassicSimilarity], result of:
       5.871439 = fieldWeight in 2375, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.394302 = idf(docFreq=9, maxDocs=44218)
         0.625 = fieldNorm(doc=2375)
   

4. Bock, P.: NRW greift nach den Multimedia-Sternen (2000) 5.87

   5.871439 = sum of:
     5.871439 = weight(author_txt:bock in 4251) [ClassicSimilarity], result of:
       5.871439 = fieldWeight in 4251, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.394302 = idf(docFreq=9, maxDocs=44218)
         0.625 = fieldNorm(doc=4251)
   

5. Bock, H.-H.: Automatische Klassifikation : theoretische und praktische Methoden zur Gruppierung und Strukturierung von Daten (Cluster-Analyse) (1974) 4.70

   4.697151 = sum of:
     4.697151 = weight(author_txt:bock in 7693) [ClassicSimilarity], result of:
       4.697151 = fieldWeight in 7693, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.394302 = idf(docFreq=9, maxDocs=44218)
         0.5 = fieldNorm(doc=7693)
   

Similar documents (content)

1. Batra, D.; Davis, J.G.: Conceptual data modelling in database design : similarities and differences between expert and novice designers (1992) 0.28

   0.28368846 = sum of:
     0.28368846 = product of:
       0.9726461 = sum of:
         0.012936528 = weight(abstract_txt:different in 3005) [ClassicSimilarity], result of:
           0.012936528 = score(doc=3005,freq=1.0), product of:
             0.045174595 = queryWeight, product of:
               3.6655018 = idf(docFreq=3075, maxDocs=44218)
               0.01232426 = queryNorm
             0.28636733 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.6655018 = idf(docFreq=3075, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.013874586 = weight(abstract_txt:they in 3005) [ClassicSimilarity], result of:
           0.013874586 = score(doc=3005,freq=1.0), product of:
             0.04733283 = queryWeight, product of:
               1.023609 = boost
               3.7520406 = idf(docFreq=2820, maxDocs=44218)
               0.01232426 = queryNorm
             0.29312816 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.7520406 = idf(docFreq=2820, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.035206728 = weight(abstract_txt:structures in 3005) [ClassicSimilarity], result of:
           0.035206728 = score(doc=3005,freq=1.0), product of:
             0.08805747 = queryWeight, product of:
               1.3961625 = boost
               5.117636 = idf(docFreq=719, maxDocs=44218)
               0.01232426 = queryNorm
             0.39981532 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.117636 = idf(docFreq=719, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.09039459 = weight(abstract_txt:relationship in 3005) [ClassicSimilarity], result of:
           0.09039459 = score(doc=3005,freq=2.0), product of:
             0.16511153 = queryWeight, product of:
               2.703688 = boost
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.01232426 = queryNorm
             0.54747593 = fieldWeight in 3005, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.1298881 = weight(abstract_txt:entity in 3005) [ClassicSimilarity], result of:
           0.1298881 = score(doc=3005,freq=1.0), product of:
             0.26489395 = queryWeight, product of:
               3.424553 = boost
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.01232426 = queryNorm
             0.49034002 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.39516997 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
           0.39516997 = score(doc=3005,freq=3.0), product of:
             0.44144008 = queryWeight, product of:
               5.4143877 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.01232426 = queryNorm
             0.89518374 = fieldWeight in 3005, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
         0.29517564 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
           0.29517564 = score(doc=3005,freq=1.0), product of:
             0.5768853 = queryWeight, product of:
               7.1470623 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.01232426 = queryNorm
             0.5116713 = fieldWeight in 3005, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.078125 = fieldNorm(doc=3005)
       0.29166666 = coord(7/24)
   

2. Green, R.: ¬The design of a relational database for large-scale bibliographic retrieval (1996) 0.17

   0.17300366 = sum of:
     0.17300366 = product of:
       0.69201463 = sum of:
         0.034894723 = weight(abstract_txt:result in 7712) [ClassicSimilarity], result of:
           0.034894723 = score(doc=7712,freq=1.0), product of:
             0.087536454 = queryWeight, product of:
               1.392026 = boost
               5.1024737 = idf(docFreq=730, maxDocs=44218)
               0.01232426 = queryNorm
             0.39863077 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1024737 = idf(docFreq=730, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.040212076 = weight(abstract_txt:outlines in 7712) [ClassicSimilarity], result of:
           0.040212076 = score(doc=7712,freq=1.0), product of:
             0.09621736 = queryWeight, product of:
               1.4594176 = boost
               5.349498 = idf(docFreq=570, maxDocs=44218)
               0.01232426 = queryNorm
             0.41792953 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.349498 = idf(docFreq=570, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.11467223 = weight(abstract_txt:normalization in 7712) [ClassicSimilarity], result of:
           0.11467223 = score(doc=7712,freq=1.0), product of:
             0.19348827 = queryWeight, product of:
               2.0695703 = boost
               7.5860133 = idf(docFreq=60, maxDocs=44218)
               0.01232426 = queryNorm
             0.59265727 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.5860133 = idf(docFreq=60, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.09039459 = weight(abstract_txt:relationship in 7712) [ClassicSimilarity], result of:
           0.09039459 = score(doc=7712,freq=2.0), product of:
             0.16511153 = queryWeight, product of:
               2.703688 = boost
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.01232426 = queryNorm
             0.54747593 = fieldWeight in 7712, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.18368952 = weight(abstract_txt:entity in 7712) [ClassicSimilarity], result of:
           0.18368952 = score(doc=7712,freq=2.0), product of:
             0.26489395 = queryWeight, product of:
               3.424553 = boost
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.01232426 = queryNorm
             0.6934455 = fieldWeight in 7712, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
         0.22815152 = weight(abstract_txt:modelling in 7712) [ClassicSimilarity], result of:
           0.22815152 = score(doc=7712,freq=1.0), product of:
             0.44144008 = queryWeight, product of:
               5.4143877 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.01232426 = queryNorm
             0.5168346 = fieldWeight in 7712, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=7712)
       0.25 = coord(6/24)
   

3. Heuser, C.A.; Peres, E.M.; Richter, G.: Towards a complete conceptual model : Petri nets and entity-relationship diagrams (1993) 0.17

   0.17016011 = sum of:
     0.17016011 = product of:
       0.68064046 = sum of:
         0.019621627 = weight(abstract_txt:they in 6765) [ClassicSimilarity], result of:
           0.019621627 = score(doc=6765,freq=2.0), product of:
             0.04733283 = queryWeight, product of:
               1.023609 = boost
               3.7520406 = idf(docFreq=2820, maxDocs=44218)
               0.01232426 = queryNorm
             0.41454583 = fieldWeight in 6765, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.7520406 = idf(docFreq=2820, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
         0.0371474 = weight(abstract_txt:models in 6765) [ClassicSimilarity], result of:
           0.0371474 = score(doc=6765,freq=2.0), product of:
             0.0724366 = queryWeight, product of:
               1.2662863 = boost
               4.6415744 = idf(docFreq=1158, maxDocs=44218)
               0.01232426 = queryNorm
             0.5128264 = fieldWeight in 6765, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.6415744 = idf(docFreq=1158, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
         0.034894723 = weight(abstract_txt:result in 6765) [ClassicSimilarity], result of:
           0.034894723 = score(doc=6765,freq=1.0), product of:
             0.087536454 = queryWeight, product of:
               1.392026 = boost
               5.1024737 = idf(docFreq=730, maxDocs=44218)
               0.01232426 = queryNorm
             0.39863077 = fieldWeight in 6765, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1024737 = idf(docFreq=730, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
         0.06391863 = weight(abstract_txt:relationship in 6765) [ClassicSimilarity], result of:
           0.06391863 = score(doc=6765,freq=1.0), product of:
             0.16511153 = queryWeight, product of:
               2.703688 = boost
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.01232426 = queryNorm
             0.38712394 = fieldWeight in 6765, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
         0.1298881 = weight(abstract_txt:entity in 6765) [ClassicSimilarity], result of:
           0.1298881 = score(doc=6765,freq=1.0), product of:
             0.26489395 = queryWeight, product of:
               3.424553 = boost
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.01232426 = queryNorm
             0.49034002 = fieldWeight in 6765, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
         0.39516997 = weight(abstract_txt:modelling in 6765) [ClassicSimilarity], result of:
           0.39516997 = score(doc=6765,freq=3.0), product of:
             0.44144008 = queryWeight, product of:
               5.4143877 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.01232426 = queryNorm
             0.89518374 = fieldWeight in 6765, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=6765)
       0.25 = coord(6/24)
   

4. Batra, D.; Sein, M.K.: Improving conceptual database design through feedback (1994) 0.15

   0.15354496 = sum of:
     0.15354496 = product of:
       0.9212698 = sum of:
         0.023437018 = weight(abstract_txt:types in 8563) [ClassicSimilarity], result of:
           0.023437018 = score(doc=8563,freq=1.0), product of:
             0.06713526 = queryWeight, product of:
               1.2190688 = boost
               4.4684987 = idf(docFreq=1377, maxDocs=44218)
               0.01232426 = queryNorm
             0.34910145 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4684987 = idf(docFreq=1377, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.06391863 = weight(abstract_txt:relationship in 8563) [ClassicSimilarity], result of:
           0.06391863 = score(doc=8563,freq=1.0), product of:
             0.16511153 = queryWeight, product of:
               2.703688 = boost
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.01232426 = queryNorm
             0.38712394 = fieldWeight in 8563, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.32265493 = weight(abstract_txt:modelling in 8563) [ClassicSimilarity], result of:
           0.32265493 = score(doc=8563,freq=2.0), product of:
             0.44144008 = queryWeight, product of:
               5.4143877 = boost
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.01232426 = queryNorm
             0.7309145 = fieldWeight in 8563, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.615483 = idf(docFreq=160, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
         0.5112592 = weight(abstract_txt:errors in 8563) [ClassicSimilarity], result of:
           0.5112592 = score(doc=8563,freq=3.0), product of:
             0.5768853 = queryWeight, product of:
               7.1470623 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.01232426 = queryNorm
             0.88624066 = fieldWeight in 8563, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.078125 = fieldNorm(doc=8563)
       0.16666667 = coord(4/24)
   

5. Chan, H.C.; Wei, K.K.; Siau, K.L.: ¬A system for query comprehension (1997) 0.13

   0.1330665 = sum of:
     0.1330665 = product of:
       0.79839903 = sum of:
         0.0649013 = weight(abstract_txt:understand in 422) [ClassicSimilarity], result of:
           0.0649013 = score(doc=422,freq=2.0), product of:
             0.0930509 = queryWeight, product of:
               1.4352024 = boost
               5.260737 = idf(docFreq=623, maxDocs=44218)
               0.01232426 = queryNorm
             0.69748175 = fieldWeight in 422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               5.260737 = idf(docFreq=623, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.07670235 = weight(abstract_txt:relationship in 422) [ClassicSimilarity], result of:
           0.07670235 = score(doc=422,freq=1.0), product of:
             0.16511153 = queryWeight, product of:
               2.703688 = boost
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.01232426 = queryNorm
             0.4645487 = fieldWeight in 422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9551864 = idf(docFreq=846, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.15586573 = weight(abstract_txt:entity in 422) [ClassicSimilarity], result of:
           0.15586573 = score(doc=422,freq=1.0), product of:
             0.26489395 = queryWeight, product of:
               3.424553 = boost
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.01232426 = queryNorm
             0.58840805 = fieldWeight in 422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.2763524 = idf(docFreq=225, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
         0.50092965 = weight(abstract_txt:errors in 422) [ClassicSimilarity], result of:
           0.50092965 = score(doc=422,freq=2.0), product of:
             0.5768853 = queryWeight, product of:
               7.1470623 = boost
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.01232426 = queryNorm
             0.86833495 = fieldWeight in 422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.5493927 = idf(docFreq=171, maxDocs=44218)
               0.09375 = fieldNorm(doc=422)
       0.16666667 = coord(4/24)