Course Outlines

Learning Resources

Required:
Coronel, Morris, Rob. Database Systems Design, Implementation, and Management, 9th ed.Thompson Publishing, 2011.

Evaluation Criteria

Criteria	%	Comments
Assignments and Discussions	15
Term Project	15
Midterm Exam	35
Final Exam	35
TOTAL	100

Course Specific Requirements

The following statements are in accordance with the BCIT Policies 5101, 5102, 5103, and 5104, and their accompanying procedures. To review these policies and procedures, please refer to: www.bcit.ca/about/administration/policies.shtml

PTS Attendance/Illness:
Attendance in lectures and labs is mandatory and recorded. In case of illness or other unavoidable cause of absence, the PTS student must communicate as soon as possible with his/her Instructor indicating the reason for the absence. Prolonged illness which causes the student to miss 20% of the lessons must have a BCIT medical certificate sent to the department. Excessive absence of 20% or more may result in failure or immediate withdrawal from the course or program. Please see BCIT Policy 5101 - Student Regulations, and accompanying procedures

Computer and IT Use Policy:
School of Computing has zero tolerance on abusing BCIT resources in any of the following ways:

1. Down loading or saving large files or unlicensed software, movies, and music.
2. Creating any denial of service situations that render BCIT computers unstable.
3. Obtaining, by any means, unauthorized passwords, data, programs or mailing lists.
4. Displaying items containing text or imagery considered offensive by any group or gender.
5. Non-course activities such as messaging, chat, playing games or using social media tools.

Students found engaging in any of these activities could lose computer access and or be removed from class.
For further information, see BCIT Policy #3501 – Responsible Use of Information Technology.

Academic Misconduct:
Violations of academic integrity, including dishonesty in assignments, examinations, or other academic performances are prohibited and will be handled in accordance with Policy 5104 — Academic Integrity and Appeals, and accompanying procedures: BCIT Policy #5104 - Academic Integrity and Appeals

Attempts:
Students must successfully complete a course within a maximum of three attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts will not be eligible to graduate from their respective program.

Assignment Details
Makeup Tests, Exams or Quizzes: There will be no makeup tests, exams or quizzes. If you miss a test, exam or quiz, you will receive zero marks. Exceptions may be made for documented medical reasons or extenuating circumstances. In such a case, it is the responsibility of the student to inform the instructor immediately.

Course Outline Changes: The material or schedule specified in this course outline may be changed by the instructor. If changes are required, they will be announced in class or via email.

Late assignments/online submissions or projects will not be accepted except for proof of illness. No assignments/projects will be accepted after marked assignments or solutions to questions have been posted.

Midterm Exams, Final Exams, and Project Papers: The midterm exam, final exam, and final project will not be returned to the student

Assignments

Date	Material Covered	Readings	Assignment	Due Date
January 12	Introduction to Database Systems	Chapter 1	Exercise 1 Questions 1 Discussion 1	January 19
January 19	Relational Model	Chapters 2, 3	Exercise 2 Questions 2 Discussion 2	January 26
January 26	Entity Relationship Modeling	Chapter 4	Exercise 3 Questions 3 Discussion 3	February 2
February 2	Normalization Advanced Data Modeling	Chapters 5, 6	Exercise 4 Questions 4 Discussion 4	February 9
February 9	Peformance Tuning Data Warehouse Database Security	Chapters 11, 13, 15	Exercise 5 Questions 5 Discussion 5	February 23
February 16	Midterm Exam			February 16
February 23	Introductin to Structured Query Language (SQL)	Chapter 7	Exercise 7 Questions 7 Discussion 7	March 2
March 2	Structured Query Language	Chapter 7	Exercise 8 Questions 8 Discussion 8	March 9
March 9	Basic SQL	Chapter 7, 8	Exercise 9 Questions 9 Discussion 9	March 16
March 16	Advanced SQL	Chapter 8	Exercise 10 Questions 10 Discussion 10	March 23
March 23	Procedural SQl	Chapter 8	Term Project	March 30
March 30	Final Exam			March 30