-
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
-
Time and place
-
Thursday, 4:30-7:10 pm
Innovation Hall 136
-
Instructor
-
Dr. Amihai Motro
Office: ENG-4415
Telephone: 703-993-1665
Email: ami@gmu.edu
Web: http://cs.gmu.edu/~ami
Office hours: Tuesday and Thursday, 1:45-2:45 pm
-
Teaching Assistant
-
Roy Abhishek
Office: TBA
Email: TBA
Office hours: TBA
-
Prerequisites
-
-
CS 310 Data Structures
-
CS 330 Formal Methods and Models
Prerequisites are strictly enforced!
-
Requirements
-
Two exams (a mid-term and a final) and about 8 homework assignments (of
difefrent magnitude), most requiring computer work.
The final grade would
be based on exams (75%) and homework assignments (25%).
-
Textbooks
-
The first book is required, the second is recommended.
-
Database Systems - An Application-Oriented Approach, Complete Version, 2nd
Edition
Kifer, Bernstein, and Lewis
Addison-Wesley/Pearson, 2005
ISBN-10: 0321268458
ISBN-13: 9780321268457
-
Oracle 10g Programming: A Primer
Sunderraman
Addison-Wesley, 2008
ISBN-10: 0321463048
ISBN-13: 978-0321463043