News/Announcements (this is a record of e-mails sent to the course mailing list)

  1. Monday April 3, 2006: CP363 2-hour review session. 
    11:30-12:20, N1044 (the usual room)
    12:30-13:20, DAWB 5-304 (Dr. Alvin Woods building, 5th floor)
  2.  Friday March 24, 2006 overheads of the presentation titled: 
    Real World Database Design Issues

  3. Overheads on Object Databases, have been uploaded on the course webpage.
  4. Mon, 20 Mar 2006: 
    Notes on Serializability have been uploaded on the course web page.
    This Friday March 24, we will have a presentation from a Sybase Consultant 
    (Solution Services, iAnywhere Solutions) in class.
  5. Sun, 12 Mar 2006:
    the CP363 3rd assignment (FDs, 2NF/3NF Normalization) will be handed out
    in class tomorrow. The due date is Friday March 24, 2006, before 12:30 p.m.
  6. Sun, 12 Mar 2006: 
    Laurier co-op/internship available at IBM, contact person: Dr. N. Znotinas
  7. Updated overheads on FDs, have been uploaded on the course webpage.
  8. Mon, 27 Feb 2006: 
    The CP363 Midterm marks are now available.
    You can pick up your paper from my office tomorrow and/or in class on Wednesday.
  9. The Final Examination Date for CP363 has been set to: 
    Friday April 7, 2006 at 2:00 p.m. in Room N1044.
  10. Updated overheads on SQL, have been uploaded on the course webpage.
  11. The second assignment will be handed out on Wednesday February 1 in class
  12. Additional Rel. Alg. examples 
  13. Sybase ASA tutorial
  14. The first assignment will be handed out on Monday January 16 in class
  15. CP363 Sybase ASA Tutorials
    Room: N2095
    Tutorial I,     Wednesday       January 25      12:30-1:30
    Tutorial II,    Thursday        January 26      12:00-1:00
    send e-mail to:  Wegdan Abdelsalam wabdelsalam@wlu.ca
    to book the Tutorial of your choice.
  16. The CP363 Midterm will be held on Wednesday, February 15, 2006, in class

Course Description

The course provides an introduction to the basic features of Database Management Systems (DBMS), focusing on Relational Database Management Systems (RDBMSs). Students will obtain an understanding of how the different components of a DBMS system fit together. They will write programs to interact with a particular DBMS as a case study.

Prerequisites CP264 (Data Structures II) or permission of the Depatment

Course Staff

Course Textbook

Fundamentals of Database Systems, 4/E 
Ramez Elmasri, Shamkant B. Navathe
ISBN: 0-321-12226-7
Publisher: Addison-Wesley
Copyright: 2004

Notes & Overheads

  1. Introduction
  2. ER (Entity-Relationship Data Model) 
  3. EER (Extended/Enhanced Entity-Relationship Data Model) 
  4. Relational Data Model, Relational Algebra 
  5. Relational Algebra
  6. Relational Constraints
  7. SQL (Structured Query Language)
  8. JDBC
  9. JDBC (.pdf file)
  10. Tuple Relational Calculus 
  11. Functional Dependencies + Normalization
  12. Transactions
  13. Serializability
  14. Transactions/Serializability Figures
  15. Object Databases
  16. Recovery
  17. ER/EER to Relational Figures

Textbook Support Web Site   A link to the textbook's support web page is available at: http://www.aw-bc.com/

Course Website   A link to the course web page is available at: http://sauron.wlu.ca/kotsireas/teaching.html

Lecture Topics

Databases Concepts and Architecture, Entity/Relationship (ER) Model, Extended Entity/Relationship (EER) Model, Object Model, Universal Modeling Language (UML), Relational Databases, Structured Query Language (SQL), ER to Relational and EER to Relational, Examples of Relational Database Management Systems (RDBMS), Object-Oriented Databases, Functional Dependencies and Normal Forms, Transactions, Database Recovery, Database Security

Class Schedule

