CMPT 225, and (MACM 101 or (ENSC 251 and ENSC 252))

• Required Text:A First Course in Database Systems Jeffrey D.Ullman, Jennifer Widom, Prentice Hall, 2008, ISBN9780136006374.


• Helpful Reading: Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, McGraw Hill, 2003, ISBN: 9780072465631.

Technology-Enhanced Learning




Throughout this course, we’ll be using various technologies to help us communicate, assess your learning, and keep organized. They are all accessible via a central portal: Canvas.

• Required Clicker - Questions and polls will be integrated into almost every class. Clicker marks will be based on both participation and correctly answering the questions. To receive full credit, you must participate in and correctly answer to at least 90% of the exercises over the course. You can either use:-
  
  
  • iClicker remote - Remote can be purchased at the SFU Bookstore. You may share or borrow an iClicker remote from a student who is not in this course as long as you, consistently, use the same iClicker remote throughout the term. You must REGISTER your iClicker on our Canvas course website to receive the points you earn in the class. To Register
    1. Login to Canvas
    2. Click the iClicker registration link on the side navigation
    3. Click on Quizzes to fill out the iClicker consent form
  
  
  • iClicker Reef app - Download the REEF app. Enter your student id (your user id, i.e. tbrown) when you set up your account.

• Piazza

  Please limit emails to the instructor to items of a personal or confidential nature (e.g., illness). Problems with the CMPT 354 course contents (e.g., lecture, textbook, assignments) can be posted on Piazza , (anonymously if you prefer).All enrolled students should sign up and watch for important announcements.. Piazza will be monitored by course staff. Students are encouraged to answer questions, which will allow you to get better at articulating your opinions, providing support for your views, developing arguments, and listening and relating to the views of others.
  
  

Your performance in the class will be based on a number of activities. Final grades will be calculated as follows:

• 20% for Assignments
• 20% for the Project
• 20% for the Midterm Exam (Two midterm exams)
• 35% for the Final Exam
  
• 5% for Clickers
• 1% Bonus marks for active participation and answering questions on Piazza

Students must attain an overall passing grade on the weighted average of exams in the course to obtain a clear pass (C- or better).

Assignments

The course includes six assignments to be submitted electronically through Canvas. Students are encouraged to discuss assignment problems with each other and form study groups. However, final assignment submissions must be generated independently, and you will only receive credit for your work. Work submitted late is subject to a penalty of 10% per day late(e.g. An assignment evaluated at 80% but submitted two days late will be awarded a mark of 60%.).There is a minimum penalty of 10% for work handed in after 11:59 p.m. on the due date. Weekends count the same as weekdays. Assignments more than THREE (03) days late will not be accepted.No excuses for submitting assignments late will be accepted, except perhaps a doctor's note that says you were unable to finish the task anytime between when it was assigned and due.

Assignment	Weight	Tentative Due Date
Assignment 1	3%	May 25
Assignment 2	3%	June 1
Assignment 3	3%	June 13
Assignment 4	3%	June 27
Assignment 5	4%	July 13
Assignment 6	4%	July 30

Project

This course includes an obligatory group project. The project will be completed in groups of four. You need to self-enroll yourself in the group already created on Canvas. More information related to project can be found here.

Examinations

There will be two midterms and a final examination. You can use a handwritten cheat sheet, 1 (one) 8.5 x 11 sheet of notes for reference, both sides.

• Midterms will be held during class time. If you are unable to write a midterm (e.g., due to illness), you should obtain suitable documentation (e.g.doctor's note) and inform the instructor ASAP.
  • Midterm 1 (Date: Friday, June 15, Time : 10:30 - 11:20 AM)
  • Midterm 2 (Date: Monday, July 16, Time : 10:30 - 11:20 AM)
• Final Exam (Cumulative) (Date : Monday, 13 August, Time : 8:30 - 11:30 am; Location : TBA)

Illness and late policy

Please do not come to the class if you are very sick. It's not good for you and for the rest of us. Do contact the instructor by e-mail immediately when you know you will miss a graded assessment (e.g.,Exam/Project/Assignments).

Academic Honesty

Academic honesty plays a key role in our efforts to maintain a high standard of academic excellence and integrity. Students are advised that ALL acts of intellectual dishonesty will be handled in accordance with the SFU Academic Honesty and Student Conduct Policies.

Collaboration Policy

Students are encouraged to discuss the material in this course. We all learn better when we share thoughts/ideas with others. Unless explicitly told otherwise, you are to complete assignments independently. You must not look at other students' solutions, and you may not post your solutions to public websites or repositories.

Most well-known DBMS applications fall into the relational database management systems (RDBMS) category. Examples include MySQL, Oracle, MS SQL Server and SQL Lite. They all use Structured Query Language (SQL) to manipulate data. The difference between each database systems are the features and functionalities that they offer.

For assignments, we will use CSIL Microsoft SQL Server. The scripts will be provided, and you will be creating the tables in your database. The information related to the CSIL server can be found here. If you want to install a personal copy of SQL Server on your machine, you can use the link: https://www.microsoft.com/en-ca/sql-server/sql-server-downloads

For the group project, you can choose any relational database.

Problems with Computing Science Instructional Labs (CSIL) should be directed to helpdesk@cs.sfu.ca.