Course Syllabus

CP363: Database I

Physics & Computer Science, Waterloo Campus

Fall 2019

Instructor Information

David Brown | Science Building, N2091
519-884-1970 x2711 | dbrown@wlu.ca
By Appointment

Course Information

Introduction to database systems. Topics include data models, query languages, database design, recovery and concurrency, integrity and security.

3 lecture hours

Credit: 0.50

Prerequisite: CP164 (or CP114)

Outline: https://bohr.wlu.ca/cp363/syllabus.php

URL: https://bohr.wlu.ca/cp363/

Section Information
Section Days Times Room Instructor
Lecture A MWF - BA202 Mr. David Brown

Course Overview and Approach

Introduction to database systems. Topics include data models, query languages, database design, recovery and concurrency, integrity and security.

Objectives

Course Tools and Learning Materials

The PCs in the public labs can be used by you for your assignments. We use the Python programming language and the Eclipse / PyDev IDE (Integrated Development Environment). We will provide you with more information about the computing facilities in your first lab.

Python is a programming language used extensively on the World Wide Web. Eclipse is an Integrated Development Environment (IDE) program. Together with the PyDev plug-in it eases the task of writing and executing programs written in Python. Python, Eclipse, and PyDev are all freely available from the Internet, and we provide instructions for downloading and installing them in the Resources section of this page.

You are responsible for storing all your assignment and lab work on your own memory sticks, Laurier network storage, or other media. We strongly suggest that you keep at least two copies of your work at all times, for memory sticks can fail, or be lost.

MyLearningSpace / Brightspace

Laurier Library

Centre for Student Success (writing centre, math centre, academic advising, study skills/supplemental instruction, accessible learning)

Student Evaluation

Evaluation Information
Assessment Weighting
Assignments 30%
2 Tests (in lecture) 30%
Final Exam 40%

Students must pass the final exam in order to pass the course.

Schedule

Note: this schedule is subject to change.

Schedule Information
Week Starting Topics Tests (In
Wednesday Lecture)
September 01 Database and Database Users
Database System Concepts and Architecture
 
September 08 The Relational Data Model and Relational Database Constraints
The Relational Algebra and Relational Calculus
September 15 SQL-99: Schema Definition, Constraints, Queries, and Views
September 22 Practical Database Design Methodology and Use of UML Diagrams
September 29 Functional Dependencies and Normalization for Relation Databases
October 06 Relational Database Design Algorithms and Further Dependencies Test 1,
October 13 Reading Week
October 20 Database Programming Using Python  
October 27 Introduction to Transaction Processing Concepts and Theory
November 03 Concurrency Control Techniques
Database Recovery Techniques
November 10 Database Security
Enhanced Data Models for Advanced Applications
November 17 Distributed Databases and Client-Server Architectures Test 2,
November 24 Other Topics
Emerging Database Technologies and Applications
OR Overview of Database Programming Using Object-Oriented Languages
 

University and Course Policies

  1. Academic Calendars: Students are encouraged to review the Academic Calendar for information regarding all important dates, deadlines, and services available on campus.

  2. Special Needs: Students with disabilities or special needs are advised to contact Laurier’s Accessible Learning Centre for information regarding its services and resources.

  3. Plagiarism: The University has approved the following wording for inclusion on all course syllabi about the use of the institutionally supported plagiarism software tool. Wilfrid Laurier University uses software that can check for plagiarism. If requested to do so by the instructor, students are required to submit their written work in electronic form and have it checked for plagiarism. (Approved by Senate May 14, 2002) .

  4. Academic Integrity: Laurier is committed to a culture of integrity within and beyond the classroom. This culture values trustworthiness (i.e., honesty, integrity, reliability), fairness, caring, respect, responsibility and citizenship. Together, we have a shared responsibility to uphold this culture in our academic and nonacademic behaviour. The University has a defined policy with respect to academic misconduct. As a Laurier student you are responsible for familiarizing yourself with this policy and the accompanying penalty guidelines, some of which may appear on your transcript if there is a finding of misconduct. The relevant policy can be found at Laurier's academic integrity website along with resources to educate and support you in upholding a culture of integrity. Ignorance is not a defense.

  5. Final Examinations: Students are strongly urged not to make any commitments (i.e., vacation) during the examination period. Students are required to be available for examinations during the examination periods of all terms in which they register.

  6. Foot Patrol, the Wellness Centre, and the Student Food Bank:

Resources

MySQL
A free SQL database.
HeidiSQL
A front end for MySQL.

The educational materials developed for this course, including, but not limited to, lecture notes and slides, handout materials, examinations and assignments, and any materials posted to MyLearningSpace, are the intellectual property of the course instructor. These materials have been developed for student use only and they are not intended for wider dissemination and/or communication outside of a given course. Posting or providing unauthorized audio, video, or textual material of lecture content to third-party websites violates an instructor's intellectual property rights, and the Canadian Copyright Act. Recording lectures in any way is prohibited in this course unless specific permission has been granted by the instructor. Failure to follow these instructions may be in contravention of the university's Code of Student Conduct and/or Code of Academic Conduct, and will result in appropriate penalties. Participation in this course constitutes an agreement by all parties to abide by the relevant University Policies, and to respect the intellectual property of others during and after their association with Wilfrid Laurier University.

© 2019 David Brown. All Rights Reserved.

Last updated: