Course Overview:
This course covers fundamental concepts of database and information systems. These concepts include database modeling and design, relational databases, querying and SQL, integrity and security, object-based databases, XML and web databases, data storage, transactions, database system architectures, advanced querying and information retrieval, data mining and warehousing techniques.

More specifically, the course covers the following topics:

• Overview of Database Systems
• The Entity-Relationship Model
• The Relational Model
• SQL
• Other Relational Languages
• Integrity and Security
• Relational Database Design
• Object-Oriented Databases
• Object-Relational Databases
• XML and Web Databases
• Data Storage, File Structures. and Indexing
• Transactions: Management, Concurrency, and Recovery
• Database System Architectures
• Application Development and Administration
• Advanced Querying and Information Retreival
• Data Mining Techniques
• Data Warehousing

1. Database System Conepts (4th Edition), Silberschatz, Korth, and Sudarshan, 2002.
2. Oracle 9i Programming: A Primer, Rajshekhar Sunderraman, 2003.

Teaching Assistants:
Lynn G. Hoffman
    E-mail: lghoffma@purdue.edu
    Office hours:
        Wed. 8-9AM
        Fri. 2:30-3:30PM
    Office: Physics Room 12
    Phone: 765-496-2780

Mehmet Ercan Nergiz
    E-mail: mnergiz@cs.purdue.edu
    Office Hours: Mon.  and Wed. 10:15AM -- 11:15AM
    Office: Math. Bldg., Room G150
    Phone: TBD

Evans Adolfo Tapia
    E-mail: etapia@cs.purdue.edu
    Office Hours: Mon and Thu 8:45AM -- 10:15AM
    Office: Math. Bldg., Room G146
    Phone: 496-7546

348S(Prac,Study&Obsv)
01 01  W 11:30am-1:20pm Aug 25 - Dec 14, 2003 SC 189 (Pso 01-01)
02 01  F  11:30am-1:20pm Aug 25 - Dec 14, 2003 SC 189 (Pso 02-01)
03 01 Th 11:30am-1:20pm Aug 25 - Dec 14, 2003 SC 189 (Pso 03-01)

Workload:
There will be around four database project assignments. The projects are an important part of the course. They will be SQL-related programming assignments using Oracle. There will be three-four homeworks, a midterm, and a final examinations. The final exam will be cumulative, but the emphasis will be on the material covered after the midterm examination.

The Project:
Grading:
The final grade will be based upon the following:
Programming/Project Assignments: 25%
Homework Assignments: 25%
Mid-term Exam: 20%
Final: 30%
(Extra-credit points will be given in class)

Course Policy:
Late submission will result in a 10% penalty for each day late.
Students are strongly advised that any act of cheating will be handled according to the following academic dishonesty policy. Please read it carefully.

Most information regarding the course will be made available on the web page:
http://www.cs.purdue.edu/homes/aref/Fall2003CS348/coursehome.html