CSG130: Introduction to Database Systems (Spring 2009)


NEWS

Instructor

Donghui Zhang

Office Hours: W 2:30-5:30pm.
Office: 478WVH
Phone: x2177
Email: donghui AT ccs.neu.edu

Lecture: W 6-9pm, 429 Ryder.

TA

Shenghan Zhang <shenghan AT ccs.neu.edu>

Overview

This course covers fundamental topics of database systems. It covers both topics needed for developing (web-)database applications and topics needed to develop a database system itself. As foundations to database design, ER model and relational model will be discussed. To express database queries, relational algebra and SQL will be studied. From the database internal's side, this course covers storage, indexing, query evaluation and optimization, and transaction management.

Grading

Textbook

Textbook: Database Management Systems, 3rd edition, Ramakrishnan and Gehrke, published by McGraw-Hill Company, ISBN 0-07-246563-8.
TEXTBOOK HOMEPAGE.

Project

Tentative Schedule

 

Date

Lecture

Quiz

Week 1

Jan 7

Chp 1: Introduction

 

Week 2

Jan 14

Chp 6 & 7: Web database application

 

Week 3

Jan 21

Chp 2 & 3: ER model, Relational Model

 

Week 4

Jan 28

Chp 19: Normal forms

 

Week 5

Feb 4

Chp 4: Relational algebra

Quiz 1

Week 6

Feb 11

Chp 5: SQL

 

Week 7

Feb 18

Chp 12: Query evaluation, NEUStore

 

Week 8

Feb 25

Chp 8, 9, 13: Storage, External sort

Quiz 2

Week 9

Mar 4

Spring break, no class.

 

Week 10

Mar 11

Chp 10, 11: B+-tree, Hash

 

Week 11

Mar 18

Chp 15: Query optimization

Quiz 3

Week 12

Mar 25

Chp 15.

 

Week 13

Apr 1

Chp 16 & 17: Transaction Management

 

Week 14

Apr 8

Chp 16 & 17.

 

Week 15

Apr 15

Project demo.

 

Final

Apr 22

 

 

Academic Honesty

Northeastern University is committed to the principles of intellectual honesty and integrity. All members of the Northeastern Community are expected to maintain complete honesty in all academic work, presenting only that which is their own work in tests and assignments. If you have any questions regarding the proper attribution of the work of others, contact your professor prior to submitting the work for evaluation.