Faculty of Science Home Page University of Alberta Home Page

CMPUT 391 DATABASE MANAGEMENT SYSTEM Course Outline

General Information

Term: Winter 2008, Lecture B1
Date and Time: MWF at 11:00-11:50
Location: CSC B 2
Number of credits: 3 credits

Labs
Date and Time: H01 - W 14:00-16:50; H02 - R 14:00-16:50
Location: CSC 219

Contact

Instructor: Li-Yan Yuan

Office: ATH 356
Phone: 492-7171
E-mail: yuan@cs.ualberta.ca

Office Hours: M.W. 13:00-14:00

Teaching Assistant

Sajib Barua E-mail: sajib@cs.ualberta.ca
Pirooz Chubak E-mail: pchubak at cs dot ualberta dot ca

Newsgroup: CMPUT 391 Newsgroup]
Mailing List: c391@ugrad.cs.ualberta.ca]

View more contact information.

Overview

This is a second course in our two-course serial on the database management systems. The first course (CMPUT 291) introduces the basic concepts and elements of file and database systems while this course covers the following advanced aspects of database management systems:

  • The modern database management systems and emerging database technologies and applications that address new challenges to database and information management systems.
  • The database system architecture and the main implementation techniques of database management systems (DBMSs).
  • Web-based database application systems.

Objectives

You are expected to understand basic concepts in all these advanced aspects as well as as to get some practical hand-on experience with commercial database management systems through a small project of designing and implementing a database application system with the web

Pre-requisites

CMPUT 204 and CMPUT 291.

Course Topics

  • Object-oriented and object-relational databases
  • Triggers and active databases
  • Network Storage Systems
  • Web-based database applications
  • Normalization, relational database design methods and algorithms
  • Query processing and optimization
  • Transactions, concurrency control, recovery protocols
  • Security and authorization models
  • Data mining and data warehouse
  • XML Documents and information retrieval

Course Work and Evaluation

Final Exam
Course Work Date Weight
One Assignment See Assignment and Project 5%
One Project See Assignment and Project 35%
Midterm Exam February 25 25%
April 22 (tentative) 35%

See the course schedule for specific information, assignments and dates for course work.

Grading System

The final letter grade will probably be curved according to the distribution of the marks. See 61.6 University of Alberta Marking and Grading Guidelines.]

Deferred Exams

No re-examination except as per regulation. All the deferred Exams shall be approved by the University, and must be schedule before May 5, 2008. See §23.5.6, (GFC 29 SEP 2003).

Re-evaluation

Any questions or concerns about marks on a particular assignment or examination must be brought to my attention within 10 days of its return date. After that, I will not consider remarking or re-evaluating the work.

Course Materials

Textbook:

Policy

Course Outlines

Policy about course outlines can be found in Section 23.4(2) of the University Calendar.

Academic Integrity

The University of Alberta is committed to the highest standards of academic integrity and honesty. Students are expected to be familiar with these standards regarding academic honesty and to uphold the policies of the University in this respect. Students are particularly urged to familiarize themselves with the provisions of the Code of Student Behaviour (online at www.ualberta.ca/secretariat/appeals.htm) and avoid any behavior which could potentially result in suspicions of cheating, plagiarism, misrepresentation of facts and/or participation in an offense. Academic dishonesty is a serious offense and can result in suspension or expulsion from the University. (GFC 29 SEP 2003)

Collaboration

The University's policy on academic dishonesty will be strictly followed. DO collaborate and explain to others if necessary to help other students learn, but DO NOT GIVE machine-readable contents of your programs, or listings of any parts of the assignment answers to others so they can merely copy.

Excused Absences

No later assignment will be accepted, except for health reason in which cases, the mark will be evenly distributed to the rest of marks.

Department Policies

Refer to Department Policy to learn about:

  • Collaboration
  • Excused Absences
  • Conditions of Use

University Policies

The University of Alberta policies include, but are not limited to, the following: