Instructor: Andreas M. Olligschlaeger ("Olli")

Office Hours: MW 11:00-12:30

Office: HBH 2101A

Phone: 268-5137

Prerequisites: Introduction to Database Management (90-746) as well as a good working knowledge of at least one programming language such as C, Pascal, FORTRAN or Basic. Students should also be familiar with Oracle's Designer/2000, standard SQL, as well as client/server computing environments.

Course Objectives: This course is primarily a project-oriented, "hands on" course, building on the Database Management course (90-746). It's goal is to introduce students to advanced database programming techniques using Oracle's Developer/2000 suite of database application development products in an environment that is as close to the "real world" as possible within a teaching environment. By the end of the course students should be able to design fairly complex Oracle database applications that make use of triggers, program units, as well as OLE and multimedia objects.

Required Text Books: No specific textbook. Students can use any database management book, including the textbook from 90-746. However, students that have not yet purchased the Designer/2000 and Developer/2000 handbooks should do so. In addition to the aforementioned books, each student should purchase at least one book dealing with Oracle database applications programming. Ideally a project group should have at least one copy of each of the following books: PL/SQL manual, Developer/2000 manual, Report Designer manual and Designer/2000 manual. Exact details will be discussed in class.

Course Project: 50% of your grade will be based on a semester long course project. All students will be assigned the same project, on which they can work in groups of up to four students. Students in a project group will share the same grade for their project. The project will be completed in four phases: (1) database design and functionality requirements (10%), (2) database implementation, data entry screens, data query screens and report layouts (10%), (3) working system prototype (10%) and (4) final system delivery (20%).

Exams: There will be a midterm and a final exam, each of which count for 25% of your grade. All exams are open book/open notes.