EE468 Database Systems
CS 460 Database Systems
Spring 2003

Instructor: S. E. Conry
Office: 166 CAMP
Email: conry@clarkson.edu
Phone: 6510

Class Meets: 10:00 – 10:50, Monday, Wednesday, Friday in ERC 110

Instructor’s Office Hours:

Text: Database System Concepts, 4th Edition by A. Silberschatz, H. F. Korth, and S. Sudarshan (McGraw Hill, 2002 (ISBN 0-07-112268-0

Course Description:

EE 468 Database Systems (Eng) R-3, C-3.

CS 460 (EE 468) Database Systems R-3, C-3.

Prerequisites: programming experience in a high level language.

An introduction to database systems. The entity-relationship and relational models are presented and applied to the design of typical databases. New developments in object-oriented and mutimedia databases are presented. Emphasis will be placed on database design for applications in the context of an existing database management system such as ORACLE or ACCESS. (Spring)

Course Objectives:

  1. Students will gain an appreciation for the role database technology and applications play in contemporary organizations.  (Software Engineering Outcome 7)

  2. Students will gain experience in data modeling using the entity relationship and semantic object models.  (Software Engineering Outcomes 1 and 2)

  3. Students will gain experience in developing database designs using appropriate normalization techniques and modern CASE tools.  (Software Engineering Outcome 2)

  4. Students will learn SQL and gain experience using SQL. .  (Software Engineering Outcomes  1 and 6)

  5. Students will gain experience working as a member of a team in the design and development of a significant design project.  (Software Engineering Outcomes 4 and 5)

Tentative Course Outline

Week of Topics Reading

January 6

Introduction

Chapter 1

January 13

Perspectives on DB systems, ER Model

Chapter 1 and Chapter 2

January 20

Relational Model

Chapter 3

January 27

SQL

Chapter 4

February 3

QBE, Integrity, Triggers

Sect. 5.1, Sect. 6.1-6.4

February 10

Winter Break, Security, Database Design

Sect. 6.5 – 6.7, 7.1-7.3

February 17

Relational Database Design

Section 7.4 – 7.10

February 24

Storage devices and storage structures

Chapter 11, Sect. 12.1 – 12.4

March 3

HOUR EXAM I, File structures

Sect. 12.5 – 12.9

March 10

Query Processing, Query Optimization

Sect. 13.1 – 13.6, 14.1 – 14.4

March 17

SPRING BREAK

 

March 24

Transaction Processing

Sect. 15.5 – 15.9

March 3

Concurrency

Sect. 16.1 – 16.10

April 7

Object Oriented databases

Sect. 8.1 – 8.6

April 14

Object-Relational Databases, HOUR EXAM II

Sect. 9.1 – 9.7

April 21

XML, Web databases, multimedia, etc.

Selected readings

April 28

FINAL EXAM WEEK

 

Examinations, Assignments, and Grading

There will be two one-hour examinations and a comprehensive final examination in this course.  All students will be required to take the final examination.

On the order of 5 to 7 problem sets will be assigned.  The assignments will be collected and graded.  It is each student’s responsibility to make sure that he/she understands how to do these problems, as the concepts that are reinforced by the problems will be covered on the examinations.

A portion of the course grade is dependent on class participation.  It is therefore required that students attend class on a regular basis.

There will be a required design project in which each student will work with other students to investigate design and implementation issues in more depth. 

Grading:

 

Homework and Class Participation 20%
Design Project (final report due on last day of classes) 15%

Two Hour Examinations (20% each)   

  Tentative dates:

  • Exam 1 - Monday, March 3
  • Exam 2 - Friday, April 18
40%
Final Examination (as scheduled by SAS)     25%

Students must make up all work missed due to absences of any kind.   Arrangements to make up work missed for reasons such as athletic trips or job trips must be made prior to the date the work is due.  In the event that illness or other unforeseen circumstances such as a death in the family, arrangements to make up work must be made within two days of the due date.  Students must therefore consult promptly with the instructor to make these arrangements.

Student Learning Outcomes:

  1. Course Objective 1: Students will demonstrate that they understand some of the roles the role database technology and applications play in contemporary organizations.  (Outcome to be assessed using homework performance, examinations, and the design project.)

  2. Course Objective 2: Students will represent relationships among data in applications using the entity relationship and semantic object models.  (Outcome to be assessed using homework performance, examinations, and the design project.)

  3. Course Objective 3: Students will develop and document database designs using appropriate normalization techniques and modern CASE tools. (Outcome to be assessed using homework performance and the design project.)

  4. Course Objective 4. Students will gain facility with SQL by using it throughout the course. (Outcome to be assessed using homework performance, examinations, and the design project.)

  5. Course Objective 5. Students will gain experience working as a member of a team in the design and development of a significant design project. (Outcome to be assessed using the design project.)

Professional Component: