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.84
    5.838709 = sum of:
      5.838709 = weight(author_txt:bock in 7) [ClassicSimilarity], result of:
        5.838709 = fieldWeight in 7, product of:
          1.0 = tf(freq=1.0), with freq of:
            1.0 = termFreq=1.0
          9.341934 = idf(docFreq=9, maxDocs=41962)
          0.625 = fieldNorm(doc=7)
    
  2. Bock, K.: RSWK und die enttäuschte Liebe : ein Nachtrag (1988) 5.84
    5.838709 = sum of:
      5.838709 = weight(author_txt:bock in 8) [ClassicSimilarity], result of:
        5.838709 = fieldWeight in 8, product of:
          1.0 = tf(freq=1.0), with freq of:
            1.0 = termFreq=1.0
          9.341934 = idf(docFreq=9, maxDocs=41962)
          0.625 = fieldNorm(doc=8)
    
  3. Bock, F.: Zur Geschichte des Schlagwortkatalogs in Praxis und Theorie (1923) 5.84
    5.838709 = sum of:
      5.838709 = weight(author_txt:bock in 2375) [ClassicSimilarity], result of:
        5.838709 = fieldWeight in 2375, product of:
          1.0 = tf(freq=1.0), with freq of:
            1.0 = termFreq=1.0
          9.341934 = idf(docFreq=9, maxDocs=41962)
          0.625 = fieldNorm(doc=2375)
    
  4. Bock, P.: NRW greift nach den Multimedia-Sternen (2000) 5.84
    5.838709 = sum of:
      5.838709 = weight(author_txt:bock in 5665) [ClassicSimilarity], result of:
        5.838709 = fieldWeight in 5665, product of:
          1.0 = tf(freq=1.0), with freq of:
            1.0 = termFreq=1.0
          9.341934 = idf(docFreq=9, maxDocs=41962)
          0.625 = fieldNorm(doc=5665)
    
  5. Bock, H.-H.: Automatische Klassifikation : theoretische und praktische Methoden zur Gruppierung und Strukturierung von Daten (Cluster-Analyse) (1974) 4.67
    4.670967 = sum of:
      4.670967 = weight(author_txt:bock in 176) [ClassicSimilarity], result of:
        4.670967 = fieldWeight in 176, product of:
          1.0 = tf(freq=1.0), with freq of:
            1.0 = termFreq=1.0
          9.341934 = idf(docFreq=9, maxDocs=41962)
          0.5 = fieldNorm(doc=176)
    

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.28616592 = sum of:
      0.28616592 = product of:
        0.9811404 = sum of:
          0.013392848 = weight(abstract_txt:different in 3005) [ClassicSimilarity], result of:
            0.013392848 = score(doc=3005,freq=1.0), product of:
              0.046135586 = queryWeight, product of:
                3.7157533 = idf(docFreq=2775, maxDocs=41962)
                0.012416214 = queryNorm
              0.29029322 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.7157533 = idf(docFreq=2775, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.014323344 = weight(abstract_txt:they in 3005) [ClassicSimilarity], result of:
            0.014323344 = score(doc=3005,freq=1.0), product of:
              0.04824849 = queryWeight, product of:
                1.0226425 = boost
                3.7998872 = idf(docFreq=2551, maxDocs=41962)
                0.012416214 = queryNorm
              0.29686618 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.7998872 = idf(docFreq=2551, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.035455238 = weight(abstract_txt:structures in 3005) [ClassicSimilarity], result of:
            0.035455238 = score(doc=3005,freq=1.0), product of:
              0.08828922 = queryWeight, product of:
                1.3833619 = boost
                5.1402316 = idf(docFreq=667, maxDocs=41962)
                0.012416214 = queryNorm
              0.4015806 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.1402316 = idf(docFreq=667, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.09197838 = weight(abstract_txt:relationship in 3005) [ClassicSimilarity], result of:
            0.09197838 = score(doc=3005,freq=2.0), product of:
              0.16669066 = queryWeight, product of:
                2.6881444 = boost
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.012416214 = queryNorm
              0.55179083 = fieldWeight in 3005, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.13440125 = weight(abstract_txt:entity in 3005) [ClassicSimilarity], result of:
            0.13440125 = score(doc=3005,freq=1.0), product of:
              0.2704371 = queryWeight, product of:
                3.4239712 = boost
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.012416214 = queryNorm
              0.49697784 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.39721984 = weight(abstract_txt:modelling in 3005) [ClassicSimilarity], result of:
            0.39721984 = score(doc=3005,freq=3.0), product of:
              0.44205338 = queryWeight, product of:
                5.3614216 = boost
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.012416214 = queryNorm
              0.8985789 = fieldWeight in 3005, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.078125 = fieldNorm(doc=3005)
          0.29436943 = weight(abstract_txt:errors in 3005) [ClassicSimilarity], result of:
            0.29436943 = score(doc=3005,freq=1.0), product of:
              0.57464886 = queryWeight, product of:
                7.058513 = boost
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                0.012416214 = queryNorm
              0.51225966 = fieldWeight in 3005, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                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.17498535 = sum of:
      0.17498535 = product of:
        0.6999414 = sum of:
          0.035486247 = weight(abstract_txt:result in 195) [ClassicSimilarity], result of:
            0.035486247 = score(doc=195,freq=1.0), product of:
              0.08834069 = queryWeight, product of:
                1.3837651 = boost
                5.14173 = idf(docFreq=666, maxDocs=41962)
                0.012416214 = queryNorm
              0.40169764 = fieldWeight in 195, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.14173 = idf(docFreq=666, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
          0.039191585 = weight(abstract_txt:outlines in 195) [ClassicSimilarity], result of:
            0.039191585 = score(doc=195,freq=1.0), product of:
              0.09438782 = queryWeight, product of:
                1.4303422 = boost
                5.314799 = idf(docFreq=560, maxDocs=41962)
                0.012416214 = queryNorm
              0.41521865 = fieldWeight in 195, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.314799 = idf(docFreq=560, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
          0.11387818 = weight(abstract_txt:normalization in 195) [ClassicSimilarity], result of:
            0.11387818 = score(doc=195,freq=1.0), product of:
              0.19219752 = queryWeight, product of:
                2.0410604 = boost
                7.584077 = idf(docFreq=57, maxDocs=41962)
                0.012416214 = queryNorm
              0.592506 = fieldWeight in 195, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                7.584077 = idf(docFreq=57, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
          0.09197838 = weight(abstract_txt:relationship in 195) [ClassicSimilarity], result of:
            0.09197838 = score(doc=195,freq=2.0), product of:
              0.16669066 = queryWeight, product of:
                2.6881444 = boost
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.012416214 = queryNorm
              0.55179083 = fieldWeight in 195, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
          0.19007206 = weight(abstract_txt:entity in 195) [ClassicSimilarity], result of:
            0.19007206 = score(doc=195,freq=2.0), product of:
              0.2704371 = queryWeight, product of:
                3.4239712 = boost
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.012416214 = queryNorm
              0.7028328 = fieldWeight in 195, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
          0.22933498 = weight(abstract_txt:modelling in 195) [ClassicSimilarity], result of:
            0.22933498 = score(doc=195,freq=1.0), product of:
              0.44205338 = queryWeight, product of:
                5.3614216 = boost
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.012416214 = queryNorm
              0.5187948 = fieldWeight in 195, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.078125 = fieldNorm(doc=195)
        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.17288494 = sum of:
      0.17288494 = product of:
        0.69153976 = sum of:
          0.020256268 = weight(abstract_txt:they in 6765) [ClassicSimilarity], result of:
            0.020256268 = score(doc=6765,freq=2.0), product of:
              0.04824849 = queryWeight, product of:
                1.0226425 = boost
                3.7998872 = idf(docFreq=2551, maxDocs=41962)
                0.012416214 = queryNorm
              0.41983217 = fieldWeight in 6765, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                3.7998872 = idf(docFreq=2551, maxDocs=41962)
                0.078125 = fieldNorm(doc=6765)
          0.039137598 = weight(abstract_txt:models in 6765) [ClassicSimilarity], result of:
            0.039137598 = score(doc=6765,freq=2.0), product of:
              0.07484686 = queryWeight, product of:
                1.2737046 = boost
                4.7327724 = idf(docFreq=1003, maxDocs=41962)
                0.012416214 = queryNorm
              0.52290237 = fieldWeight in 6765, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.7327724 = idf(docFreq=1003, maxDocs=41962)
                0.078125 = fieldNorm(doc=6765)
          0.035486247 = weight(abstract_txt:result in 6765) [ClassicSimilarity], result of:
            0.035486247 = score(doc=6765,freq=1.0), product of:
              0.08834069 = queryWeight, product of:
                1.3837651 = boost
                5.14173 = idf(docFreq=666, maxDocs=41962)
                0.012416214 = queryNorm
              0.40169764 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.14173 = idf(docFreq=666, maxDocs=41962)
                0.078125 = fieldNorm(doc=6765)
          0.06503854 = weight(abstract_txt:relationship in 6765) [ClassicSimilarity], result of:
            0.06503854 = score(doc=6765,freq=1.0), product of:
              0.16669066 = queryWeight, product of:
                2.6881444 = boost
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.012416214 = queryNorm
              0.39017504 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.078125 = fieldNorm(doc=6765)
          0.13440125 = weight(abstract_txt:entity in 6765) [ClassicSimilarity], result of:
            0.13440125 = score(doc=6765,freq=1.0), product of:
              0.2704371 = queryWeight, product of:
                3.4239712 = boost
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.012416214 = queryNorm
              0.49697784 = fieldWeight in 6765, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.078125 = fieldNorm(doc=6765)
          0.39721984 = weight(abstract_txt:modelling in 6765) [ClassicSimilarity], result of:
            0.39721984 = score(doc=6765,freq=3.0), product of:
              0.44205338 = queryWeight, product of:
                5.3614216 = boost
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.012416214 = queryNorm
              0.8985789 = fieldWeight in 6765, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                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.1538683 = sum of:
      0.1538683 = product of:
        0.9232098 = sum of:
          0.023979822 = weight(abstract_txt:types in 563) [ClassicSimilarity], result of:
            0.023979822 = score(doc=563,freq=1.0), product of:
              0.06802753 = queryWeight, product of:
                1.2142954 = boost
                4.512022 = idf(docFreq=1251, maxDocs=41962)
                0.012416214 = queryNorm
              0.35250172 = fieldWeight in 563, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.512022 = idf(docFreq=1251, maxDocs=41962)
                0.078125 = fieldNorm(doc=563)
          0.06503854 = weight(abstract_txt:relationship in 563) [ClassicSimilarity], result of:
            0.06503854 = score(doc=563,freq=1.0), product of:
              0.16669066 = queryWeight, product of:
                2.6881444 = boost
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.012416214 = queryNorm
              0.39017504 = fieldWeight in 563, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.078125 = fieldNorm(doc=563)
          0.32432866 = weight(abstract_txt:modelling in 563) [ClassicSimilarity], result of:
            0.32432866 = score(doc=563,freq=2.0), product of:
              0.44205338 = queryWeight, product of:
                5.3614216 = boost
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.012416214 = queryNorm
              0.7336866 = fieldWeight in 563, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.6405735 = idf(docFreq=148, maxDocs=41962)
                0.078125 = fieldNorm(doc=563)
          0.5098628 = weight(abstract_txt:errors in 563) [ClassicSimilarity], result of:
            0.5098628 = score(doc=563,freq=3.0), product of:
              0.57464886 = queryWeight, product of:
                7.058513 = boost
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                0.012416214 = queryNorm
              0.8872597 = fieldWeight in 563, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                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.13462907 = sum of:
      0.13462907 = product of:
        0.8077744 = sum of:
          0.068885215 = weight(abstract_txt:understand in 1836) [ClassicSimilarity], result of:
            0.068885215 = score(doc=1836,freq=2.0), product of:
              0.096621536 = queryWeight, product of:
                1.447168 = boost
                5.3773193 = idf(docFreq=526, maxDocs=41962)
                0.012416214 = queryNorm
              0.71293855 = fieldWeight in 1836, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                5.3773193 = idf(docFreq=526, maxDocs=41962)
                0.09375 = fieldNorm(doc=1836)
          0.07804625 = weight(abstract_txt:relationship in 1836) [ClassicSimilarity], result of:
            0.07804625 = score(doc=1836,freq=1.0), product of:
              0.16669066 = queryWeight, product of:
                2.6881444 = boost
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.012416214 = queryNorm
              0.46821007 = fieldWeight in 1836, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.9942408 = idf(docFreq=772, maxDocs=41962)
                0.09375 = fieldNorm(doc=1836)
          0.16128148 = weight(abstract_txt:entity in 1836) [ClassicSimilarity], result of:
            0.16128148 = score(doc=1836,freq=1.0), product of:
              0.2704371 = queryWeight, product of:
                3.4239712 = boost
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.012416214 = queryNorm
              0.5963734 = fieldWeight in 1836, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.361316 = idf(docFreq=196, maxDocs=41962)
                0.09375 = fieldNorm(doc=1836)
          0.49956146 = weight(abstract_txt:errors in 1836) [ClassicSimilarity], result of:
            0.49956146 = score(doc=1836,freq=2.0), product of:
              0.57464886 = queryWeight, product of:
                7.058513 = boost
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                0.012416214 = queryNorm
              0.86933345 = fieldWeight in 1836, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                6.5569234 = idf(docFreq=161, maxDocs=41962)
                0.09375 = fieldNorm(doc=1836)
        0.16666667 = coord(4/24)