CP363 DATABASES I, WINTER 2007, WLU

Announcements

  1. First assignment handed out in class. Wed. Jan. 17, 2007
  2. Labs will be held on Friday Jan. 26 and Fri. Feb. 2, in N2085 from 12:30 - 1:30
  3. Second assignment handed out in class. Mon. Feb. 5, 2007
  4. Midterm Solutions, Fri. Feb. 16, 2007
  5. First assignment marked/returned. Fri. Feb. 16, 2007
  6. UniversitySchemaTuplesQueries Fri. Feb. 16, 2007
  7. Third assignment handed out in class. Wed. Mar. 14, 2007
  8. Review Session: BA112, Monday, April 9th, 10:00-12:00 a.m.
  9. BANK Schema Wed. Mar. 28, 2007
  10. A2A3

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, 5/E 
Ramez Elmasri, Shamkant B. Navathe
Publisher: Addison-Wesley
Copyright: 2007
ISBN-10: 0321369572 
ISBN-13: 9780321369574 

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. Serializability
  13. Object Databases
  14. 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 (corresponding to the 12 weeks schedule)

  1. Introduction, Database System Concepts and Architecture CH1, CH2
  2. Entity/Relationship (ER) Model CH3
  3. Extended Entity/Relationship (EER) Model CH4
  4. Relational Data Model, Relational Databases, Examples of Relational Database Management Systems (RDBMS), Relational Algebra (RA) CH5, CH6
  5. Structured Query Language I (SQL) CH8
  6. Structured Query Language II (SQL)
    Additional SQL examples on diferrent relational database schemas
  7. ER-to-Relational Mapping, EER-to-Relational Mapping
    CH7
  8. Functional Dependencies (FDs), Normal Forms (NFs), Normalization CH10
  9. Algorithms for Relational Database Scheme Design, Multivalued and Join Dependencies CH11
  10. Object Databases CH20, CH21
  11. Transactions, Schedules CH17
  12. Concurrency Control Techniques, Database Recovery Techniques CH18, CH19

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 03   |   Jan 05    |
Week 2:       |  Jan 08     |    Jan 10   |   Jan 12    |
Week 3:       |  Jan 15     |    Jan 17   |   Jan 19    |
Week 4:       |  Jan 22     |    Jan 24   |   Jan 26    |
Week 5:       |  Jan 29     |    Jan 31   |   Feb 02    |
Week 6:       |  Feb 05     |    Feb 07   |   Feb 09    |
Week 7:       |  Feb 12     |    Feb 14   |   Feb 16    |
______________|_____________|_____________|_____________|______
              |
Reading Week  |   Feb 19 - Feb 23   N o   C o u r s e s
______________|_____________________________________________
              |             |             |             |
Week 8:       |  Feb 26     |   Feb 28    |   Mar 02    |
Week 9:       |  Mar 05     |   Mar 07    |   Mar 09    |
Week 10:      |  Mar 12     |   Mar 14    |   Mar 16    |
Week 11:      |  Mar 19     |   Mar 21    |   Mar 23    |
Week 12:      |  Mar 26     |   Mar 28    |   Mar 30    |
              |  Apr 02     |    ---      |    ---      |
______________|_____________|_____________|_____________|______
              |             |             |             |

Course Requirements/Student Evaluation

New Course Drop Dates 2006/2007:

September 8: final day to cancel Fall term and Fall/Winter session registration with no tuition charge (cancellation fee applies)
September 22: final day to drop 12-week and fall/winter session course(s) or withdraw at 10% tuition charge
November 6: 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

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 9-27, 2007. 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 Accessible Learning Centre:

Students with disabilities or special needs, are advised to contact Laurier.s Accessible Learning Centre 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 111 in the 2006/2007 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!