CS 3200 Database Design Fall 2013

Fall 2013

Instructor: Ken Baclawski

342 WVH                                                                  617-373-4631
College of Computer ScienceKen@Baclawski.com
Northeastern UniversityFax: 617-373-5121
Boston, MA 02115

Class meeting times and location: Monday and Wednesday 2:50-4:30PM, 312 Ell

Office hours and location: Monday, Wednesday and Thursday 4:40 to 5:40pm in 342 WVH.

Fall office hours will begin on 4 September 2013 and end on 12 December 2013.

Note: There will be no classes or office hours on 14 October 2013, 11 November 2013, 27 November and 28 November 2013.

Required Textbook


Course Resources

Class Schedule

Assignment Schedule

Academic Honesty and Integrity [pdf]

Accommodations for Students with Disabilities

Required Textbook

Database Design and Implementation by Edward Sciore
John Wiley, October 2008
ISBN: 0471757160
ISBN-13: 9780471757160


The course grade will be based on six individual assignments (40%), and a Final Exam (60%). The Final Exam will be an open-book/open-notes exam. Laptops, PDAs or other communication devices are not permitted at the Final Exam. The Final Exam will use assigned seating and will have a strict time limit.

The course grade will be reduced for the following:

  1. Unexcused class absences
  2. Arriving late to a class or leaving during a class (when unexcused)
  3. Submitting an assignment late (1 point out of 100 for each hour)
  4. Submitting the Final Exam late (1 point out of 60 for each minute)

There will be assigned seating during classes, with students in a team sitting together. The seating chart will be posted after the teams have been formed.

Course Resources

Exercises, quizzes and exams (some of which have solutions) from previous terms are available:
Class discussions are on Piazza.

There is a weekly discussion session every Friday from 4pm to 5pm in 366 WVH. The discussion session will be led by a TA.

The Solution to the Final Exam is available.

Class Schedule

9/4Overview of database systems and database design Chapter 1 and Academic Honesty and Integrity
9/9The relational model Chapter 2
9/11The Unified Modeling Language (UML) Sections 3.1, 3.2
9/16Translating from UML to the relational model Section 3.3
9/18The design process Section 3.4
9/23SQL part 1 Sections 4.3.1 to 4.3.5
9/25SQL part 2 Sections 4.3.6 to 4.3.10 and 4.4
9/30Views and Integrity Sections 4.5 and 5.1 to 5.3
10/2Dealing with redundancy Sections 3.5, 3.6
10/7The relational algebra Sections 4.1, 4.2, Relational Algebra Symbols
10/9Security and indexing Sections 5.4, 5.5 and 6.3
10/16Database clients and servers Chapter 7
10/21Basic JDBC Sections 8.1 and 8.2.4
10/23Object-relational mapping Sections 9.1, 9.2
10/28JPA Sections 9.3 to 9.5
10/30Web services and OData Introduction to OData (distributed to the class)
11/4XML and JSON Sections 10.1, 10.2
11/6Multi-tiered architectures Chapter 11
11/13Introduction to storage Sections 12.1 and 12.4
11/18Transaction and recovery management Sections 14.1, 14.2 and 14.3.1 to 14.3.3
11/20Concurrency control Sections 14.4.1 to 14.4.5 and 14.4.7
11/25Metadata management Chapter 16
12/2Query Processing Sections 17.1 to 17.4
12/4Indexing Sections 21.1 to 21.5
TBAFinal Exam All course material

The Final Exam will mostly consist of problems similar to the individual assignments, but it will also cover course material that is not on any assignment, such as the last two lectures.

Assignment Schedule

There will be 6 assignments.

1Basic database design and translation to the relational modelThursday 19 September 2013 at 11:00pm. Solution #1
2SQL queries, updates and viewsThursday 3 October2013 at 11:00pm. Solution #2
3DBMS API features, including integrity, security, triggers, stored procedures, the design process and relational operatorsSaturday 19 October2013 at 11:00pm. Solution #3
4JDBC programming and object-relational mappingSaturday 2 November 2013 at 11:00pm. Solution #4
5Web services, OData, XML and JSONSaturday 16 November 2013 at 11:00pm. Solution #5
6DBMS componentsSaturday 30 November 2013 at 11:00pm. Solution #6

All assignments must be uploaded to Blackboard. Be sure to check that your upload has been accepted by Blackboard and has been assigned a timestamp. You may upload your solution to an assignment more than once, but only the last one (and its timestamp) will be used for grading. A late submission will lose 1 point out of 100 for each hour that it is late, as determined by the timestamp.

Individual extensions to the deadlines are given only for documented medical reasons, in which case a grade of I will be given for the course. Extensions are sometimes given to the class as a whole but only for compelling reasons that are discussed in class well before the deadline.