Contents

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:
on-line tutorials.
TAs:
Kanwar Hazrah (kanwar.hazrah@rogers.com),
and Laila Rissafi (lailarissafi@hotmail.com)

Announcements:

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

However, the most important announcements will be posted on this page:

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. The following outline is tentative and may slightly change during the term:

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

Reading List: Text and References

  1. Text book:
    • Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems. 3rd Edition, McGraw Hill, 2003.
  2. 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 course is based on the aforementioned textbook, and a set of slides that are available on the web. Note that the course has 2 sections, runned along with a French version. The content, coursework, and marking scheme for all of these versions of the course will be the same!

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% Wednesday October 22 2003, during lecture time in xclass
Assignment 2: 10%
Assignment 3: 10%
Final Exam: 45% See Univ. calender in due time

The final course grade will be computed as follows:

Assignments (A) 30 marks
Midterm Exam (M) 25 marks
Final Exam (F) 45 marks
Grade (G)
100 marks
 


If
then G=
M + F < 35 10 * (M+F) / 7
M + F >= 35 D + M + F

Assignments are submitted on the computer itself; you hand in a paper copy as well. Submission instructions are included on the assignment handouts.

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 assignment late, 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 tutorial. Any disagreements with the grade assigned should normally be submitted to a TA or to me within a week. Regrading requests submitted after that might be taken less seriously 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 photocopy it first.)

Plagiarism is considered very serious offense by the U of O, and I will treat it consequently. So avoid it!

Information Distribution

E-mail me about course matters using my adress given above. However, there is no guarantee of any particular response time. I will appoint tutors for dealing with specific

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.

Distribution of Information

Most material will be on the web.