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

Syllabus, Introduction to Databases

5E/6E: 1.1-1.6

Please read the class policies and fill out the student info form!

Aug-29, Wed

The Basics

5E/6E: 2.1-2.3, 2.5-2.7

Aug-31, Fri

DB System

5E/6E: 2.4

DBMS System (color figure)

Sep-03, Mon

Labor Day (no classes)

 

 

Sep-05, Wed

Review, Intro to Projects

 

Extra Slides

Sep-07, Fri

EXAM 1 (5%)

 

Exam covers all materials from Chapters 1 and 2.

Sep-10, Mon

Intro to Data Modeling

5E: 3.1-3.4 / 6E: 7.1-7.4

 

Sep-12, Wed

Data Modeling 2

5E: 3.5-3.10 / 6E: 7.5-7.10

 

Sep-14, Fri

ER Model Review (updated 9/13)

 

Sep-17, Mon

Practice Design

 

HW2 Assigned, due 9/24!

Sep-19, Wed

Intro to EER Model

5E: 4 / 6E: 8

 

Sep-21, Fri

EER Model 2

 

 

Sep-24, Mon

Relational Database Model

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

Relational Practice

 

 Practice Solutions, Relational model hand-out

Oct-05, Fri

cont.

5E/6E: 6.5-6.8

 

Oct-08, Mon

Mapping the ER-Model

5E: 7.1-7.2 / 6E: 9.1-9.2

 ER diagram hand-out

Oct-10, Wed

Mapping the EER-Model, Mapping Practice

5E: 7.2-7.3 / 6E: 9.2-9.3

 Practice Solutions

Oct-12, Fri

Exam Review

 

 

 

Oct-15, Mon

EXAM 2 (15%)

 

DATE FINALIZED

 

Oct-17, Wed

Functional Dependencies

5E: 10.1-10.2 / 6E: 15.1-15.2

 

 

Oct-19, Fri

Normalization

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

SQL 1

5E: 8.1-8.2 / 6E: 4.1-4.2, 5.4

Due: HW3, Project Phase 0  

 

Oct-29, Mon

SQL 2

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

Extra Mysql Commands

 

Nov-02, Fri

SQL 4

SQL Homework (HW4, due 11/19), OrdersDB.txt

 

Nov-05, Mon

cont.

5E: 9 / 6E: 13

Common Projects Errors

 

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

File Organization

5E: 13 / 6E: 17

 

Nov-16, Fri

Indexing Files and B-Trees, Full-size slide examples

5E: 14.1-14.2 / 6E: 18.1-18.2

Optional Due: Project Phase 2 (hardcopy in class)

Nov-19, Mon

More B+-Trees, B+-Tree practice

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

Query Optimization

5E: 15 / 6E: 19

Optional Due: Project Phase 3 (hardcopy in class)

Nov-28, Wed

Optimization practice, Some practice solutions

 

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