CS348: Information Systems
Instructor: Walid G. Aref
MWF: 9:30AM - 10:20AM
CS G066
See the Policy
on Intellectual Honesty before you start!
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
- Database System Architectures
- Application Development and Administration
- Advanced Querying and Information Retreival
- Data Mining Techniques
- Data Warehousing
Textbooks:
- Database System Conepts (4th Edition), Silberschatz, Korth, and
Sudarshan, 2002.
- Oracle 9i Programming: A Primer, Rajshekhar Sunderraman, 2003.
Schedules and Contact Information:
Instructor: Prof. Walid G. Aref
E-mail: aref@cs.purdue.edu
Office Hours:
Mondays: 10:20AM -- 11:30AM or by email appointments
Teaching Assistants:
Otoniel Venezuela <ovenezue@cs.purdue.edu>
Office Hours: Fridays 1:30-3:30PM
Office: MATH G148
Office Phone: 49-67413
Yasin Laura <ylaurasi@purdue.edu>
Office Hours: Monday 2-4PM
Office: PHYS 92
Office Phone: 49-62171
----------------------- PSOs ----------------------------------------
PSO-1 Tuesday 11:30PM to 1:20PM
(TA: Yasin)
PSO-2 Tuesday 1:30PM to 3:20PM (TAs: Yasin and Otoniel)
PSO-4 Friday 3:30PM to 5:20PM (TA: Otoniel)
-----------------------------------------------------------------------
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 around 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.
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 Policy on
Intellectual Honesty. Please read it carefully.
Most information regarding the course will be made available on the
web page:
http://www.cs.purdue.edu/homes/aref/Spring2005CS348/coursehome.html