This course provides students with a thorough and practical introduction to
database management systems and their design with a particular emphasis on
relational databases. We will cover entity-relationship modeling, database design
techniques, relational algebra, and SQL. In addition, modern database design
notations including IE and UML will be discussed. Furthermore, the course will
expose students to the architecture of databases, including file storage
mechanisms, indexing, hashing, query plan evaluation, query optimization, and
transaction management. Students are expected to complete readings in the text
book, solve problem sets, design and develop a database application, and venture
into the literature of database design and implementation.
Relational Model
Relational Algebra
Tuple & Domain Calculus
SQL-92
Transactions
Concurrency Control
Integrity Control
XML Stores
JDBC
Query Processing
Indexing & Hashing
Query Optimization
Current Research
Areas
Text Book

Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System
Concepts, 5th ed., McGraw-Hill, 2006.
Course Description
91.573 - Database I - Fall 2006
Course Information

Time: W 5:30 - 8:20 pm
Location: OS404

Syllabus
Class Forum
Assignments
Lecture Notes
Announcements