SYLLABUS FOR AUTUMN 2003
------------------------

When (approx)      Topic

Class 1:      Chapter 1  Introduction    
Class 2-5     Chapter 3  Relational Model  
Class 6-10    Chapter 4  SQL  
Class 11-13   Chapter 5  Other Relational Languages  
Class 14-16   Chapter 2  Entity-Relationship Model  
Class 17-18   Chapter 6  Integrity and Security  
Class 19-23   Chapter 7  Relational Database Design  
Class 24      Appendix C  Advanced Normalization  
Class 29-31   Chapter 10  XML  
Class 32      Chapter 15  Transactions 


NONDETAILED COVERAGE OF THE FOLLOWING CHAPTERS  (You must 
read the entire chapter or specified sections at least once, 
to get key ideas, but I won't ask very detailed questions)

    Chapter 8  Object-Oriented Databases  
    Chapter 9  Object-Relational Databases  
    Chapter 21 Everything except:
		  21.5  E-commerce
		  21.6  Legacy Systems
    Chapter  22

COVERAGE ONLY FROM DISCUSSION IN CLASS
(no need to read the chapters, if you attended class just read class
notes, you can read relevant slides too)
    Chapter 11:  Slides on disk systems and RAID (from Sections 11.2 and 11.3)
    Chapter 12:  Slides on B-trees  (from Section 12.3)
    Chapter 16:  Slides on two-phase locking (from Section 16.1)
    Chapter 17:  Slides on log-based recovery (from Section 17.4)