CS 371 Database Design and Implementation

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.

Credit hours: 3.0

Instructor: George Bebis
Office: 312 CCB
Phone: 516-6342
E-mail: bebis@mayura.cs.umsl.edu
Office Hours: T R: 12:30 - 2:00 PM or by appointment.

Textbook

Database System Concepts by H.F. Korth and A. Silberschatz, McGraw-Hill, 2nd edition, 1991.

Objectives

Introduction to database concepts, data-models, database languages, and database design.

Course Outline

Introduction and overview (Chapter 1)

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)

Course Policies

Homework problems will be assigned on a regular basis (approximately every Tuesday) and will be collected at the beginning of the class on the due date. Late assignments will be given a 20% late penalty. No assignments will be accepted more than 3 calendar days after the original due day. If you are unable to hand in an assignment by the deadline, you must discuss it with me before the deadline. Solution sets will be provided for all the homework assigned.

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.

Grading Scheme

Mid-term Exam: 30%
Final Exam: 30%
Assignments: 20%
Project: 20%

A 90 and above
B 80-89
C 70-79
D 60-69
F < 60

Important dates

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.)