\documentstyle [12pt]{article}
\setlength{\oddsidemargin}{-.4cm}
\setlength{\topmargin}{-2cm}
\setlength{\headheight}{0cm}
\setlength{\textheight}{24.5cm}
\setlength{\textwidth}{17.3cm}
\setlength{\topskip}{0cm}
\setlength{\parindent}{0cm}
\setlength{\parskip}{.15in}
%
\pagestyle{plain}
\begin{document}
\vspace*{-.5cm}

\begin{minipage}[b]{19mm}
\setlength{\unitlength}{.4mm}
\begin{picture}(45,30)(-22.5,-15)
\thicklines
%
\put(0,0){\circle{15}}
%
\thinlines
\put( 7.5,  0){\oval(30,30)[t]}
\put( 7.5,-15){\line(1,0){15}}
\put( 7.5,-15){\line(0,1){15}}
\put(22.5,-15){\line(0,1){15}}
%
\put( -7.5, 0){\oval(30,30)[b]}
\put( -7.5,15){\line(-1,0){15}}
\put( -7.5,15){\line(0,-1){15}}
\put(-22.5,15){\line(0,-1){15}}
%
\end{picture}
\end{minipage}
\begin{minipage}[b]{6cm}
\footnotesize \sf
Computer Science and Engineering
\\
Ferguson Hall -- 0115
\\
472-2402
\end{minipage}
\hfill
\begin{minipage}[b]{8cm}
\begin{flushright}
\LARGE \bf
Course Specification\vspace*{3mm}
\end{flushright}
\end {minipage}
\vspace{.2cm}
{\bf \hrule}
\vspace{.5cm}

%------------------------------------------------------------------------
% NOTES TO USERS: 
%
% 1. Underlined text in this form is notes to you; please delete them.
%
% 2. DO NOT UNDERLINE your replacement text.
%
% 3. Try to observe the prescribed page-break, if at all possible.
%
%------------------------------------------------------------------------

{\Large \bf \begin{center} CSCE-413\\
Database Systems
\end{center} }

\paragraph{Catalogue Description:}~ \newline
413/813. Database Systems (3 cr) Prereq: CSCE 310. Data and storage
models for database systems; entity/relationship, relational,
and constraint models; Relational databases: relational algebra
and calculus, query languages; Logical database design: normalization,
concurrency, integrity, recovery, and security issues; 
Hands-on experience with a working database system.

\paragraph{Current Catalogue Description!}~ \newline
413/813. Database Systems (3 cr) Prereq: CSCE 310.
Data and storage models for database systems;
entity/relationship, relational, hierarchical, and network models;
hierarchical databases and their access operations.  Network databases and
their access operations.  Relational databases; relational algebra and
calculus; inquiry languages; normalization.  Logical database design.
Concurrency, integrity, and security issues.  Distributed systems.
Hands-on experience with a working database system.


\paragraph{Textbook(s) and/or Other Required Materials:}~ \newline
Silbershatz, Korth, Sudarshan, {\em Database System Concepts}, third
edition, McGraw-Hill.

\paragraph{Prerequisites by Topic:}
\begin{itemize}
\item {\bf Mastery} of a high level language, elementary data
structures and searching/sorting algorithms, indexing and hashing techniques.
\item {\bf Familiarity} with computer organization, discrete structures
including set theory and propositional logic, file structures.
\item {\bf Exposure} to concurrent execution.
\end{itemize}

\paragraph{Course Objectives:}
\begin{itemize}
\item {\bf Mastery} of entity-relationship model, relational model.
\item {\bf Familiarity} with a query language, integrity constraints,
  relational database design, transactions, concurrency control, recovery.
\item {\bf Exposure} to constraint databases, database sytem
  architectures and distributed databases.
\end{itemize}

\vfill
{\small ~ \hfill  \today}
\newpage
\paragraph{Topics Covered:}~ \newline
Prgramming projects will entail implementation details of database
concepts and experience with an existing database system.
\begin{enumerate}
\item Entity-Relationship model.
\item Relational model - relational algebra, tuple/domain relational
  calculus.
\item SQL - syntax and use, embedded SQL, alternative relational languages.
\item Integrity constraints - domain, referential, functional dependencies.
\item Relational database design - decomposition, normalization.
\item Geographic Information Systems.
\item Query processing - techniques and costs.
\item Transactions - concurrency, serializability, recoverability.
\item Concurrency control - lock/timestamp/validation-based protocols.
\item Recovery systems - log-based, shadow paging.
\item Database system architectures and distributed databases.
\end{enumerate}

%\paragraph{Relationship of Course to Program Objectives:}~ \newline
%\underline{{\bf Ignore for Fall 1998}. Details will 
%be firmed up during Spring 1998 Semester.}


%\paragraph{Contribution of Course to Meeting the Professional Component:}~ \newline
%\underline{{\bf Ignore for Fall 1998}. Details will 
%be firmed up during Spring 1998 Semester.}


\paragraph{Class/Laboratory Schedule:}~ \newline
Lecture: 45 hours

\paragraph{Prepared by:}~ \newline
Charles Riedesel, Senior Lecturer

\end{document}


