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.874302 = sum of:
     5.874302 = weight(author_txt:bock in 7) [ClassicSimilarity], result of:
       5.874302 = fieldWeight in 7, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.398883 = idf(docFreq=9, maxDocs=44421)
         0.625 = fieldNorm(doc=7)
   

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

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

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

   5.874302 = sum of:
     5.874302 = weight(author_txt:bock in 2374) [ClassicSimilarity], result of:
       5.874302 = fieldWeight in 2374, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.398883 = idf(docFreq=9, maxDocs=44421)
         0.625 = fieldNorm(doc=2374)
   

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

   5.874302 = sum of:
     5.874302 = weight(author_txt:bock in 5251) [ClassicSimilarity], result of:
       5.874302 = fieldWeight in 5251, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.398883 = idf(docFreq=9, maxDocs=44421)
         0.625 = fieldNorm(doc=5251)
   

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

   4.6994414 = sum of:
     4.6994414 = weight(author_txt:bock in 762) [ClassicSimilarity], result of:
       4.6994414 = fieldWeight in 762, product of:
         1.0 = tf(freq=1.0), with freq of:
           1.0 = termFreq=1.0
         9.398883 = idf(docFreq=9, maxDocs=44421)
         0.5 = fieldNorm(doc=762)
   

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.2835619 = sum of:
     0.2835619 = product of:
       0.9722122 = sum of:
         0.012876559 = weight(abstract_txt:different in 3004) [ClassicSimilarity], result of:
           0.012876559 = score(doc=3004,freq=1.0), product of:
             0.045036063 = queryWeight, product of:
               3.6597328 = idf(docFreq=3107, maxDocs=44421)
               0.012305833 = queryNorm
             0.28591663 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.6597328 = idf(docFreq=3107, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.013828661 = weight(abstract_txt:they in 3004) [ClassicSimilarity], result of:
           0.013828661 = score(doc=3004,freq=1.0), product of:
             0.047229566 = queryWeight, product of:
               1.0240632 = boost
               3.7477977 = idf(docFreq=2845, maxDocs=44421)
               0.012305833 = queryNorm
             0.2927967 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.7477977 = idf(docFreq=2845, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.035246797 = weight(abstract_txt:structures in 3004) [ClassicSimilarity], result of:
           0.035246797 = score(doc=3004,freq=1.0), product of:
             0.08812659 = queryWeight, product of:
               1.3988569 = boost
               5.1194425 = idf(docFreq=721, maxDocs=44421)
               0.012305833 = queryNorm
             0.39995643 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.1194425 = idf(docFreq=721, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.089567356 = weight(abstract_txt:relationship in 3004) [ClassicSimilarity], result of:
           0.089567356 = score(doc=3004,freq=2.0), product of:
             0.16410698 = queryWeight, product of:
               2.699593 = boost
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.012305833 = queryNorm
             0.5457864 = fieldWeight in 3004, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.12963586 = weight(abstract_txt:entity in 3004) [ClassicSimilarity], result of:
           0.12963586 = score(doc=3004,freq=1.0), product of:
             0.26455784 = queryWeight, product of:
               3.4276392 = boost
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.012305833 = queryNorm
             0.49000952 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.3960226 = weight(abstract_txt:modelling in 3004) [ClassicSimilarity], result of:
           0.3960226 = score(doc=3004,freq=3.0), product of:
             0.4420864 = queryWeight, product of:
               5.426677 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.012305833 = queryNorm
             0.8958036 = fieldWeight in 3004, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
         0.29503438 = weight(abstract_txt:errors in 3004) [ClassicSimilarity], result of:
           0.29503438 = score(doc=3004,freq=1.0), product of:
             0.57671636 = queryWeight, product of:
               7.1569986 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.012305833 = queryNorm
             0.51157624 = fieldWeight in 3004, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.078125 = fieldNorm(doc=3004)
       0.29166666 = coord(7/24)
   

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

   0.1728239 = sum of:
     0.1728239 = product of:
       0.6912956 = sum of:
         0.034740627 = weight(abstract_txt:result in 781) [ClassicSimilarity], result of:
           0.034740627 = score(doc=781,freq=1.0), product of:
             0.08728085 = queryWeight, product of:
               1.3921283 = boost
               5.0948176 = idf(docFreq=739, maxDocs=44421)
               0.012305833 = queryNorm
             0.39803264 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.0948176 = idf(docFreq=739, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.040122 = weight(abstract_txt:outlines in 781) [ClassicSimilarity], result of:
           0.040122 = score(doc=781,freq=1.0), product of:
             0.096076146 = queryWeight, product of:
               1.4605875 = boost
               5.34536 = idf(docFreq=575, maxDocs=44421)
               0.012305833 = queryNorm
             0.41760623 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.34536 = idf(docFreq=575, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.11488912 = weight(abstract_txt:normalization in 781) [ClassicSimilarity], result of:
           0.11488912 = score(doc=781,freq=1.0), product of:
             0.19373725 = queryWeight, product of:
               2.074084 = boost
               7.590594 = idf(docFreq=60, maxDocs=44421)
               0.012305833 = queryNorm
             0.59301513 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.590594 = idf(docFreq=60, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.089567356 = weight(abstract_txt:relationship in 781) [ClassicSimilarity], result of:
           0.089567356 = score(doc=781,freq=2.0), product of:
             0.16410698 = queryWeight, product of:
               2.699593 = boost
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.012305833 = queryNorm
             0.5457864 = fieldWeight in 781, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.1833328 = weight(abstract_txt:entity in 781) [ClassicSimilarity], result of:
           0.1833328 = score(doc=781,freq=2.0), product of:
             0.26455784 = queryWeight, product of:
               3.4276392 = boost
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.012305833 = queryNorm
             0.69297814 = fieldWeight in 781, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
         0.22864373 = weight(abstract_txt:modelling in 781) [ClassicSimilarity], result of:
           0.22864373 = score(doc=781,freq=1.0), product of:
             0.4420864 = queryWeight, product of:
               5.426677 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.012305833 = queryNorm
             0.5171924 = fieldWeight in 781, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=781)
       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.16999963 = sum of:
     0.16999963 = product of:
       0.6799985 = sum of:
         0.019556679 = weight(abstract_txt:they in 6764) [ClassicSimilarity], result of:
           0.019556679 = score(doc=6764,freq=2.0), product of:
             0.047229566 = queryWeight, product of:
               1.0240632 = boost
               3.7477977 = idf(docFreq=2845, maxDocs=44421)
               0.012305833 = queryNorm
             0.41407704 = fieldWeight in 6764, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               3.7477977 = idf(docFreq=2845, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
         0.03670911 = weight(abstract_txt:models in 6764) [ClassicSimilarity], result of:
           0.03670911 = score(doc=6764,freq=2.0), product of:
             0.07186759 = queryWeight, product of:
               1.2632414 = boost
               4.623126 = idf(docFreq=1185, maxDocs=44421)
               0.012305833 = queryNorm
             0.5107881 = fieldWeight in 6764, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.623126 = idf(docFreq=1185, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
         0.034740627 = weight(abstract_txt:result in 6764) [ClassicSimilarity], result of:
           0.034740627 = score(doc=6764,freq=1.0), product of:
             0.08728085 = queryWeight, product of:
               1.3921283 = boost
               5.0948176 = idf(docFreq=739, maxDocs=44421)
               0.012305833 = queryNorm
             0.39803264 = fieldWeight in 6764, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.0948176 = idf(docFreq=739, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
         0.06333369 = weight(abstract_txt:relationship in 6764) [ClassicSimilarity], result of:
           0.06333369 = score(doc=6764,freq=1.0), product of:
             0.16410698 = queryWeight, product of:
               2.699593 = boost
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.012305833 = queryNorm
             0.3859293 = fieldWeight in 6764, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
         0.12963586 = weight(abstract_txt:entity in 6764) [ClassicSimilarity], result of:
           0.12963586 = score(doc=6764,freq=1.0), product of:
             0.26455784 = queryWeight, product of:
               3.4276392 = boost
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.012305833 = queryNorm
             0.49000952 = fieldWeight in 6764, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
         0.3960226 = weight(abstract_txt:modelling in 6764) [ClassicSimilarity], result of:
           0.3960226 = score(doc=6764,freq=3.0), product of:
             0.4420864 = queryWeight, product of:
               5.426677 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.012305833 = queryNorm
             0.8958036 = fieldWeight in 6764, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=6764)
       0.25 = coord(6/24)
   

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

   0.1535142 = sum of:
     0.1535142 = product of:
       0.9210852 = sum of:
         0.023385871 = weight(abstract_txt:types in 177) [ClassicSimilarity], result of:
           0.023385871 = score(doc=177,freq=1.0), product of:
             0.06703932 = queryWeight, product of:
               1.2200695 = boost
               4.4651284 = idf(docFreq=1388, maxDocs=44421)
               0.012305833 = queryNorm
             0.34883815 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.4651284 = idf(docFreq=1388, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.06333369 = weight(abstract_txt:relationship in 177) [ClassicSimilarity], result of:
           0.06333369 = score(doc=177,freq=1.0), product of:
             0.16410698 = queryWeight, product of:
               2.699593 = boost
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.012305833 = queryNorm
             0.3859293 = fieldWeight in 177, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.3233511 = weight(abstract_txt:modelling in 177) [ClassicSimilarity], result of:
           0.3233511 = score(doc=177,freq=2.0), product of:
             0.4420864 = queryWeight, product of:
               5.426677 = boost
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.012305833 = queryNorm
             0.7314206 = fieldWeight in 177, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.6200633 = idf(docFreq=160, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
         0.5110145 = weight(abstract_txt:errors in 177) [ClassicSimilarity], result of:
           0.5110145 = score(doc=177,freq=3.0), product of:
             0.57671636 = queryWeight, product of:
               7.1569986 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.012305833 = queryNorm
             0.88607603 = fieldWeight in 177, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.078125 = fieldNorm(doc=177)
       0.16666667 = coord(4/24)
   

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

   0.13277099 = sum of:
     0.13277099 = product of:
       0.79662585 = sum of:
         0.06437239 = weight(abstract_txt:understand in 1422) [ClassicSimilarity], result of:
           0.06437239 = score(doc=1422,freq=2.0), product of:
             0.0925471 = queryWeight, product of:
               1.4335115 = boost
               5.246269 = idf(docFreq=635, maxDocs=44421)
               0.012305833 = queryNorm
             0.69556355 = fieldWeight in 1422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               5.246269 = idf(docFreq=635, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.07600042 = weight(abstract_txt:relationship in 1422) [ClassicSimilarity], result of:
           0.07600042 = score(doc=1422,freq=1.0), product of:
             0.16410698 = queryWeight, product of:
               2.699593 = boost
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.012305833 = queryNorm
             0.46311513 = fieldWeight in 1422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9398947 = idf(docFreq=863, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.15556304 = weight(abstract_txt:entity in 1422) [ClassicSimilarity], result of:
           0.15556304 = score(doc=1422,freq=1.0), product of:
             0.26455784 = queryWeight, product of:
               3.4276392 = boost
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.012305833 = queryNorm
             0.58801144 = fieldWeight in 1422, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.272122 = idf(docFreq=227, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
         0.50069 = weight(abstract_txt:errors in 1422) [ClassicSimilarity], result of:
           0.50069 = score(doc=1422,freq=2.0), product of:
             0.57671636 = queryWeight, product of:
               7.1569986 = boost
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.012305833 = queryNorm
             0.86817366 = fieldWeight in 1422, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.548176 = idf(docFreq=172, maxDocs=44421)
               0.09375 = fieldNorm(doc=1422)
       0.16666667 = coord(4/24)