Welcome to Database Systems (CSCI 440)
Instructor: Mr. Michael Schuh
Meetings: Monday, Wednesday, Friday, 11:00 - 11:50AM, EPS 108
Office Hours: Monday, Wednesday 12:30 - 1:30PM and Tuesday 1:00 - 2:00PM, EPS
359
Final Exam: Mon, Dec 10th,
8:00 - 9:50AM, EPS 108
Check your grades and attendance,
last updated on: October 22nd.
Announcements
If slides say updated make sure you get the latest version
with a hard refresh (F5) in your browser. You might have to do this on the
linked files as well.
Helpful tools for database designing: FabForce DBDesigner and MySQL Workbench.
Additional learning materials recommended at db-class.org.
Frequently made errors on class projects
can be found here.
Daily Class Schedule
Date |
Lecture Topics |
Assigned Readings |
Other |
|
Aug-27, Mon |
5E/6E: 1.1-1.6 |
Please read the class policies and fill out the student info form! |
||
Aug-29, Wed |
5E/6E: 2.1-2.3,
2.5-2.7 |
|||
Aug-31, Fri |
5E/6E: 2.4 |
|||
Sep-03, Mon |
Labor Day (no
classes) |
|
|
|
Sep-05, Wed |
Review, Intro to
Projects |
|
||
Sep-07, Fri |
EXAM 1 (5%) |
|
Exam covers all
materials from Chapters 1 and 2. |
|
Sep-10, Mon |
5E:
3.1-3.4 / 6E: 7.1-7.4 |
|
||
Sep-12, Wed |
5E:
3.5-3.10 / 6E: 7.5-7.10 |
|
||
Sep-14, Fri |
ER Model Review (updated 9/13) |
|
||
Sep-17, Mon |
|
HW2 Assigned, due 9/24! |
||
Sep-19, Wed |
5E:
4 / 6E: 8 |
|
||
Sep-21, Fri |
|
|
||
Sep-24, Mon |
5E:
5 / 6E: 3 |
Hand in HW2! |
||
Sep-26, Wed |
Intro to Relational
Algebra (updated 10/1) |
5E/6E: 6.1-6.3 |
|
|
Sep-28, Fri |
cont. |
|
|
|
Oct-01, Mon |
Relational Algebra
and Calculus (updated 10/1) |
5E/6E: 6.3-6.4 |
|
|
Oct-03, Wed |
|
|||
Oct-05, Fri |
cont. |
5E/6E: 6.5-6.8 |
|
|
Oct-08, Mon |
5E:
7.1-7.2 / 6E: 9.1-9.2 |
|||
Oct-10, Wed |
5E:
7.2-7.3 / 6E: 9.2-9.3 |
|||
Oct-12, Fri |
Exam Review |
|
|
|
Oct-15, Mon |
EXAM 2 (15%) |
|
DATE FINALIZED |
|
Oct-17, Wed |
5E:
10.1-10.2 / 6E: 15.1-15.2 |
|
|
|
Oct-19, Fri |
5E: 10.3-10.6
/ 6E: 15.3-15.8 |
|
|
|
Oct-22, Mon |
cont. |
5E: 11.0-11.1
/ 6E: 16.0-16.1 |
Normalization
Homework (HW3, due 10/26) |
|
Oct-24, Wed |
Exam Overview, Class Project Info |
|
|
|
Oct-26, Fri |
5E: 8.1-8.2 / 6E:
4.1-4.2, 5.4 |
Due: HW3, Project
Phase 0 |
|
|
Oct-29, Mon |
5E: 8.3-8.4 / 6E:
4.3 |
|
||
Oct-31, Wed |
SQL 3, DBMS Access |
5E: 8.5-8.8 / 6E:
4.4-4.6,5.1-5.3 |
|
|
Nov-02, Fri |
SQL Homework (HW4, due 11/19), OrdersDB.txt |
|
||
Nov-05, Mon |
cont. |
5E:
9 / 6E: 13 |
|
|
Nov-07, Wed |
Exam Review |
Optional Due: Project Phase 1 |
|
|
Nov-09, Fri |
EXAM 3 (15%) |
|
Date has been
finalized! |
|
Nov-12, Mon |
Veteran's Day (no
classes) |
|
|
|
Nov-14, Wed |
5E:
13 / 6E: 17 |
|
||
Nov-16, Fri |
5E:
14.1-14.2 / 6E: 18.1-18.2 |
Optional Due: Project Phase 2 (hardcopy in class) |
||
Nov-19, Mon |
5E:
14.3-14.6 / 6E: 18.3-18.7 |
Due: HW4 (hardcopy in class) |
||
Nov-21, Wed |
Thanksgiving (no
classes) |
|
|
|
Nov-23, Fri |
Thanksgiving (no
classes) |
|
|
|
Nov-26, Mon |
5E:
15 / 6E: 19 |
Optional Due: Project Phase 3 (hardcopy in class) |
||
Nov-28, Wed |
|
|||
Nov-30, Fri |
Review, Start Project Demos |
|
|
|
Dec-03, Mon |
Project Demos |
|
|
|
Dec-05, Wed |
Project Demos |
|
|
|
Dec-07, Fri |
Project Demos |
|
|
|
Dec-10, Mon |
FINAL EXAM 8:00 -
9:50 |
|
Same room (EPS
108) |
Last
Updated: 12/5/2012