
Course Outcomes

 Knowledge of fundamental concepts of file and database management.
 Knowledge of database design principles, and ability to model realworld
environments using the ER model.
 Knowledge of the formal principles of the relational database model and
its query languages, and ability to design relational databases and express
queries in the relational algebra and calculus.
 Knowledge of the Structured Query Language (SQL) and database programming
principles, and ability to author SQL queries and implement Java database
applications using the Oracle database system.

Knowledge of the basic principles of the mathematical theory of database
design, and ability to design databases that adhere to BoyceCodd Normal Form.

Experience in the complete database creative process: from database design,
to database constuction, to database programming.

Prerequisites

Grade of C or better in CS310 (Data Structures) and CS330 (Formal
Methods and Models). Specifically: good background in discrete
mathematics (e.g., set theory and mathematical logic), programming
(good knowledge of C or Java), data structures and algorithms, and
computer architecture and operating systems.
Note: prerequisites are strictly enforced!

Requirements

Two exams and about eight homework assignments and proijects, some
involving computer work (approximate weights are indicated in
parenthesis):

Homework assignments (30%)

Midterm exam (30%)

Final exam (40%)

Textbooks

The first book is required, the second is recommended.

Database Systems: An ApplicationOriented Approach, Introductory Version,
2/E, 2005
by Lewis, Kifer & Bernstein

Oracle 10g Programming: A Primer
by Sunderraman, AddisonWesley, 2008.

Instructor

Dr. Ami Motro
Office: Engineering4415, Telephone: 9931665
Email: ami@gmu.edu, http://www.cs.gmu.edu/~
ami
Office hours: Tuesday and Wednesday 3:004:00

Teaching Assistant

To be announced.

Meeting

Tuesday and Thursday, 1:302:45, IN134