Winter Semester Timetable

              |   Mon     |    Wed    |    Fri    |
	      |	  N1044   |   N1044   |   N1044   |   
              |           |           |           |
Week 1:       |           |   Jan 4   |   Jan 6   |            
Week 2:       |  Jan 9    |   Jan 11  |   Jan 13  |   
Week 3:       |  Jan 16   |   Jan 18  |   Jan 20  |
Week 4:       |  Jan 23   |   Jan 25  |   Jan 27  |  
Week 5:       |  Jan 30   |   Feb 1   |   Feb 3   |
Week 6:       |  Feb 6    |   Feb 8   |   Feb 10  |
Week 7:       |  Feb 13   |   Feb 15* |   Feb 17  |
Reading Week  |   Feb 20 - Feb 24   N o   C o u r s e s 
              |           |           |           |
Week 8:       |  Feb 27   |   Mar 1   |   Mar 3   |
Week 9:       |  Mar 6    |   Mar 8   |   Mar 10  |
Week 10:      |  Mar 13   |   Mar 15  |   Mar 17  |
Week 11:      |  Mar 20   |   Mar 22  |   Mar 24  |
Week 12:      |  Mar 27   |   Mar 29  |   Mar 31  | 
              |           |           |           |
              |  Apr 3    |           |           |

Course Requirements/Student Evaluation

The Movie database may be accessed from the CP363 Movie Database web page, which allows you to execute SQL queries against the Movie database. The structure of the Movie database is given on the CP363 Movie Database Structure web page.

New Course Drop Dates 2005/2006

September 9: final day to cancel Fall term and Fall/Winter session registration with no tuition charge (cancellation fee applies)
September 23: final day to drop 12-week and fall/winter session course(s) or withdraw at 10% tuition charge
November 7: final day to drop course(s) or withdraw from 12-week course(s) without failure and for tuition adjustment
January 2: final day to cancel Winter term registration with no tuition charge (cancellation fee applies)
January 16: final day to drop 12-week winter term course(s) or withdraw at 10% tuition charge
March 6: final day to drop course(s) or withdraw from two-term or 12-week Winter term course(s) without failure and for tuition adjustment

            or See: http://www.wlu.ca/calendars/dates.php?cal=1&y=3


The Academic Date section of the Calendar (Printed and Web Site Versions) clearly states the examination date period for each semester. Students must note that they are required to reserve this time in their personal calendars for the examinations. The examination period for this course is April 6 - April 27, 2006. Students who are considering registering to write MCAT, LSAT or GMAT or a similar examination, should select a time for those examinations that occurs outside the University examination period. For additional information that describes the special circumstances for examination deferment, consult the University calendar.

Consult the University Calendar.

Student Awareness of the Accessible Learning Office

Students with disabilities or special needs are advised to contact Laurier's Accessible Learning Office for information regarding its services and resources. Students are encouraged to review the University Calendar for information regarding all services available on campus. The Accessible Learning website can be found at http://waterloo.mylaurier.ca/accessible.htm.

Academic and Research Misconduct

Academic misconduct is an act by a student, or by students working on a team project, which may result in a false evaluation of the student(s), or which represents a deliberate attempt to unfairly gain an academic advantage. Please refer to page 99 of the 2005/2006 Undergraduate Calendar or see http://www.wlu.ca/calendars/section.php?cal=1&s=73&sp=139&ss=162&y=3 for full details.

Plagiarism Detection Software

Wilfrid Laurier University uses software that can check for plagiarism. Students may be required to submit their written work in electronic form and have it checked for plagiarism.

WLU Foot Patrol

The Foot Patrol is a service provided to evening students by students. If you feel unsafe walking home or uncomfortable walking to your vehicle, call WLU FOOT PATROL and someone will escort you. Ext. 3668 or 886-FOOT.

STEP: Science and Technology Endowment Program

The Program was established in 1995, with the opening of the New Science Building. Students in the Departments of Biology, Chemistry, Physics and Computer Science and Psychology approved a voluntary student contribution program designed to enhance educational experience and opportunities of undergraduate students in these areas. GET INVOLVED!.