Spring 2012
Instructor: Ken Baclawski
| 342 WVH | 617-373-4631 |
| College of Computer Science | Ken@Baclawski.com |
| Northeastern University | Fax: 617-373-5121 |
| Boston, MA 02115 | |
Class meeting times and location: Thursdays 6:00-9:00PM in 229 RI
Office hours and location:Wednesday and Thursday 3:00-4:30PM in 342 WVH.
Spring office hours will begin on 11 January 2012 and end on 26 April 2012.
There will be no class or office hour on 7 and 8 March 2012.
Academic Honesty and Integrity
Database Design and Implementation by Edward Sciore
John Wiley, October 2008
ISBN: 0471757160
ISBN-13: 9780471757160
The course grade will be based on ten assignments (50%), a Mid-Term Exam (20%), and a Final Exam (30%). The exams will be open-book/open-notes exams. Laptops, PDAs or other communication devices are not permitted. The Mid-Term Exam will be given on 22 February 2012 during the beginning of the regular class time. The exam will be followed by a lecture. The Final Exam will be given on 25 April 2012 during the regular class time but not the same room.
The solutions to exercises, quizzes and exams from previous terms are available:
www.ccs.neu.edu/home/kenb/db
| Date | Topic | Reading |
|---|---|---|
| 1/11 | Overview of database systems, the relational model and UML design | Chapters 1, 2, and sections 3.1 and 3.2 |
| 1/18 | Database design and translating UML to the relational model | Sections 3.3 and 3.4 |
| 1/25 | SQL queries | Section 4.3 |
| 2/1 | Advanced SQL queries, updates and views | Sections 4.3 to 4.5 |
| 2/8 | Integrity, security, triggers and stored procedures | Chapter 5 |
| 2/15 | The database design process and basic relational operators | Sections 3.5, 3.6, 4.1 and 4.2 |
| 2/22 | Mid-Term Exam | Database design, translating to the relational model and SQL queries |
| Index design principles | Section 6.3 | |
| 2/29 | Basic JDBC programming | Chapter 7 and Section 8.1 |
| 3/14 | Advanced JDBC and object-relational mapping | Sections 8.2, 8.3, and Chapter 9 |
| 3/21 | XML and storage devices | Chapter 10, and Sections 12.1 to 12.4 |
| 3/28 | Concurrency control and metadata management | Sections 14.4.1 to 14.4.8, and Chapter 16 |
| 4/4 | Log, buffer and recovery management | Sections 13.1 to 13.4 and 14.1 to 14.3 |
| 4/11 | Query processing and optimization | Sections 17.1 to 17.5 and 21.1 to 21.5 |
| 4/18 | Advanced topics | TBA |
| 4/25 | Final exam | Integrity; security; stored procedures; index design; JDBC, JPA and XSLT programming; transactions and concurrency |
There will be 10 assignments.
| Number | Assignment | Due |
|---|---|---|
| 1 | Basic database design | Tuesday 17 January 2012 at 11:00pm. |
| 2 | Translating UML to the relational model | Tuesday 24 January 2012 at 11:00pm. |
| 3 | Basic SQL queries | Tuesday 31 January 2012 at 11:00pm. |
| 4 | Advanced SQL queries | Tuesday 7 February 2012 at 11:00pm. |
| 5 | Integrity, security and stored procedures | Tuesday 14 February 2012 at 11:00pm. |
| 6 | Index design | Tuesday 28 February 2012 at 11:00pm. |
| 7 | JDBC programming | Tuesday 13 March 2012 at 11:00pm. |
| 8 | JPA programming | Tuesday 20 March 2012 at 11:00pm. |
| 9 | XML and XSLT programming | Tuesday 27 March 2012 at 11:00pm. |
| 10 | Transactions and concurrency | Tuesday 3 April 2012 at 11:00pm. |
Please commit your solution to the subversion repository at
https://trac.ccs.neu.edu/svn/<username>,
where <username> is your CCIS username.