========================================================================== CSI3317 -- Database Management Systems Iluju Kiringa ++1-613-5625800x2164 kiringa@site.uottawa.ca --------------------------------------------------------------------------- General Information Professor: Iluju Kiringa (kiringa@site.uottawa.ca) Office Hours: Tuesdays 12:00-1:00PM (Increased on rush days) SITE 5072 Lectures: Tuesday 8:30-10:00AM in Vanier Hall Room: 331; Friday 10:00-11:30AM in Vanier Hall Room: 331 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. Prerequisites Knowledge of files structures at the level of CSI2131 (or its French equivalent CSI2531). --------------------------------------------------------------------------- Course Outline and Schedule Chapters 1 and 2 -- OVERVIEW OF DATABASE SYSTEMS and INTRODUCTION TO DATABASE DESIGN Chapters 3 and 4 -- THE RELATIONAL MODEL, RELATIONAL ALGEBRA AND CALCULUS Chapter 5 -- SQL: QUERIES, CONSTRAINTS, TRIGGERS Chapters 6 and 7 -- DATABASE APPLICATION DEVELOPMENT; and INTERNET APPLICATIONS Chapter 8 and selected sections of Chapters 9, 10, and 11 -- STORAGE AND INDEXING Chapter 12 and selected sections of Chapters 13, 14, and 15 -- QUERY EVALUATION Chapter 16 and selected sections of Chapters 17, and 18 -- TRANSACTION MANAGEMENT Chapter 19 -- SCHEMA REFINEMENT AND NORMAL FORMS 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, and 45% for the final exam. Assignment 1: 5% Mid-term: 25% 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 for the next 3 months. Late assignments will not be accepted more than 48 hours after deadlines. Only under very exceptional circumstances will I accept assignments more than 48 hours after deadlines. To submit an late assignment, do so 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 one 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.