News/Announcements (this is a record of e-mails sent to the course mailing list)
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)
Friday March 24, 2006 overheads of the presentation titled:Real World Database Design Issues
Overheads on Object Databases, have been uploaded on the course webpage.
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.
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.
Sun, 12 Mar 2006: Laurier co-op/internship available at IBM, contact person: Dr. N. Znotinas
Updated overheads on FDs, have been uploaded on the course webpage.
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.
The Final Examination Date for CP363 has been set to: Friday April 7, 2006 at 2:00 p.m. in Room N1044.
Updated overheads on SQL, have been uploaded on the course webpage.
The second assignment will be handed out on Wednesday February 1 in class
Additional Rel. Alg. examples
Sybase ASA tutorial
The first assignment will be handed out on Monday January 16 in class
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 email@example.com to book the Tutorial of your choice.
The CP363 Midterm will be held on Wednesday, February 15, 2006, in class
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
Fundamentals of Database Systems, 4/E Ramez Elmasri, Shamkant B. Navathe ISBN: 0-321-12226-7 Publisher: Addison-Wesley Copyright: 2004
Notes & Overheads
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
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
Winter Semester Timetable
| Mon | Wed | Fri | |11:30-12:20|11:30-12:20|11:30-12:20| | 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.
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.
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 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.
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.
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.
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!.