==========================================================================
                CSI3317 --  Database Management Systems
   
                        Iluju Kiringa
                    ++1-613-5625800x2164
                   kiringa@site.uottawa.ca

General Information
Professor:  Iluju Kiringa  
Email: kiringa@site.uottawa.ca  
Course Information Sheet: Short version of this page with course info  
Office Hours:  Wednesdays 1-2:30PM (To be increased on rush days)  
Office:  SITE Building 5072  
Lectures:  Wed 10-11:30AM; Fri 8:30-10AM in Montpetit 207 
Notes Online:  Most material for this course is available here 

Tutorials Online:  Specific announcements about on-line tutorials  
TAs:  To Be Announced 

---------------------------------------------------------------------------

Announcements:

Watch the announcements on the web for homeworks, due dates for assignments, 
exam dates and locations, and the like.

Overview and Outline

Overview. Views of data at different levels. Entity-relationship modelling. 
The relational data model. Relational algebra and calculi. Relational 
database languages. Integrity constraints and normal forms. Transactions 
and concurrency. Data storage structures. An introduction to logic-based 
and object-oriented data models. 

Prerequisites

Required is a solid knowledge of files structures at the level of CSI2131 
(or its French equivalent CSI2531). 

Course Outline

Week 1: Chapters 1 and 2 -- OVERVIEW OF DATABASE SYSTEMS and 
                            INTRODUCTION TO DATABASE DESIGN 
Week 2: Chapters 3 and 4 -- THE RELATIONAL MODEL, RELATIONAL ALGEBRA AND 
                            CALCULUS 
Week 3: Chapter 5 -- SQL: QUERIES, CONSTRAINTS, TRIGGERS 
Week 4: Chapters 6 and 7 -- DATABASE APPLICATION DEVELOPMENT; and 
                            INTERNET APPLICATIONS 
Week 5: Chapter 8 and selected sections of Chapters 9, 10, and 11 -- STORAGE 
                            AND INDEXING 
Week 6: Chapter 12 and selected sections of 
        Chapters 13, 14, and 15 -- QUERY EVALUATION 
Week 7: Chapter 16 and selected sections of Chapters 17, 
        and 18 -- TRANSACTION MANAGEMENT 
Week 8: Chapter 19 -- SCHEMA REFINEMENT AND NORMAL FORMS 
Week 9: Chapters 20 and 21 -- PHYSICAL DATABASE DESIGN AND TUNING; 
        and SECURITY AND AUTHORIZATION 
Week 10: Miscellanous topics from Chapters 24-30 -- OBJECT-DATABASE SYSTEMS, 
         DATA WAREHOUSING AND DECISION SUPPORT; and DATA MINING 
Weeks 11 and 12: buffer weeks 
Reading List: Text and References

Text book: 

Raghu Ramakrishnan and Johannes, Database Management Systems. 
3rd Edition, McGraw Hill, 2003. 

Further References: 

Silberschatz, Korth, and Sudarshan, Database System Concepts. 
4th Edition, McGraw Hill, 2002. 
Thomas Connolly, and Caroline Begg, Database Systems: a Practical Approach 
to Design, Implementation, and Management. 3rd Edition, Addison Wesley, 2003. 

Coursework and Marking Scheme

The final grade for this course will be made of 30% for assignments, 
25% for the mid-term, ans 45% for the final exam. 

Assignment 1: 10% 
Mid-term: 25% Date and time to be determined 
Assignment 2: 10% 
Assignment 3: 10% 
Final Exam: 45% See Univ. calender in due time 

Most material will be on the web. 

More info on the course web page.