CP363, Databases I, Winter 2005, Department web page

Class Test IV, Monday April 4, 2005, 11:30 - 12:20 Room BA111


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. Tuple Relational Calculus 
  10. Functional Dependencies + Normalization
  11. Transactions
  12. Recovery

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      |
              |11:30-12:20|11:30-12:20 |11:30-12:20  |        
	      |	  BA111   |   BA111    |   BA111     |
              |           |            |             |
Week 1:       |           |   Jan 5    |   Jan 7     |            
Week 2:       |  Jan 10   |   Jan 12   |   Jan 14    |   
Week 3:       |  Jan 17   |   Jan 19   |   Jan 21    |
Week 4:       |  Jan 24   |   Jan 26   |   Jan 28    |  
Week 5:       |  Jan 31   |   Feb 2    |   Feb 4     |
Week 6:       |  Feb 7    |   Feb 9    |   Feb 11    |
Week 7:       |  Feb 14   |   Feb 16   |   Feb 18    |
Reading Week  |   Feb 21 - Feb 25   N o   C o u r s e s 
              |           |            |             |
Week 8:       |  Feb 28   |   Mar 2    |   Mar 4     |
Week 9:       |  Mar 7    |   Mar 9    |   Mar 11    |
Week 10:      |  Mar 14   |   Mar 16   |   Mar 18    |
Week 11:      |  Mar 21   |   Mar 23   |   Mar 25    |
Week 12:      |  Mar 28   |   Mar 30   |   Apr 1     | 
              |           |            |             |
              |  Apr 4    |            |             |

Course Requirements/Student Evaluation

  1. Additional RA, SQL, JDBC material (movies2005.pdf)

  2. Additional RA, SQL, JDBC material (JDBC.pdf)

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.

Group Project

New Course Drop Dates 2004/2005:
September 10: final day to cancel Fall term and Fall/Winter session registration with no tuition charge (cancellation fee applies).
September 24: final day to drop 12-week and Fall/Winter course(s) or withdraw at 10% tuition charge.
November 8: final day to drop course(s) or withdraw from 12-week course(s) without failure and for tuition adjustment.
January 3: final day to cancel Winter term registration with no tuition charge (cancellation fee applies).
January 17: final day to drop 12-week course(s) or withdraw at 10% tuition charge.
March 7: final day to drop course(s) or withdraw from two-term or 12-week Winter term course(s) without failure and for tuition adjustment.

Examination Deferrals:
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 8-27, 2005. 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.

Student Awareness of the Special Needs Office:
Students with disabilities or special needs, are advised to contact Laurier's Special Needs Office for information regarding its services and resources. Students are encouraged to review the Calendar for information regarding all services available on campus.

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. Academic misconduct includes: please refer to page 98 in the 2004/2005 Undergraduate Calendar.

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.

STEP: Science & 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!