Schedule

For This Class

For Next Class

Class #

Date

Topic

Turn In

Lecture Videos

Read

Resources

1

Jan. 15

Introduction and Class Mechanics

2

Jan. 22

Relational Database

Assignment 1

Part I, Part II

Chapter 1, Papers 1, 3, 4

3

Jan. 23

Relational Data Languages I

Assignment 2

Part II, Part III, Part IV, Part V, Part VI

Chapter 2, sections 2.1 to 2.7 Papers 5, 6

Script to Create Sample Database

Guide to Free Oracle

A Guide to Learning APEX

4

Jan. 29

Relational Data Languages II

Assignment 3

Part VII, Part VIII, Part IX, Part X

Chapter 2, sections 2.8 to 2.10

5

Feb. 5

Normalization

Assignment 3

Part I, Part II, Part III, Part IV, Part V, Part VI, Part VII, Part VIII, Part IX, Part X

Chapter 3, Papers 7, 9, 11

Script to Create Extended EMP Database, Class Examples

6

Feb. 12

Assignment 4

7

Feb. 19

Data Modeling

Assignment 5

Part I, Part II, Part III, Part IV, Part V, Part VI, Part VII, Part VIII

Chapter 4, Paper 10

8

Feb. 26

Data Modeling Colloquium I

Assignment 6

9

Mar. 5

Data Modeling Colloquium II

Your PPT

Mar. 12

Spring Break

10

Mar. 19

Completion of Data Modeling Colloquium

Architecture of a DBMS

Assignment 7

Part I, Part II, Part III, Part IV, Part V, Part VI, Part VII

Chapter 5, Paper 12

11

Mar. 26

Mid-Term Exam

12

Apr. 2

Query Processing and Performance

Assignment 8

Part I, Part II, Part III, Part IV

Chapter 8, Papers 12, 13, 14

13

Apr.9

Query Processing and Performance

Assignment 9

Chapter 7, Paper 15

14

Apr. 16

Transaction Processing, Recovery

Assignment 10

Part I, Part II, Part III, Part IV, Part V

Chapter 7

15

Apr. 23

OLAP, Database in the Enterprise

Assignment 11

Part I, Part II, Part III, Part IV, Part V

Part I, Part II

Chapter 6

May 7

Final Exam