Document (#18233)

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.85
    5.848081 = sum of:
      5.848081 = weight(author_txt:bock in 7) [ClassicSimilarity], result of:
        5.848081 = score(doc=7,freq=1.0), product of:
          0.99999994 = queryWeight, product of:
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.10687265 = queryNorm
          5.8480816 = fieldWeight in 7, product of:
            1.0 = tf(freq=1.0), with freq of:
              1.0 = termFreq=1.0
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.625 = fieldNorm(doc=7)
    
  2. Bock, K.: RSWK und die enttäuschte Liebe : ein Nachtrag (1988) 5.85
    5.848081 = sum of:
      5.848081 = weight(author_txt:bock in 8) [ClassicSimilarity], result of:
        5.848081 = score(doc=8,freq=1.0), product of:
          0.99999994 = queryWeight, product of:
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.10687265 = queryNorm
          5.8480816 = fieldWeight in 8, product of:
            1.0 = tf(freq=1.0), with freq of:
              1.0 = termFreq=1.0
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.625 = fieldNorm(doc=8)
    
  3. Bock, F.: Zur Geschichte des Schlagwortkatalogs in Praxis und Theorie (1923) 5.85
    5.848081 = sum of:
      5.848081 = weight(author_txt:bock in 2375) [ClassicSimilarity], result of:
        5.848081 = score(doc=2375,freq=1.0), product of:
          0.99999994 = queryWeight, product of:
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.10687265 = queryNorm
          5.8480816 = fieldWeight in 2375, product of:
            1.0 = tf(freq=1.0), with freq of:
              1.0 = termFreq=1.0
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.625 = fieldNorm(doc=2375)
    
  4. Bock, P.: NRW greift nach den Multimedia-Sternen (2000) 5.85
    5.848081 = sum of:
      5.848081 = weight(author_txt:bock in 5252) [ClassicSimilarity], result of:
        5.848081 = score(doc=5252,freq=1.0), product of:
          0.99999994 = queryWeight, product of:
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.10687265 = queryNorm
          5.8480816 = fieldWeight in 5252, product of:
            1.0 = tf(freq=1.0), with freq of:
              1.0 = termFreq=1.0
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.625 = fieldNorm(doc=5252)
    
  5. Bock, H.-H.: Automatische Klassifikation : theoretische und praktische Methoden zur Gruppierung und Strukturierung von Daten (Cluster-Analyse) (1974) 4.68
    4.678465 = sum of:
      4.678465 = weight(author_txt:bock in 763) [ClassicSimilarity], result of:
        4.678465 = score(doc=763,freq=1.0), product of:
          0.99999994 = queryWeight, product of:
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.10687265 = queryNorm
          4.6784654 = fieldWeight in 763, product of:
            1.0 = tf(freq=1.0), with freq of:
              1.0 = termFreq=1.0
            9.356931 = idf(docFreq=9, maxDocs=42596)
            0.5 = fieldNorm(doc=763)
    

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.29
    0.28554872 = sum of:
      0.28554872 = product of:
        0.9790242 = sum of:
          0.01322805 = weight(abstract_txt:different in 3005) [ClassicSimilarity], result of:
            0.01322805 = score(doc=3005,freq=1.0), product of:
              0.04584091 = queryWeight, product of:
                3.6936228 = idf(docFreq=2880, maxDocs=42596)
                0.012410826 = queryNorm
              0.2885643 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.6936228 = idf(docFreq=2880, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.014214632 = weight(abstract_txt:they in 3005) [ClassicSimilarity], result of:
            0.014214632 = score(doc=3005,freq=1.0), product of:
              0.048092768 = queryWeight, product of:
                1.0242672 = boost
                3.7832568 = idf(docFreq=2633, maxDocs=42596)
                0.012410826 = queryNorm
              0.29556695 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.7832568 = idf(docFreq=2633, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.035593785 = weight(abstract_txt:structures in 3005) [ClassicSimilarity], result of:
            0.035593785 = score(doc=3005,freq=1.0), product of:
              0.08868268 = queryWeight, product of:
                1.39089 = boost
                5.137423 = idf(docFreq=679, maxDocs=42596)
                0.012410826 = queryNorm
              0.40136117 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.137423 = idf(docFreq=679, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.09155723 = weight(abstract_txt:relationship in 3005) [ClassicSimilarity], result of:
            0.09155723 = score(doc=3005,freq=2.0), product of:
              0.16648857 = queryWeight, product of:
                2.6951356 = boost
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.012410826 = queryNorm
              0.549931 = fieldWeight in 3005, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.1335727 = weight(abstract_txt:entity in 3005) [ClassicSimilarity], result of:
            0.1335727 = score(doc=3005,freq=1.0), product of:
              0.2698223 = queryWeight, product of:
                3.431052 = boost
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.012410826 = queryNorm
              0.49503952 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.39853594 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
            0.39853594 = score(doc=3005,freq=3.0), product of:
              0.4438481 = queryWeight, product of:
                5.3895335 = boost
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.012410826 = queryNorm
              0.89791065 = fieldWeight in 3005, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.078125 = fieldNorm(doc=3005)
          0.2923218 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
            0.2923218 = score(doc=3005,freq=1.0), product of:
              0.5730381 = queryWeight, product of:
                7.071233 = boost
                6.529617 = idf(docFreq=168, maxDocs=42596)
                0.012410826 = queryNorm
              0.5101263 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.529617 = idf(docFreq=168, maxDocs=42596)
                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.1747591 = sum of:
      0.1747591 = product of:
        0.6990364 = sum of:
          0.035321187 = weight(abstract_txt:result in 782) [ClassicSimilarity], result of:
            0.035321187 = score(doc=782,freq=1.0), product of:
              0.08822931 = queryWeight, product of:
                1.3873302 = boost
                5.1242743 = idf(docFreq=688, maxDocs=42596)
                0.012410826 = queryNorm
              0.40033394 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.1242743 = idf(docFreq=688, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
          0.0395063 = weight(abstract_txt:outlines in 782) [ClassicSimilarity], result of:
            0.0395063 = score(doc=782,freq=1.0), product of:
              0.09506784 = queryWeight, product of:
                1.4400918 = boost
                5.319156 = idf(docFreq=566, maxDocs=42596)
                0.012410826 = queryNorm
              0.41555908 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.319156 = idf(docFreq=566, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
          0.11365654 = weight(abstract_txt:normalization in 782) [ClassicSimilarity], result of:
            0.11365654 = score(doc=782,freq=1.0), product of:
              0.19230282 = queryWeight, product of:
                2.048171 = boost
                7.5651712 = idf(docFreq=59, maxDocs=42596)
                0.012410826 = queryNorm
              0.591029 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.5651712 = idf(docFreq=59, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
          0.09155723 = weight(abstract_txt:relationship in 782) [ClassicSimilarity], result of:
            0.09155723 = score(doc=782,freq=2.0), product of:
              0.16648857 = queryWeight, product of:
                2.6951356 = boost
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.012410826 = queryNorm
              0.549931 = fieldWeight in 782, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
          0.18890032 = weight(abstract_txt:entity in 782) [ClassicSimilarity], result of:
            0.18890032 = score(doc=782,freq=2.0), product of:
              0.2698223 = queryWeight, product of:
                3.431052 = boost
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.012410826 = queryNorm
              0.7000916 = fieldWeight in 782, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
          0.23009484 = weight(abstract_txt:modelling in 782) [ClassicSimilarity], result of:
            0.23009484 = score(doc=782,freq=1.0), product of:
              0.4438481 = queryWeight, product of:
                5.3895335 = boost
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.012410826 = queryNorm
              0.51840895 = fieldWeight in 782, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.078125 = fieldNorm(doc=782)
        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.17268147 = sum of:
      0.17268147 = product of:
        0.69072586 = sum of:
          0.020102523 = weight(abstract_txt:they in 6765) [ClassicSimilarity], result of:
            0.020102523 = score(doc=6765,freq=2.0), product of:
              0.048092768 = queryWeight, product of:
                1.0242672 = boost
                3.7832568 = idf(docFreq=2633, maxDocs=42596)
                0.012410826 = queryNorm
              0.41799474 = fieldWeight in 6765, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                3.7832568 = idf(docFreq=2633, maxDocs=42596)
                0.078125 = fieldNorm(doc=6765)
          0.038452785 = weight(abstract_txt:models in 6765) [ClassicSimilarity], result of:
            0.038452785 = score(doc=6765,freq=2.0), product of:
              0.07410791 = queryWeight, product of:
                1.2714686 = boost
                4.696326 = idf(docFreq=1056, maxDocs=42596)
                0.012410826 = queryNorm
              0.5188756 = fieldWeight in 6765, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.696326 = idf(docFreq=1056, maxDocs=42596)
                0.078125 = fieldNorm(doc=6765)
          0.035321187 = weight(abstract_txt:result in 6765) [ClassicSimilarity], result of:
            0.035321187 = score(doc=6765,freq=1.0), product of:
              0.08822931 = queryWeight, product of:
                1.3873302 = boost
                5.1242743 = idf(docFreq=688, maxDocs=42596)
                0.012410826 = queryNorm
              0.40033394 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.1242743 = idf(docFreq=688, maxDocs=42596)
                0.078125 = fieldNorm(doc=6765)
          0.06474073 = weight(abstract_txt:relationship in 6765) [ClassicSimilarity], result of:
            0.06474073 = score(doc=6765,freq=1.0), product of:
              0.16648857 = queryWeight, product of:
                2.6951356 = boost
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.012410826 = queryNorm
              0.38885993 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.078125 = fieldNorm(doc=6765)
          0.1335727 = weight(abstract_txt:entity in 6765) [ClassicSimilarity], result of:
            0.1335727 = score(doc=6765,freq=1.0), product of:
              0.2698223 = queryWeight, product of:
                3.431052 = boost
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.012410826 = queryNorm
              0.49503952 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.078125 = fieldNorm(doc=6765)
          0.39853594 = weight(abstract_txt:modelling in 6765) [ClassicSimilarity], result of:
            0.39853594 = score(doc=6765,freq=3.0), product of:
              0.4438481 = queryWeight, product of:
                5.3895335 = boost
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.012410826 = queryNorm
              0.89791065 = fieldWeight in 6765, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.635635 = idf(docFreq=151, maxDocs=42596)
                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.15337892 = sum of:
      0.15337892 = product of:
        0.9202735 = sum of:
          0.023813318 = weight(abstract_txt:types in 563) [ClassicSimilarity], result of:
            0.023813318 = score(doc=563,freq=1.0), product of:
              0.06783742 = queryWeight, product of:
                1.2164886 = boost
                4.49325 = idf(docFreq=1294, maxDocs=42596)
                0.012410826 = queryNorm
              0.35103515 = fieldWeight in 563, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.49325 = idf(docFreq=1294, maxDocs=42596)
                0.078125 = fieldNorm(doc=563)
          0.06474073 = weight(abstract_txt:relationship in 563) [ClassicSimilarity], result of:
            0.06474073 = score(doc=563,freq=1.0), product of:
              0.16648857 = queryWeight, product of:
                2.6951356 = boost
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.012410826 = queryNorm
              0.38885993 = fieldWeight in 563, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.078125 = fieldNorm(doc=563)
          0.32540324 = weight(abstract_txt:modelling in 563) [ClassicSimilarity], result of:
            0.32540324 = score(doc=563,freq=2.0), product of:
              0.4438481 = queryWeight, product of:
                5.3895335 = boost
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.012410826 = queryNorm
              0.733141 = fieldWeight in 563, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.635635 = idf(docFreq=151, maxDocs=42596)
                0.078125 = fieldNorm(doc=563)
          0.5063162 = weight(abstract_txt:errors in 563) [ClassicSimilarity], result of:
            0.5063162 = score(doc=563,freq=3.0), product of:
              0.5730381 = queryWeight, product of:
                7.071233 = boost
                6.529617 = idf(docFreq=168, maxDocs=42596)
                0.012410826 = queryNorm
              0.88356465 = fieldWeight in 563, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.529617 = idf(docFreq=168, maxDocs=42596)
                0.078125 = fieldNorm(doc=563)
        0.16666667 = coord(4/24)
    
  5. Chan, H.C.; Wei, K.K.; Siau, K.L.: ¬A system for query comprehension (1997) 0.13
    0.13358504 = sum of:
      0.13358504 = product of:
        0.8015102 = sum of:
          0.067447506 = weight(abstract_txt:understand in 1423) [ClassicSimilarity], result of:
            0.067447506 = score(doc=1423,freq=2.0), product of:
              0.09544851 = queryWeight, product of:
                1.4429722 = boost
                5.329795 = idf(docFreq=560, maxDocs=42596)
                0.012410826 = queryNorm
              0.7066376 = fieldWeight in 1423, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                5.329795 = idf(docFreq=560, maxDocs=42596)
                0.09375 = fieldNorm(doc=1423)
          0.07768888 = weight(abstract_txt:relationship in 1423) [ClassicSimilarity], result of:
            0.07768888 = score(doc=1423,freq=1.0), product of:
              0.16648857 = queryWeight, product of:
                2.6951356 = boost
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.012410826 = queryNorm
              0.4666319 = fieldWeight in 1423, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.977407 = idf(docFreq=797, maxDocs=42596)
                0.09375 = fieldNorm(doc=1423)
          0.16028725 = weight(abstract_txt:entity in 1423) [ClassicSimilarity], result of:
            0.16028725 = score(doc=1423,freq=1.0), product of:
              0.2698223 = queryWeight, product of:
                3.431052 = boost
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.012410826 = queryNorm
              0.5940474 = fieldWeight in 1423, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.336506 = idf(docFreq=204, maxDocs=42596)
                0.09375 = fieldNorm(doc=1423)
          0.4960866 = weight(abstract_txt:errors in 1423) [ClassicSimilarity], result of:
            0.4960866 = score(doc=1423,freq=2.0), product of:
              0.5730381 = queryWeight, product of:
                7.071233 = boost
                6.529617 = idf(docFreq=168, maxDocs=42596)
                0.012410826 = queryNorm
              0.8657131 = fieldWeight in 1423, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.529617 = idf(docFreq=168, maxDocs=42596)
                0.09375 = fieldNorm(doc=1423)
        0.16666667 = coord(4/24)