-
Time and place
-
Thursday, 4:30-7:10 pm
Innovation Hall 204
-
Instructor availability
-
Office: ENG-4415
Telephone: 703-993-1665
Email: ami@gmu.edu
Web: http://cs.gmu.edu/~ami
Office hours: Wednesday and Thursday, 3:00-4:00 pm
-
Description
-
An introduction to database management with focus on architecting databases
and using them in applications. Topics to be covered include: data modeling
with the Entity-Relationship model; the relational model and its formal
languages; SQL and application programming and protocols; the theory of
database design; object databases; and XML and Web data.
-
Approximate class schedule
-
-
Course administration; Introduction to database systems
-
Conceptual modeling with E-R diagrams
-
Conceptual modeling with E-R diagrams - advanced concepts
-
The relational model - formal foundations, from E-R diagrams to relations
-
The relational model - relational algebra
-
SQL - Data definition: tables, constraints, assertions, views
-
SQL - Data update and retrieval: set operations, nesting, aggregation
-
Mid-term exam
-
SQL - Advanced concepts: nulls, materialized views, triggers
-
SQL - Application programming: embedded and dynamic SQL, JDBC and SQLJ
-
Theory of database design: Functional dependencies and their properties
-
Theory of database design: Normal forms and decomposition algorithms
-
Object databases: The object data model, objects in SQL 1999 and SQL 2003
-
XML and Web data: Overview of XML, XML Schema, XML query languages
-
Final exam
-
Prerequisites
-
-
CS 310 Data Structures
-
CS 330 Formal Methods and Models
-
Requirements
-
The course will require 8 homework assignments (of difefrent magnitude).
About half will require computer work.
There will be two exams (a mid-term and a final).
The final grade would be based on exams (75%) and homework assignments (25%).
-
Textbooks
-
Database Systems: An Application-Oriented Approach, Complete Version, 2/E
Lewis, Kifer and Bernstein
Addison-Wesley/Pearson, 2005
ISBN-10: 0321268458
ISBN-13: 9780321268457
-
2. Oracle 10g Programming: A Primer
Sunderraman
Addison-Wesley, 2008
ISBN-10: 0321463048
ISBN-13: 978-0321463043