Instructor: Ken Baclawski
|College of Computer Science||Ken@Baclawski.com|
|Northeastern University||Fax: 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.
Academic Honesty and Integrity [pdf]
Accommodations for Students with Disabilities
Database Design and Implementation by Edward Sciore
John Wiley, October 2008
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:
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.
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.
|9/4||Overview of database systems and database design||Chapter 1 and Academic Honesty and Integrity|
|9/9||The relational model||Chapter 2|
|9/11||The Unified Modeling Language (UML)||Sections 3.1, 3.2|
|9/16||Translating from UML to the relational model||Section 3.3|
|9/18||The design process||Section 3.4|
|9/23||SQL part 1||Sections 4.3.1 to 4.3.5|
|9/25||SQL part 2||Sections 4.3.6 to 4.3.10 and 4.4|
|9/30||Views and Integrity||Sections 4.5 and 5.1 to 5.3|
|10/2||Dealing with redundancy||Sections 3.5, 3.6|
|10/7||The relational algebra||Sections 4.1, 4.2, Relational Algebra Symbols|
|10/9||Security and indexing||Sections 5.4, 5.5 and 6.3|
|10/16||Database clients and servers||Chapter 7|
|10/21||Basic JDBC||Sections 8.1 and 8.2.4|
|10/23||Object-relational mapping||Sections 9.1, 9.2|
|10/28||JPA||Sections 9.3 to 9.5|
|10/30||Web services and OData||Introduction to OData (distributed to the class)|
|11/4||XML and JSON||Sections 10.1, 10.2|
|11/6||Multi-tiered architectures||Chapter 11|
|11/13||Introduction to storage||Sections 12.1 and 12.4|
|11/18||Transaction and recovery management||Sections 14.1, 14.2 and 14.3.1 to 14.3.3|
|11/20||Concurrency control||Sections 14.4.1 to 14.4.5 and 14.4.7|
|11/25||Metadata management||Chapter 16|
|12/2||Query Processing||Sections 17.1 to 17.4|
|12/4||Indexing||Sections 21.1 to 21.5|
|TBA||Final 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.
There will be 6 assignments.
|1||Basic database design and translation to the relational model||Thursday 19 September 2013 at 11:00pm.||Solution #1|
|2||SQL queries, updates and views||Thursday 3 October2013 at 11:00pm.||Solution #2|
|3||DBMS API features, including integrity, security, triggers, stored procedures, the design process and relational operators||Saturday 19 October2013 at 11:00pm.||Solution #3|
|4||JDBC programming and object-relational mapping||Saturday 2 November 2013 at 11:00pm.||Solution #4|
|5||Web services, OData, XML and JSON||Saturday 16 November 2013 at 11:00pm.||Solution #5|
|6||DBMS components||Saturday 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.