Newer
Older
Discussion_Papers / Papers / 1999 / 99-23 / Paper / dp9923ns.aux
\relax 
\citation{Smit:HC:1985}
\citation{Date:CJ:1995:IDS}
\citation{Smit:HC:1985}
\citation{Arms:WW:1974,Beer:C:1977,Date:CJ:1995:IDS}
\@writefile{toc}{\contentsline {section}{\numberline {1}Introduction}{1}}
\newlabel{Sec:SmithsMethod:Introduction}{{1}{1}}
\citation{Smit:HC:1985}
\@writefile{toc}{\contentsline {section}{\numberline {2}Overview of Smith's method}{2}}
\newlabel{Sec:SmithsMethod:Overview}{{2}{2}}
\@writefile{lof}{\contentsline {figure}{\numberline {1}{\ignorespaces Example of a dependency-list statement}}{2}}
\newlabel{Fig.SmithsMethod.DependencyListStatement}{{1}{2}}
\@writefile{toc}{\contentsline {subsection}{\numberline {2.1}Smith's FDD notation}{2}}
\newlabel{Sec:SmithsMethod:Overview:Notation}{{2.1}{2}}
\@writefile{lof}{\contentsline {figure}{\numberline {2}{\ignorespaces Attributes and bubbles}}{2}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(a)}{\ignorespaces }}{2}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(b)}{\ignorespaces }}{2}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{2(c)}{\ignorespaces }}{2}}
\newlabel{Fig.SmithsMethod.AttributesBubbles}{{2}{2}}
\citation{Smit:HC:1985}
\newlabel{Fig.SmithsMethod.Dependencies.Single}{{3(a)}{3}}
\newlabel{Fig.SmithsMethod.Dependencies.Multi}{{3(b)}{3}}
\@writefile{lof}{\contentsline {figure}{\numberline {3}{\ignorespaces Single- and multivalued dependencies}}{3}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{3(a)}{\ignorespaces \string\label{Fig.SmithsMethod.Dependencies.Single}}}{3}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{3(b)}{\ignorespaces \string\label{Fig.SmithsMethod.Dependencies.Multi}}}{3}}
\newlabel{Fig.SmithsMethod.Dependencies}{{3}{3}}
\newlabel{Fig.SmithsMethod.MultiFlags.Bubbles}{{4(a)}{3}}
\newlabel{Fig.SmithsMethod.MultiFlags.Flags}{{4(b)}{3}}
\@writefile{lof}{\contentsline {figure}{\numberline {4}{\ignorespaces Multiple bubbles and domain flags}}{3}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{4(a)}{\ignorespaces \string\label{Fig.SmithsMethod.MultiFlags.Bubbles}}}{3}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{4(b)}{\ignorespaces \string\label{Fig.SmithsMethod.MultiFlags.Flags}}}{3}}
\newlabel{Fig.SmithsMethod.MultiFlags}{{4}{3}}
\@writefile{toc}{\contentsline {subsection}{\numberline {2.2}Smith's method for deriving a set of relations from an FDD}{3}}
\newlabel{Sec:SmithsMethod:Overview:DerivingRelations}{{2.2}{3}}
\@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.1}Single-valued dependencies composed into relations}{3}}
\newlabel{1@xvr}{{}{3}}
\newlabel{1@vr}{{}{3}}
\citation{Smit:HC:1985}
\citation{Date:CJ:1995:IDS}
\citation{Smit:HC:1985}
\citation{Smit:HC:1985}
\@writefile{lof}{\contentsline {figure}{\numberline {5}{\ignorespaces Deriving a relation from a single-valued dependency}}{4}}
\newlabel{Fig.SmithsMethod.SVD}{{5}{4}}
\@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.2}End-key dependencies composed into relations}{4}}
\@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.3}Isolated bubbles composed into relations}{4}}
\@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.4}Practicable diagrams}{4}}
\@writefile{toc}{\contentsline {subsubsection}{\numberline {2.2.5}Additional guidelines}{4}}
\@writefile{lof}{\contentsline {figure}{\numberline {6}{\ignorespaces Deriving a relation from an end-key dependency}}{5}}
\newlabel{Fig.SmithsMethod.Endkey}{{6}{5}}
\@writefile{lof}{\contentsline {figure}{\numberline {7}{\ignorespaces Correcting an impracticable FDD}}{5}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{7(a)}{\ignorespaces Not practicable}}{5}}
\@writefile{lof}{\contentsline {subfigure}{\string\numberline{7(b)}{\ignorespaces Practicable}}{5}}
\newlabel{Fig.SmithsMethod.Practicable}{{7}{5}}
\citation{Smit:HC:1985}
\citation{Smit:HC:1985}
\citation{Smit:HC:1985}
\citation{Smit:HC:1985}
\citation{Date:CJ:1995:IDS}
\citation{Date:CJ:1995:IDS,Elma:R:1994}
\@writefile{toc}{\contentsline {section}{\numberline {3}Issues with deriving foreign keys}{6}}
\newlabel{Sec:SmithsMethod:FKProblem}{{3}{6}}
\@writefile{toc}{\contentsline {subsection}{\numberline {3.1}Non-derivable foreign keys}{6}}
\@writefile{lof}{\contentsline {figure}{\numberline {8}{\ignorespaces Foreign keys that cannot be derived using the existing rules}}{6}}
\newlabel{Fig.SmithsMethod.UnderivableFKs}{{8}{6}}
\@writefile{toc}{\contentsline {subsection}{\numberline {3.2}Invalid foreign keys}{6}}
\newlabel{2@xvr}{{}{6}}
\newlabel{2@vr}{{}{6}}
\citation{Stan:N:1997:ECIS97,Stan:N:1999:PhD}
\@writefile{lof}{\contentsline {figure}{\numberline {9}{\ignorespaces Derivation of invalid foreign keys}}{7}}
\newlabel{Fig.SmithsMethod.InvalidFKs}{{9}{7}}
\@writefile{toc}{\contentsline {subsection}{\numberline {3.3}Automation of the domain flag rule}{7}}
\@writefile{toc}{\contentsline {section}{\numberline {4}Proposed modifications}{7}}
\newlabel{Sec:SmithsMethod:Solution}{{4}{7}}
\@writefile{lof}{\contentsline {figure}{\numberline {10}{\ignorespaces `Target' attribute domain flag notation}}{8}}
\newlabel{Fig.SmithsMethod.DFSource}{{10}{8}}
\@writefile{toc}{\contentsline {section}{\numberline {5}Example}{8}}
\newlabel{Sec:SmithsMethod:Examples}{{5}{8}}
\newlabel{3@xvr}{{}{9}}
\newlabel{3@vr}{{}{9}}
\@writefile{lof}{\contentsline {figure}{\numberline {11}{\ignorespaces E-R description of the assessment marks viewpoint (normalised)}}{9}}
\newlabel{Fig.MarksERDNorm}{{11}{9}}
\newlabel{4@xvr}{{}{9}}
\newlabel{4@vr}{{}{9}}
\citation{Date:CJ:1995:IDS}
\@writefile{lof}{\contentsline {figure}{\numberline {12}{\ignorespaces Functional dependency description of the assessment marks viewpoint}}{10}}
\newlabel{Fig.MarksFDD}{{12}{10}}
\citation{Stan:N:1997:ECIS97,Stan:N:1997:DP9708,Stan:N:1997:APSEC97}
\bibstyle{dcu}
\bibdata{Baxter:Research:Biblio}
\harvardcite{Arms:WW:1974}{Armstrong}{Armstrong}{1974}
\harvardcite{Beer:C:1977}{Beeri, Fagin \harvardand \ Howard}{Beeri et~al.}{1977}
\harvardcite{Date:CJ:1995:IDS}{Date}{Date}{1995}
\harvardcite{Elma:R:1994}{Elmasri \harvardand \ Navathe}{Elmasri \harvardand \ Navathe}{1994}
\harvardcite{Smit:HC:1985}{Smith}{Smith}{1985}
\@writefile{toc}{\contentsline {section}{\numberline {6}Conclusion}{12}}
\newlabel{Sec:Conclusions}{{6}{12}}
\harvardcite{Stan:N:1999:PhD}{Stanger}{Stanger}{1999}
\harvardcite{Stan:N:1997:ECIS97}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997a}
\harvardcite{Stan:N:1997:DP9708}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997b}
\harvardcite{Stan:N:1997:APSEC97}{Stanger \harvardand \ Pascoe}{Stanger \harvardand \ Pascoe}{1997c}