CS G102: Database Managment

Spring 2003

Instructor:  Kanoulas Evangelos

147 Cullinane Hall                                                                  Office: 617-373-4605
College of Computer Science                                                 Email: ekanou at ccs dot neu dot edu
Northeastern University
Boston, MA 02115


Class meeting times/location:     Thu 6:00-9:00 PM, 247 CN

Office Hours:    Tue 3:30-5:30pm , 143CN


Course Description

Textbook

Grading

Academic Honesty and Integrity

Class Schedule (Includes all assignments) - Solutions for 3rd Assignment are posted

Resources (Unix, SQL, SQL Plus, Oracle, Biology Databases ...)

Class Mailing List (subscription, mailing archives) - Mailing Address: csg102 at lists dot ccs dot neu dot edu

The dream home database (how to create the database and load data in it)

more to be added ...


Course Description

Considers the concepts and structures necessary to design and implement a database application. Introduces database concepts and database modeling. Emphasizes the relational model, but may also discuss older models such as the hierarchical and network models as well as the newer object-oriented model. Topics include data definition and manipulation languages; design theory for relational models; and an introduction to access methods, query optimization, integrity, security, recovery, and concurrency in database systems (not opened to MS students in CS for credit).


Required Textbook

Thomas Connolly, Carolyn Begg
Database systems : a practical approach to design, implementation, and management
Harlow, England ; New York : Addison-Wesley, 2002


Grading

The course grade will be based on problem sets (total 40%), a midterm (30%), a final exam (30%).


Problem Sets

Problem sets are due at the beginning of class. As a general rule, a problem set turned in late will be penalized 10% for every weekday it is late, and no homework will be accepted beyond 1 week past its due date.    Students may discuss the problem sets with one another, but solutions should be written up separately.  If a key idea is obtained from another person (other than the instructor) or from another book or paper (other than the course textbook), then the source of that idea should be cited.  Solutions should be presented in a clear and concise manner.   Tentative out/due dates for the problem sets are listed in the schedule.


Exams

Midterm Exams: Thursday, March 11, 6-9pm
Final Exams : Thursday, April 22, 6-9pm