\relax \bibstyle{plain} \@writefile{toc}{\contentsline {paragraph}{Database query language.}{1}} \@writefile{toc}{\contentsline {paragraph}{Relational Algebra.}{1}} \@writefile{toc}{\contentsline {paragraph}{The operators of the relational algebra:}{1}} \@writefile{toc}{\contentsline {paragraph}{Set operators}{1}} \@writefile{toc}{\contentsline {paragraph}{Union ($\cup $):}{1}} \@writefile{toc}{\contentsline {paragraph}{Set difference ($-$):}{1}} \@writefile{toc}{\contentsline {paragraph}{Intersection ($\cap $)}{1}} \@writefile{toc}{\contentsline {paragraph}{Note:}{1}} \newlabel{e1}{{1}{1}} \@writefile{toc}{\contentsline {paragraph}{Operators that remove part of the relation}{2}} \@writefile{toc}{\contentsline {paragraph}{Projection ($\pi $)}{2}} \@writefile{toc}{\contentsline {paragraph}{Selection ($\sigma $)}{2}} \@writefile{toc}{\contentsline {paragraph}{Operators that combine relations}{2}} \@writefile{toc}{\contentsline {paragraph}{Cartesian Product ($\times $)}{3}} \newlabel{e2}{{2}{3}} \@writefile{toc}{\contentsline {paragraph}{Join}{4}} \newlabel{e3}{{3}{4}} \@writefile{toc}{\contentsline {paragraph}{Special cases:}{4}} \@writefile{toc}{\contentsline {paragraph}{Join is a derived operator}{4}} \@writefile{toc}{\contentsline {paragraph}{Renaming ($\rho $):}{5}} \newlabel{e4}{{4}{5}} \@writefile{toc}{\contentsline {paragraph}{Outer-, Left Outer-, and Right Outer-join}{5}} \newlabel{e5}{{5}{5}} \@writefile{toc}{\contentsline {paragraph}{Division operator}{6}} \newlabel{e5}{{6}{6}} \@writefile{toc}{\contentsline {paragraph}{Combining Operations to Form Queries}{6}} \@writefile{toc}{\contentsline {paragraph}{Simple SQL queries.}{7}} \@writefile{toc}{\contentsline {paragraph}{What is important?}{7}} \@writefile{toc}{\contentsline {paragraph}{Aggregations in SQL.}{7}} \@writefile{toc}{\contentsline {paragraph}{What is important?}{7}} \@writefile{toc}{\contentsline {paragraph}{General SQL queries.}{7}} \@writefile{toc}{\contentsline {paragraph}{View.}{7}} \@writefile{toc}{\contentsline {paragraph}{Modifying relation instance.}{8}}