\documentstyle[11pt,fleqn]{article}    % Specifies the document style.
\setlength{\textwidth} {6 in}
\setlength{\textheight} {8.5 in}
\setlength{\topmargin} {-0.7 in}
\setlength{\oddsidemargin} {0.25 in}
\setlength{\evensidemargin} {0.25 in}
\setlength{\columnsep} {.33 in}
\pagestyle{empty}
%\setlength{\mathindent} {0 cm}

%-------------------- DEFINITION -------------------------

\newtheorem{example}{Example}
% \newtheorem{fact}{Fact}

\newcounter{numtheorem}
\setcounter{numtheorem}{0}

\newenvironment{proof}{\vspace{0.2cm} \noindent 
{\bf Proof:} \addtocounter{numproof}{1}}{}

\title{Databases: Theory and Applications \\
01:198:436, Fall 1995}

\author{Meets at: SEC-209, TTh 7:40--9.00 pm}

                           % The preamble begins here.
\begin{document}           % End of preamble and beginning of text.


\date{}
\maketitle                 

\noindent
{\large \bf Instructor}
\vspace{-0.15in}
\begin{quote} \vspace{0.1cm}

Sesh Venugopal - 445-2002, e-mail: venugopa@cs.rutgers.edu. \\
Office - Hill 379, Office Hours: MTh 6:15--7:15 pm.
\end{quote}

\noindent
{\large \bf TA}  
\vspace{-0.15in}
\begin{quote} \vspace{0.1cm}
Adrian Dumitrescu (dumitres@paul)\\
\end{quote}

\noindent
{\large \bf Course Description}
\vspace{-0.15in}
\begin{quote} \vspace{0.1cm}

The purpose of the course is to provide students with an understanding of the basic concepts underlying the design and use of a database system.
A database management system will be used as a vehicle for illustrating some of the concepts discussed in the course.
\end{quote}

\noindent
{\large \bf Textbook}
\vspace{-0.15in}
\begin{quote} \vspace{0.1cm}

Korth, H. and Silberschatz, A., {\it Database System Concepts}, 2$^{nd}$ edition, McGraw-Hill Book Company, 1991.
\end{quote}

\noindent
{\large \bf Reference Texts}
\vspace{-0.15in}
\begin{quote}  \vspace{0.1cm}

Elmasri, R. and Navathe, S.B., {\it Fundamentals of Database Systems}, \\ Benjamin/Cummings Publishing Company, 1992.
\end{quote}

\noindent
{\large \bf Expected Work}
\vspace{-0.15in}
\begin{quote} \vspace{0.1cm}

Homework Assignments: 15\% \\
Group Project: 25\% \\
Two Hourly Exams: 30\% ; Final Exam: 30\%
\end{quote}

\begin{quote}
The project consists of the design and implementation of a database 
application of your choice using the SYBASE database system.
It is divided into 3 parts.
\begin{itemize}
\item In the first part, choose a non-trivial application 
and model it by stating the requirements and using an E-R diagram. 
\item In the second part, implement the relational model based on the E-R 
diagram of the first part. 
\item In the final part, implement the application in SYBASE.
\end{itemize}
\end{quote}

\newpage
\begin{tabular}{llr}
\underline{\large \bf Date} & \underline{\large \bf Topic} & 
\underline{\large \bf Text (K \& S)} \\
\\
Sep 5 & Introduction to Databases & Chapter 1 \\
Sep 7 & Database System Architecture & Chapter 1 \\
\hline \\
Sep 12 & Entity-Relationship Model & 2.1--2.5 \\
Sep 14 & E-R Model and Diagrams & 2.6--2.10 \\
\hline \\
Sep 19 & Relational Model, Relational Algebra & 3.1--3.2 \\
Sep 21 & Relational Algebra & 3.2 \\
\\
& {\bf PROJECT Handed Out} & \\
\hline \\
Sep 26 & Tuple Relational Calculus & 3.3 \\
Sep 27 & Domain Relational Calculus, Database modification & 3.4--3.5 \\
\hline \\
Oct 3 & Views, SQL & 3.6, 4.1 \\
Oct 5 & SQL & 4.1 \\
\hline \\
Oct 10 & HOURLY EXAM 1 & \\
Oct 12 & Schema modification in SQL & 4.1 \\
\\
& {\bf PROJECT: E-R Design Due} & \\
\hline \\
Oct 17 & Integrity Constraints & 5.1--5.2 \\
Oct 19 & Relational Database Design & 6.1 \\
\hline \\
Oct 24 & Functional Dependencies & 5.3 \\
Oct 26 & Normal Forms & 6.2 \\
\hline \\
Oct 31 & Normalization using dependencies & 6.2 \\
Nov 2 & Crash Recovery & 10.1--10.3 \\
\\
& {\bf PROJECT: Relational Design Due} & \\
\hline \\
Nov 7 & Log-based recovery; Shadow Paging & 10.4--10.9 \\
Nov 9 & Concurrency Control, Serializability & 11.1--11.2 \\
\hline \\
Nov 14 & HOURLY EXAM 2 & \\
Nov 16 & Serializability, Locking protocols & 11.2--11.3 \\
\hline \\
Nov 21 & Timestamp protocols & 11.4 \\
\hline \\
Nov 28 & Validation techniques & 11.5 \\
Nov 30 \hspace{10mm} & Transaction management & 12.1--12.3\\
\hline \\
Dec 5 & Distributed Databases & 15.1--15.4 \\
Dec 7 & Semi-join; Distributed Recovery & 15.5--15.6 \\
\hline \\
Dec 12 & {\bf PROJECT: SYBASE Implementation Due} & \\
\end{tabular}

\end{document}