Tentative Schedule of Coverage in CS6400

WEEK STARTS TOPICS CHAPS.

Week1 Aug 24 Overview of DB Technology 27

Basic Concepts 1,2

Week2 Aug31 Basic Concepts (contd.) 1,2

Conceptual DB Modeling 3

Week3 Sept 7 ER,EER, Advanced Modeling 3,4,23

Relational Model and Algebra 7

QUIZ on selected chapter(s)

Week4 Sept 14 Relational Model (contd.) 7

SQL, Rel Calculus 8,9

Reading: Chapter 10

HW on Rel Algebra, SQL

Week 5 Sept 21 Rel Design, Normalization 14,15

QUIZ on selected chapters

Dependency Theory, Decomposition 14,15

Week 6 Sep 28 MIDTERM I

Database design process 16

Week 7 Oct 5 Query Optimization 18

Reading: Chapters 5,6 (files) ,17 (catalog)

HW on Query Optmization

Week 8 Oct 12 Query optimization and DB tuning 16,18

Transaction Concepts 19

Week 9 Oct 19 Relational Design 15

Week 10 Oct 26 H.W. 3 (assign : Oct 28, Due:Nov. 4)

Query Optimization 18

Week 11 Nov 2 Guest (Leo Mark), Quiz on temporal DB 23

Week 12 Nov 9 Query Opt., Midterm II: Nov11

Week 13 Nov 16 Complete Query Processing 18

( review 18.4 sections not covered)

Transaction Processing Concepts 19

Week 14 Nov 23 Transaction Processing(contd.)

Quiz on Nov 30 - Ch 19

Week 15 Nov 30 Complete Trans Proc.

Concurrency Control Techniques 20

H.W. 4 - Chapter 20, 21

Week 16 Dec 7 Complete Conc control

Database Recovery Techniques 21

FINAL EXAM : Thursday 16th - 8 a.m. - 10:40 a.m. (CoC 102).

GRADUATING STUDENTS:
Dec 7: Papers and/or projects due

OTHER STUDENTS:

Dec 9 : HW 4 is due. (Will be partially graded)

Dec 13: papers /projects due. For projects, plan on showing myself/Waigen

a demo and show your work. during this week. Report should have :

objectives, implementation approach, design details;

source code should be attached.