CSE 346
Database Concepts

Fall Semester 2004

Effective techniques in managing, retrieving, and updating information from a database system. Focusing primarily on relational databases, the course presents the entity-relationship model, query processing, and normalization. Topics such as relational calculus and algebra, integrity constraints, distributed databases, and data security will also be discussed. The Final Project will consist of the design and implementation of a database system.

Class Meeting Times/Location:

10:40-11:30 on MWF in Debartolo 119

Instructor:

Greg Madey <gmadey@nd.edu>, (574)631-8752, 350 Fitzpatrick Hall

Office Hours:

By appointment (and whenever my office door is open!)

Teaching Assistant:

Eric Albert <ealbert@cse.nd.edu>, (574) 631-8380, 355S Fitzpatrick

Required Texts:

1) Fundamentals of Databases Systems, 4th Ed, Elmasri & Navathe, Pearson/Addison-Wesley, 2003

2) Oracle 9i Programming: A Primer, Sunderraman, Pearson/Addison-Wesley, 2004

Optional Texts

The Java(TM) Tutorial: A Short Course on the Basics (3rd Edition)
by Mary Campione

Course Goal:

To teach students the fundamentals of database development, namely data modeling, database design and database implementation. Current topics in database technology will be introduced, such as object-oriented design, UML, spatial-temporal databases, multimedia databases, XML, Internet-based databases, data warehousing, data mining, GIS, and genome data managment

Prerequisites: CSE 331

Topics:                                                        

Introduction-Basic Concepts
Entity-relationship model
File Organization
Relational Data Model
Relational Algebra, Calculus
SQL
Hierarchical & Network Data Models
Normalization
Database Design
Database Implementation
Crash Recovery
Concurrency Control
Security
Distributed Databases
Object-Oriented Databases
Spatial-temporal Databases
Multimedia Databases
XML
Internet-based Databases
Data Warehousing
Data Mining
GIS
Genome Data Managment

Computer Usage: Most homework assignments and the Final Project will require the use of the computer..

Grading

Programming assignments, class                              
participation, presentations                             40%
Exams (2)                                                      30%
Final exam                                                     30%