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

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

General Information

Professor: Iluju Kiringa (kiringa@site.uottawa.ca)
Office Hours: Thursdays 12-1:30PM (Increased on rush days) SITE 5072

Lectures: 
Section A -- Tuesday 8:30-10:00AM in Sports Complex   Room: E218; 
             Friday 10:00-11:30AM in Sports Complex   Room: E218 
Section B -- Tuesday 11:30AM-1:00PM in Sports Complex   Room: E218; 
             Friday 1:00PM-2:30PM in Sports Complex   Room: E218 

Lecture Notes: available online 

Tutorials: available on-line; specific announcements will be made in class  

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

Announcements

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

Overview 

Views of data at different levels. Entity-relationship modelling. 
Relational data model. Relational algebra and calculi. Relational database 
languages. Application programming. Query processing. Transactions and 
concurrency. Data storage structures. Integrity constraints and normal forms. 
A few advanced topics such as Datawarehousing. 

Prerequisites

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

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

Course Outline and Schedule

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 --  
         DATA WAREHOUSING AND DECISION SUPPORT; and DATA MINING 
Weeks 11: buffer week 

Text book (required): 

Raghu Ramakrishnan and Johannes, Database Management Systems. 
3rd Edition, McGraw Hill, 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: 5% 
Mid-term: 25% (Sat 2005-10-15, 1:00 - 3:00)
Assignment 2: 5% 
Assignment 3: 5%
Group Project: 15% (To be done in groups of 3 people) 
Final Exam: 45% (See Univ. calender in due time) 

Submission instructions will be included in the assignment handouts. 
Do expect to have one assignment per month.

Late assignments will not be accepted more than 24 hours after deadlines. 
Only under very exceptional circumstances will I accept assignments 24 hours 
after deadlines. To submit an late assignment, submit it in the usual way 
and then send me an e-mail message or bring me a written justification. 

Assignments will be returned in class. Any disagreements with the grading  
should normally be submitted to the TA who marked the assignment within 
a week. Regrading requests submitted after one week may not be taken in 
consideration unless we made a substantial grading error.

Work submitted for regrading during the last two weeks of classes will not 
be returned until after the final exam. (You may wish to keep a photocopy 
of it before submitting it for regrading.) 

Plagiarism is considered very serious offense by all universities, including 
U of O, and I will treat it consequently. 

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

Contacting the professor 

When emailing me, please state clearly your full name in the body of the 
message, and also put "CSI 3317" in the title. This is VERY IMPORTANT if 
you want a reasonably quick answer from me.