George Mason University
Department of Computer Science
CS-450: Database Concepts
Fall 2008 --- Prof. Ami Motro
This course covers basic and intermediate knowledge on the design,
implementation and use of relational database systems. The main topics
include the Entity-Relationship (ER) and Enhanced Entity-Relationship (EER)
models for database design, the relational algebra, Structured Query Language
(SQL), SQL programming techniques, functional dependencies and normalization,
object and object-relational databases, and database security. Students will
practice the design, development and implementation of a relational database
in the Oracle ssystem, and use the database for queries, transaction
processing and report generation.
- Knowledge of fundamental concepts of file and database management.
- Knowledge of database design principles, and ability to model real-world
environments using the ER/EER 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 Boyce-Codd Normal Form.
Experience in the complete database creative process: from database design,
to database constuction, to database programming.
Grade of C or better in CS-310 (Data Structures) and CS-330 (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!
Two exams and about eight homework assignments and proijects, some
involving computer work (approximate weights are indicated in
Homework assignments (30%)
Midterm exam (30%)
Final exam (40%)
Fundamentals of Database Systems (5th Edition)
by Elmasri and Navathe, Addison-Wesley, 2006.
Oracle 9i Programming: A Primer
by Sunderraman, Addison-Wesley, 2003.
Dr. Ami Motro
Office: S&T2-455, Telephone: 993-1665
Email: email@example.com, http://www.ise.gmu.edu/
Office hours: Tuesday and Thursday 3:00-4:00
Tuesday and Thursday, 1:30-2:45, IN-134