-
Course Outcomes
-
- Knowledge of fundamental concepts of file and database management.
- Knowledge of database design principles, and ability to model real-world
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 Boyce-Codd 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 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!
-
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 Application-Oriented Approach, Introductory Version,
2/E, 2005
by Lewis, Kifer & Bernstein
-
Oracle 10g Programming: A Primer
by Sunderraman, Addison-Wesley, 2008.
-
Instructor
-
Dr. Ami Motro
Office: Engineering-4415, Telephone: 993-1665
Email: ami@gmu.edu, http://www.cs.gmu.edu/~
ami
Office hours: Tuesday and Wednesday 3:00-4:00
-
Teaching Assistant
-
To be announced.
-
Meeting
-
Tuesday and Thursday, 1:30-2:45, IN-134