University of Waterloo

Term and Year of Offering: Spring 2019

Course Number and Title: CS338, Computer Applications in Business: Databases

Section Lecture Time Room Instructor
001 Tue & Thu 8:30AM-9:50AM MC 2017 Daniel Kaster
002 Tue & Thu 10:00AM-11:20AM MC 2017 Daniel Kaster

Instructor's Name Office Location Contact Office Hours
Daniel Kaster DC 3626 Tue 1:30 PM-3:00 PM

TA's Name Office Location Contact Office Hours
Sheshbolouki, Aida TBA Mon 1:00 PM-2:00 PM & Wed 11:00 AM-12:00 PM
Fung, Kin Pong TBA Mon 1:00PM-2:00PM
Gupta, Pranjal TBA Mon 1:00 PM-2:00 PM
Meng, Xiao TBA Wed 11:00 AM-12:00 PM
Ge, Chang TBA Wed 11:00 AM-12:00 PM

Course Description:

A user-oriented approach to the management of large collections of data. Methods used for the storage, selection and presentation of data. Common database management systems.

Course Objectives:

The main objective of this course is to introduce students to fundamentals and use of the database technology from the viewpoint of a database user. More specifically:

Course Overview:

  1. Why do we use databases?
  2. How do we design a database?
  3. How do we use a Database Management System?

Suggested text:

R. Elmasri and S. Navathe. Fundamentals of Database Systems (6th or 7th edition).


There will be three assignments, but these will not be marked. We will provide the solutions and you are encouraged to do them since they will help you check your understanding of the material, practice with the ideas, and prepare for the exams. However, up to 5 bonus points will be granted to students who hand the assignments to the professor (in paper and in class) at the due date.

The midterm exams and the final exam are closed-book. The final exam covers material from the whole term.

If you miss a midterm due to acceptable reasons (see university guidelines), its percentage will be added to the final exam. If you miss the final, you will need to take the exam in a future term consistent with university policy. Otherwise, there will be no makeup exams.

Reappraisal Policy:

For each exam, there will be a deadline by which reappraisal requests have to be registered. These deadlines will be indicated on the exam (usually one week after they are returned in class). No appeals will be considered after this deadline unless there is a medical or other excuse for absence during the appeal period.

Communication and Materials:

The course will use the LEARN system for all communication (CS 338 - Spring 2019). Please direct all communication to the LEARN course's forum. Important course information will be posted only in LEARN either as an announcement or as a forum topic/message. It is your responsibility to monitor all of these channels. Course materials (slides, assignments, etc.) will also be posted in LEARN.

If there is a good reason not to use the discussion forum (e.g., personal matters, a question that might reveal part of a solution, etc.), contact the TAs directly via regular email. TAs may decide that an email message is more appropriate for a discussion group and repost it there in anonymized form. Any email message sent from non-UW email accounts, like GMail or Hotmail, must clearly identify its sender. Students should include their full name, student ID, or UW username. The instructor and the TAs reserve the right to ignore email messages that do not follow this rule.

Mental Health Resources

Mental Health: If you or anyone you know experiences any academic stress, difficult life events, or feelings like anxiety or depression, we strongly encourage you to seek support.

On-campus Resources

Off-campus Resources

Diversity: It is our intent that students from all diverse backgrounds and perspectives be well served by this course, and that students' learning needs be addressed both in and out of class. We recognize the immense value of the diversity in identities, perspectives, and contributions that students bring, and the benefit it has on our educational environment. Your suggestions are encouraged and appreciated. Please let us know ways to improve the effectiveness of the course for you personally or for other students or student groups. In particular:

Academic Integrity

Academic Integrity: In order to maintain a culture of academic integrity, members of the University of Waterloo community are expected to promote honesty, trust, fairness, respect and responsibility. [Check for more information.]

Grievance: A student who believes that a decision affecting some aspect of his/her university life has been unfair or unreasonable may have grounds for initiating a grievance. Read Policy 70, Student Petitions and Grievances, Section 4. When in doubt please be certain to contact the department's administrative assistant who will provide further assistance.

Discipline: A student is expected to know what constitutes academic integrity [check] to avoid committing an academic offence, and to take responsibility for his/her actions. A student who is unsure whether an action constitutes an offence, or who needs help in learning how to avoid offences (e.g., plagiarism, cheating) or about 'rules' for group work/collaboration should seek guidance from the course instructor, academic advisor, or the undergraduate Associate Dean. For information on categories of offences and types of penalties, students should refer to Policy 71, Student Discipline. For typical penalties check Guidelines for the Assessment of Penalties.

Appeals: A decision made or penalty imposed under Policy 70 (Student Petitions and Grievances) (other than a petition) or Policy 71 (Student Discipline) may be appealed if there is a ground. A student who believes he/she has a ground for an appeal should refer to Policy 72, Student Appeals.

MOSS (Measure of Software Similarities) is used in this course as a means of comparing students' assignments to ensure academic integrity. We will report suspicious activity, and penalties for plagiarism/cheating are severe. Please read the available information about academic integrity very carefully.

Note for Students with Disabilities: AccessAbility Services, located in Needles Hall, Room 1401, collaborates with all academic departments to arrange appropriate accommodations for students with disabilities without compromising the academic integrity of the curriculum. If you require academic accommodations to lessen the impact of your disability, please register with AccessAbility Services at the beginning of each academic term.

Intellectual Property: Students should be aware that this course contains the intellectual property of their instructor, TA, and/or the University of Waterloo. Intellectual property includes items such as:

Course materials and the intellectual property contained therein, are used to enhance a student's educational experience. However, sharing this intellectual property without the intellectual property owner's permission is a violation of intellectual property rights. For this reason, it is necessary to ask the instructor, TA and/or the University of Waterloo for permission before uploading and sharing the intellectual property of others online (e.g., to an online repository).

Permission from an instructor, TA or the University is also necessary before sharing the intellectual property of others from completed courses with students taking the same/similar courses in subsequent terms/years. In many cases, instructors might be happy to allow distribution of certain materials. However, doing so without expressed permission is considered a violation of intellectual property rights.

Please alert the instructor if you become aware of intellectual property belonging to others (past or present) circulating, either through the student body or online. The intellectual property rights owner deserves to know (and may have already given their consent).