Newer
Older
Discussion_Papers / Papers / 1999 / 99-23 / Paper / dp9923ns.aux
  1. \relax
  2. \citation{Smit:HC:1985}
  3. \citation{Date:CJ:1995:IDS}
  4. \citation{Smit:HC:1985}
  5. \citation{Arms:WW:1974,Beer:C:1977,Date:CJ:1995:IDS}
  6. \@writefile{toc}{\contentsline {section}{\numberline {1}Introduction}{1}}
  7. \newlabel{Sec:SmithsMethod:Introduction}{{1}{1}}
  8. \citation{Smit:HC:1985}
  9. \@writefile{toc}{\contentsline {section}{\numberline {2}Overview of Smith's method}{2}}
  10. \newlabel{Sec:SmithsMethod:Overview}{{2}{2}}
  11. \@writefile{lof}{\contentsline {figure}{\numberline {1}{\ignorespaces Example of a dependency-list statement}}{2}}
  12. \newlabel{Fig.SmithsMethod.DependencyListStatement}{{1}{2}}
  13. \@writefile{toc}{\contentsline {subsection}{\numberline {2.1}Smith's FDD notation}{2}}
  14. \newlabel{Sec:SmithsMethod:Overview:Notation}{{2.1}{2}}
  15. \@writefile{lof}{\contentsline {figure}{\numberline {2}{\ignorespaces Attributes and bubbles}}{2}}
  16. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(a)}{\ignorespaces }}{2}}
  17. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(b)}{\ignorespaces }}{2}}
  18. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(c)}{\ignorespaces }}{2}}
  19. \newlabel{Fig.SmithsMethod.AttributesBubbles}{{2}{2}}
  20. \citation{Smit:HC:1985}
  21. \newlabel{Fig.SmithsMethod.Dependencies.Single}{{3(a)}{3}}
  22. \newlabel{Fig.SmithsMethod.Dependencies.Multi}{{3(b)}{3}}
  23. \@writefile{lof}{\contentsline {figure}{\numberline {3}{\ignorespaces Single- and multivalued dependencies}}{3}}
  24. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{3(a)}{\ignorespaces \string\label{Fig.SmithsMethod.Dependencies.Single}}}{3}}
  25. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{3(b)}{\ignorespaces \string\label{Fig.SmithsMethod.Dependencies.Multi}}}{3}}
  26. \newlabel{Fig.SmithsMethod.Dependencies}{{3}{3}}
  27. \newlabel{Fig.SmithsMethod.MultiFlags.Bubbles}{{4(a)}{3}}
  28. \newlabel{Fig.SmithsMethod.MultiFlags.Flags}{{4(b)}{3}}
  29. \@writefile{lof}{\contentsline {figure}{\numberline {4}{\ignorespaces Multiple bubbles and domain flags}}{3}}
  30. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{4(a)}{\ignorespaces \string\label{Fig.SmithsMethod.MultiFlags.Bubbles}}}{3}}
  31. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{4(b)}{\ignorespaces \string\label{Fig.SmithsMethod.MultiFlags.Flags}}}{3}}
  32. \newlabel{Fig.SmithsMethod.MultiFlags}{{4}{3}}
  33. \@writefile{toc}{\contentsline {subsection}{\numberline {2.2}Smith's method for deriving a set of relations from an FDD}{3}}
  34. \newlabel{Sec:SmithsMethod:Overview:DerivingRelations}{{2.2}{3}}
  35. \@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.1}Single-valued dependencies composed into relations}{3}}
  36. \newlabel{1@xvr}{{}{3}}
  37. \newlabel{1@vr}{{}{3}}
  38. \citation{Smit:HC:1985}
  39. \citation{Date:CJ:1995:IDS}
  40. \citation{Smit:HC:1985}
  41. \citation{Smit:HC:1985}
  42. \@writefile{lof}{\contentsline {figure}{\numberline {5}{\ignorespaces Deriving a relation from a single-valued dependency}}{4}}
  43. \newlabel{Fig.SmithsMethod.SVD}{{5}{4}}
  44. \@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.2}End-key dependencies composed into relations}{4}}
  45. \@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.3}Isolated bubbles composed into relations}{4}}
  46. \@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.4}Practicable diagrams}{4}}
  47. \@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.5}Additional guidelines}{4}}
  48. \@writefile{lof}{\contentsline {figure}{\numberline {6}{\ignorespaces Deriving a relation from an end-key dependency}}{5}}
  49. \newlabel{Fig.SmithsMethod.Endkey}{{6}{5}}
  50. \@writefile{lof}{\contentsline {figure}{\numberline {7}{\ignorespaces Correcting an impracticable FDD}}{5}}
  51. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{7(a)}{\ignorespaces Not practicable}}{5}}
  52. \@writefile{lof}{\contentsline {subfigure}{\string\numberline{7(b)}{\ignorespaces Practicable}}{5}}
  53. \newlabel{Fig.SmithsMethod.Practicable}{{7}{5}}
  54. \citation{Smit:HC:1985}
  55. \citation{Smit:HC:1985}
  56. \citation{Smit:HC:1985}
  57. \citation{Smit:HC:1985}
  58. \citation{Date:CJ:1995:IDS}
  59. \citation{Date:CJ:1995:IDS,Elma:R:1994}
  60. \@writefile{toc}{\contentsline {section}{\numberline {3}Issues with deriving foreign keys}{6}}
  61. \newlabel{Sec:SmithsMethod:FKProblem}{{3}{6}}
  62. \@writefile{toc}{\contentsline {subsection}{\numberline {3.1}Non-derivable foreign keys}{6}}
  63. \@writefile{lof}{\contentsline {figure}{\numberline {8}{\ignorespaces Foreign keys that cannot be derived using the existing rules}}{6}}
  64. \newlabel{Fig.SmithsMethod.UnderivableFKs}{{8}{6}}
  65. \@writefile{toc}{\contentsline {subsection}{\numberline {3.2}Invalid foreign keys}{6}}
  66. \newlabel{2@xvr}{{}{6}}
  67. \newlabel{2@vr}{{}{6}}
  68. \citation{Stan:N:1997:ECIS97,Stan:N:1999:PhD}
  69. \@writefile{lof}{\contentsline {figure}{\numberline {9}{\ignorespaces Derivation of invalid foreign keys}}{7}}
  70. \newlabel{Fig.SmithsMethod.InvalidFKs}{{9}{7}}
  71. \@writefile{toc}{\contentsline {subsection}{\numberline {3.3}Automation of the domain flag rule}{7}}
  72. \@writefile{toc}{\contentsline {section}{\numberline {4}Proposed modifications}{7}}
  73. \newlabel{Sec:SmithsMethod:Solution}{{4}{7}}
  74. \@writefile{lof}{\contentsline {figure}{\numberline {10}{\ignorespaces `Target' attribute domain flag notation}}{8}}
  75. \newlabel{Fig.SmithsMethod.DFSource}{{10}{8}}
  76. \@writefile{toc}{\contentsline {section}{\numberline {5}Example}{8}}
  77. \newlabel{Sec:SmithsMethod:Examples}{{5}{8}}
  78. \newlabel{3@xvr}{{}{9}}
  79. \newlabel{3@vr}{{}{9}}
  80. \@writefile{lof}{\contentsline {figure}{\numberline {11}{\ignorespaces E-R description of the assessment marks viewpoint (normalised)}}{9}}
  81. \newlabel{Fig.MarksERDNorm}{{11}{9}}
  82. \newlabel{4@xvr}{{}{9}}
  83. \newlabel{4@vr}{{}{9}}
  84. \citation{Date:CJ:1995:IDS}
  85. \@writefile{lof}{\contentsline {figure}{\numberline {12}{\ignorespaces Functional dependency description of the assessment marks viewpoint}}{10}}
  86. \newlabel{Fig.MarksFDD}{{12}{10}}
  87. \citation{Stan:N:1997:ECIS97,Stan:N:1997:DP9708,Stan:N:1997:APSEC97}
  88. \bibstyle{dcu}
  89. \bibdata{Baxter:Research:Biblio}
  90. \harvardcite{Arms:WW:1974}{Armstrong}{Armstrong}{1974}
  91. \harvardcite{Beer:C:1977}{Beeri, Fagin \harvardand \ Howard}{Beeri et~al.}{1977}
  92. \harvardcite{Date:CJ:1995:IDS}{Date}{Date}{1995}
  93. \harvardcite{Elma:R:1994}{Elmasri \harvardand \ Navathe}{Elmasri \harvardand \ Navathe}{1994}
  94. \harvardcite{Smit:HC:1985}{Smith}{Smith}{1985}
  95. \@writefile{toc}{\contentsline {section}{\numberline {6}Conclusion}{12}}
  96. \newlabel{Sec:Conclusions}{{6}{12}}
  97. \harvardcite{Stan:N:1999:PhD}{Stanger}{Stanger}{1999}
  98. \harvardcite{Stan:N:1997:ECIS97}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997a}
  99. \harvardcite{Stan:N:1997:DP9708}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997b}
  100. \harvardcite{Stan:N:1997:APSEC97}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997c}