CS U430: Database Design

Spring 2006

 

Instructor  Panfeng (Tony) Zhou

Office: 466 WVH                                                                                                                                 Tel: 617-373-5319
College of Computer Science                                                                                                    Email: zhoupf AT ccs neu edu
 

 

Class meeting times/location     MWTh 1:35 PM-2:40 PM, 110 West Village Bldg H

 

Instructor Office Hours Thursday 2:40-4:10pm

 

TA Dongjie He / hedj AT ccs neu edu

 

TA Office Hours   Tuesday 1:30-2:30pm, 102 WVH (Computer Lab)

 

 

Required Textbook

Database Principles, Programming and Performance, Second Edition

by Patrick O'Neil and Elizabeth O'Neil, Morgan-Kaufmann, publishers.

ISBN: 1-55860-438-3

http://www.amazon.com/gp/product/1558604383/103-0292975-3986246?v=glance&n=283155

 

Course Descriptions

Studies the design of a database for use in a relational database management system. The entity-relationship model and normalization are used in problems. Relational algebra and then the SQL (structured query language) are presented. Advanced topics include triggers, stored procedures, indexing, elementary query optimization, and fundamentals of concurrency and recovery. Students implement a database schema and short application programs on one or more commercial relational database management systems. MS SQL and ASP.NET are chosen to be used in the course.

 

Class Schedule & Problem Sets

Link

Notice:

Jan 9th:  I have sent the first email to you. If you did not get my email, please email me directly.

 

Resources

Link

 

Grading

The course grade will be based on problem sets and quiz (total 40%), a project (15%) and a final exam (45%). 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 after the class explaining the solutions begins. No assignments are accepted after the final exam. All homework should be turned in both softcopy (email to BOTH TA AND ME with the title ¡§HW# - your last name¡¨) and hard copy (with your name and last 4 digits of your ID on it).  

 

During exams, ONE PAGE (two-sided, 8.5X11 inches) of notes may be used. No other notes or texts are to be used.

 

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 instructor prior to submitting the work for evaluation.

 

Mail Alias

csu430-sp06 AT lists ccs neu edu  (https://lists.ccs.neu.edu/bin/listinfo/csu430-sp06 )