CP363 Review Lecture Material

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

Instructor   Ilias Kotsireas,  Office 2076A,
            Office Hours 24/7 and by appointment,  Phone 884-0710 ext. 2218  E-Mail

Ramez Elmasri, Shamkant Navathe 
Fundamentals of database systems, 3rd ed.
Reading, Mass. : Addison-Wesley, c2000.
Includes bibliographical references and index.
ISBN: 0805317554

Special Needs Office Announcement: 

The Special Needs Office is looking for a Note-taker for CP363, Databases I. There are many benefits in becoming a Note-taker. To find out how easy it is to provide this vital service, please go immediately to the Special Needs Office to apply. Flyers are available at my office to those who wish to found out more. Special Needs Office, Arts Building, Room 1C11, Monday to Friday, 8:30 a.m. to 4:30 p.m. (519) 884-0710 ext. 2715 (voice) (519) 884-1141 (TDD) e-mail: 22sno@wlu.ca

Notes & Overheads

  1. Introduction
  2. ER (Entity-Relationship Data Model) 
  3. EER (Extended Entity-Relationship)
  4. Relational Model + Relational Algebra I   
  5. Relational Constraints
  6. Relational Algebra II
  7. Additional Relational Algebra examples
  8. SQL
  9. JDBC
  10. Tuple Relational Calculus
  11. Functional Dependencies + Normalization

Textbook Support Web Site   A link to the book support web page is available at: http://www.aw.com/cs_supplements/

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      |
              | 8:30-9:20 | 8:30-9:20  | 8:30-9:20   |        
	      |	  N1044   |   N1044    |   N1044     |
              |           |            |             |
Week 1:       |  Jan 6    |   Jan 8    |   Jan 10    |            
Week 2:       |  Jan 13   |   Jan 15   |   Jan 17    |   
Week 3:       |  Jan 20   |   Jan 22   |   Jan 24    |
Week 4:       |  Jan 27   |   Jan 29   |   Jan 31    |  
Week 5:       |  Feb 3    |   Feb 5    |   Feb 7     |
Week 6:       |  Feb 10   |   Feb 12   |   Feb 14    |
              |           |            |             |
Reading Week  |   Feb 17 - Feb 21   N o   C o u r s e s 
              |           |            |             |
Week 7:       |  Feb 24   |   Feb 26   |   Feb 28    |
Week 8:       |  Mar 3    |   Mar 5    |   Mar 7     |
Week 9:       |  Mar 10   |   Mar 12   |   Mar 14    |
Week 10:      |  Mar 17   |   Mar 19   |   Mar 21    |
Week 11:      |  Mar 24   |   Mar 26   |   Mar 28    |
Week 12:      |  Mar 31   |   Apr 2    |   Apr 4     | 
              |           |            |             |

Midterm Examination    February 13, 2003,  5:30 p.m. -7 p.m. Room N1002 (Science Building)

Assignment Schedule

Final Examination

The final examination date will be announced as early as possible. The examination period for this course is April 9, 2003 to April 30, 2003. No examinations will be held on April 18, 2003 (Good Friday)

Final Examination Date/Time:  Thursday April 10, 2003  9:00 a.m. - 12:00 a.m. in A.C. 

Software available

SQL Anywhere 7.1 (Sybase Corporation)
SQL Anywhere runs as either a server or as a client. The department has SQL Anywhere servers on physcomp6 (an NT server), physcomp1 (a Solaris unix server), and sauron (the department web server). We have clients running on the PCs in the N2085 lab and on the Sun workstations in the N2095 lab. There are two front ends available: a Windows client (Sybase Central 3.2) and a Java client (Sybase Central 4.0). The Java version has more functionality than the Windows version, but its performance is somewhat less.

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.

Student Evaluation

Databases Research

A valuable source of information on cutting-edge research in databases is the http://www.vldb.org/ web-based archive.
It contains information on:

  1. the VLDB Conference Series (that have been held annually since 1975)
  2. the VLDB Journal by Springer (published since 1992)

VLDB stands for: Very Large Data Bases

New Course Drop Dates 2002/2003:

September 6: final day to cancel Fall term and Fall/Winter session registration with no tuition charge (cancellation fee applies).

September 20: final day to drop 12-week and Fall/Winter course(s) or withdraw at 10% tuition charge

November 4: 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 10: 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: (change dates according to term 1, 2 or Ĺ )

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 9-30, 2003. 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 74 in the 2002/2003 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.