Date  

Lecture Topics

Assigned Readings

Other Assignments & Comments

27-Aug, Mon

Syllabus, Introduction to Databases

Ch.1.1-6

Refer to your handout+ Fill out: Let's meet, Read: My General Class Guidelines

29-Aug, Wed

Basic Concepts and Architectures

Ch. 2.1-3, 2.5-7.

Refer to your handout

31-Aug, Fri

 CLASS CANCELLED

Read Next Handout! Happy Labor Day!

3-Sep, Mon

Labor Day holiday (no classes)

5-Sep, Wed

DBMS at work

Ch. 2.4

7-Sep, Fri

Exam 1 (5%) + Intro to Data Modeling (1)

Ch. 3.1-4

The exact date has been decided! Exam covers: ALL readings, handouts, questions, etc. STUDY HARD!!!!

10-Sep, Mon

Data Modeling (1) - cont.

Ch. 3.1-4

Read Handouts! Read example in the textbook.

12-Sep, Wed

Data Modeling (2)

Ch. 3.5-9

There can be a Quiz today!

14-Sep, Fri

Review on ER + Practice: My Music Database Design

17-Sep, Mon

Intro to EER Model

Ch. 4

19-Sep, Wed

EER Model (2)

Ch. 4

21-Sep, Fri

Relational Database Model

Ch. 5

24-Sep, Mon

26-Sep, Wed

Review of your homework + Intro To Relational Algebra

28-Sep, Fri

Intro To Relational Algebra - cont.

Ch. 6.1-3

1-Oct, Mon

Relational Algebra and Calculus

Ch. 6.3-4

3-Oct, Wed

Relational Algebra and Calculus- cont.

Ch. 6.5-7

5-Oct, Fri

Relational Algebraand Calculus- practice

8-Oct, Mon

Mapping of ER-Model to Relational Model

Ch. 7.1-2 

10-Oct, Wed

Mapping of EER-Model to Relational Model

Ch. 7.2-3 

12-Oct, Fri

Functional Dependencies

Ch. 10.1-2 

15-Oct, Mon

Normalization

Ch. 10.3-6, 11-Intr 

17-Oct, Wed

Review + About your projects

Frequent Errors made in projects

19-Oct, Fri

Structured Query Language 1

 Ch. 8-8.2 

22-Oct, Mon

Structured Query Language 2

Ch. 8.3-8.4 

24-Oct, Wed

Exam 2 (15% of final grade)

The exact date has been decided!

26-Oct, Fri

Structured Query Language 3

Ch. 8.5-8.8 

SQL Homework is here. SQL script needed for this homework is here.

29-Oct, Mon

Structured Query Language 3 - cont.

Ch. 8.5-8.8 

How to access MySQL DBMS 

31-Oct, Wed

Structured Query Language 3 - cont.

2-Nov, Fri

Structured Query Language 4

Ch. 9

5-Nov, Mon

File Organization

Ch. 13 

7-Nov, Wed

Indexing Files and B-trees

Ch. 14-14.2

Last 2 examples in larger format are here. There are also in your textbook.

9-Nov, Fri

 SQL Homework is due at the beginning of the class. 

12-Nov, Mon

Veterans' Day (no classes)

14-Nov, Wed

More on B+Trees

16-Nov, Fri

Query Processing

Ch. 15

19-Nov, Mon

Query Processing - cont. 

Ch. 15

21-Nov, Wed

Thanksgiving Day holiday (no classes)

23-Nov, Fri

Thanksgiving Day holiday (no classes)

26-Nov, Mon

Database Tuning (not on the Exam 3)

Ch. 16

28-Nov, Wed

Exam 3 (15% of final grade)

The exact date has been decided!

30-Oct, Fri

ERD in larger format

3-Dec, Mon

Project Demos

Rules for your presentations

5-Dec, Wed

Project Demos

7-Dec, Fri

Project Demos

14-Dec, Fri

8-9:50 AM - FINAL EXAM (20%) in EPS 108