IEOR 215 : Analysis and Design of Databases

August 30 : Monday

Lecture: Introduction 

Entrance Exam 

2:00pm-3:00pm, 3111 Etcheverry

September 1 : Wednesday

Lecture: Introduction and Formal Logic 

Required Readings

"The Rise of Relational Databases" National Academy Press [Handout]

Chapters 1-2 of Fundamentals of Database Systems [Textbook]

Team Assignment assigned 

Due on September 13

Assignment details

September 3 : Friday

Lab: HTML 

Resources

Lab Description

HTML Quiz assigned 

Due on September 20

Assignment details

September 6 : Monday

Lecture: Holiday: No Class Today 

September 8 : Wednesday

Lecture: Relational Modelling 

Required Readings

Chapter 3 of Fundamentals of Database Systems [Textbook]

September 10 : Friday

Lab: MS Access 1: Introduction 

Resources

Lab Description

MS Access Lab 1 Quiz assigned 

Due on September 13

Assignment details

September 13 : Monday

Lecture: Relational Modelling 

Team Assignment due 

Assignment details

Project 1 Proposals assigned 

Due on September 27

Assignment details

HW 1: Logic assigned 

Due on September 20

Assignment details

MS Access Lab 1 Quiz due 

Assignment details

September 15 : Wednesday

Lecture: Holiday: No Class 

September 17 : Friday

Lab: MS Access 2: Tables 

Resources

Lab Description

MS Access Lab 2 Quiz assigned 

Due on September 27

Assignment details

September 20 : Monday

Lecture: Relational Modelling 

HW 1: Logic due 

Assignment details

HTML Quiz due 

Assignment details

September 22 : Wednesday

Lecture: Relational Modelling 

HW 2: ER diagram and FDS Exercises assigned 

Due on September 29

Assignment details

September 24 : Friday

Lab: MS Access 3: Relationships 

Resources

Lab Description

MS Access Lab 3 Quiz assigned 

Due on October 5

Assignment details

September 27 : Monday

Lecture: Relational Modelling 

Required Readings

Chapter 4.1-4.5 of Fundamentals of Database Systems [Textbook]

Project 1 Proposals due 

Assignment details

Project 1 Presentations assigned 

Due on October 22

Assignment details

MS Access Lab 2 Quiz due 

Assignment details

September 29 : Wednesday

Lecture: Relational Modelling 

Required Readings

Chapter 6.1-6.5 of Fundamentals of Database Systems [Textbook]

HW 2: ER diagram and FDS Exercises due 

Assignment details

HW 3: 4.18, 4.21 assigned 

Due on October 6

Assignment details

Homework 3 : 4.18, 4.21 assigned 

Due on October 6

Assignment details

October 1 : Friday

Lab: MS Access 4: Relationships 

Resources

Lab Description

Quiz 4 assigned 

Due on October 12

Assignment details

October 4 : Monday

Lecture: Relational Modelling 

Required Readings

Chapter 7 of Fundamentals of Database Systems [Textbook]

October 5 : Tuesday

MS Access Lab 3 Quiz due 

Assignment details

October 6 : Wednesday

Lecture: Relational Modelling 

HW 3: 4.18, 4.21 due 

Assignment details

HW 4: 5.16, Fig 4.9 assigned 

Due on October 18

Assignment details

Homework 3 : 4.18, 4.21 due 

Assignment details

October 8 : Friday

Lab: MS Access 5: Forms and Reports 

Resources

Lab Description

Quiz 5 assigned 

Due on October 19

Assignment details

October 11 : Monday

Lecture: SQL 

October 12 : Tuesday

Quiz 4 due 

Assignment details

October 13 : Wednesday

Lecture: SQL 

October 15 : Friday

Lab: Holiday: No Lab 

October 18 : Monday

Lecture: SQL 

HW 4: 5.16, Fig 4.9 due 

Assignment details

HW 5: 6.16 (e-j), 6.17 assigned 

Due on November 1

Assignment details

October 19 : Tuesday

Quiz 5 due 

Assignment details

October 20 : Wednesday

Lecture: SQL 

October 22 : Friday

Project 1 Presentations due 

Assignment details

Project 2 Proposals assigned 

Due on October 27

Assignment details

Lab: Project 1 Presentations 

October 25 : Monday

Lecture: Functional Dependencies 

October 27 : Wednesday

Lecture: Functional Dependencies 

Project 2 Proposals due 

Assignment details

Project 2 Presentations assigned 

Due on December 6

Assignment details

October 29 : Friday

Lab: Project 2 

November 1 : Monday

Lecture: Normalization Theory 

HW 5: 6.16 (e-j), 6.17 due 

Assignment details

November 3 : Wednesday

Lecture: Normalization Theory 

November 5 : Friday

Lab: Project 2 

November 8 : Monday

Lecture: Review 

November 10 : Wednesday

Midterm Exam 

2:00pm-3:00pm, 3111 Etcheverry Hall

November 12 : Friday

Lab: Project 2 

November 15 : Monday

Lecture: Normalization Theory 

November 17 : Wednesday

Lecture: Normalization Theory 

November 19 : Friday

Lab: Project 2 

November 22 : Monday

Lecture: Normalization Theory 

November 24 : Wednesday

Lecture: Normalization Theory 

November 29 : Monday

Lecture: Temporal Databases 

December 1 : Wednesday

Lecture: Database Security 

December 3 : Friday

Lab: Project 2 

December 6 : Monday

Lecture: Project 2 Presentations 

Project 2 Presentations due 

Assignment details

December 8 : Wednesday

Lecture: Project 2 Presentations 

December 13 : Monday

Lecture: Holiday: Reading Day 

December 15 : Wednesday

Final Exam 

2:00pm-3:00pm, 3111 Etcheverry hall

last updated on 2004-09-29 by Lisa