Prerequisites: CS 225, Stat 132, Math 245, and Math 250. If you do not meet the prerequisite requirements for this course, you should see the instructor immediately.
Office: 312 CCB
Office Hours: T R: 12:30 - 2:00 PM or by appointment.
Entity-Relationship Model (Chapter 2)
Relational Data Model (Chapter 3)
Relational Query Languages (Chapter 4)
Mid-term Exam (1 1/2 hours)
Integrity Constraints (Chapter 5)
Relational Database Design (Chapter 6)
Indexing (Chapter 8)
File and System Structure (Chapter 7)
Final Exam (1 1/2 hours)
There will be a course project involving the design, implementation, population, and querying of a database implemented using Oracle. The project will be done by groups of 3 or 4 students. At the end of the semester, each team will give me a demonstration of their project database. A report summarizing the project and experiences will be required. Late projects will be given a 20% late penalty.
There will be a mid-term and a final exam. Both exams will be closed books, closed notes. If you are unable to attend an exam you must inform me in advance. A missed exam may be made up only if it was missed due to an extreme emergency.
Final Exam: 30%
A 90 and above
F < 60
9/2/96 - no classes (labor day holiday)
2nd week of October - Mid-term exam
12/9/96 - last day of classes
12/16/96 - Final exam (5:30-7:00 p.m.)