CMPUT 291 - Introduction to File and Database Management - Course Outline
General Information
Term: Winter 2007, Lecture B1
TR, 11:00-12:20, at CSC B 10
Number of credits: 3 credits
Labs: H01: M 12:30-13:50, H02: T 14:00-15:00
H03: T 15:30-16:50, at CSC 219
Contact
Instructor: Li-Yan Yuan
Office: Ath 356
Phone: 492-7171
E-mail: yuan@cs.ualberta.ca
Office Hours: TR at 13:00-14:00
Teaching Assistant
Reza Sherkat E-mail: reza@cs.ualberta.ca
Ananth Venkateswaran,
E-mail: venkates@cs.ualberta.ca
Newsgroup: CMPUT 291 Newsgroup
Mailing List: c291@ugrad.cs.ualberta.ca
View more contact information.
Overview
This course introduces the basic concepts and elements of file management techniques and database management systems, including the relational database model, SQL language, and B-tree and hash tables.
Objectives
You are expected to understand the fundamental concepts as well as as to get some practical hand-on experience with commercial database management systems through programming assignments and a small project using Oracle and JDBC based user interface.Pre-requisites
CMPUT 115
Course Topics
- the entity-relational model
- the relational database model, relational algebra and calculus, SQL,
- relational database design,
- web-based database applications
- B-trees and hash tables
Course Work and Evaluation
| Course Work | Date | Weight |
|---|---|---|
| Three Lab Assignments | See Assignments | 21% |
| One Project | See Assignments | 15% |
| Two Lab Quizzes | Seecourse schedule | 4% |
| Midterm Exam | Feb. 27 | 24% |
| Final Exam | April 19 (tentative) | 36% |
See the course schedule for specific information, assignments and dates for course work.
Grading System
Your final grade for this course will be based on my interpretation of the university grading system as defined in Section 23.4 of the Academic Regulations. I will use my judgment of how your mark reflects mastery of the course material. To pass this course, you need to earn at least 50% of the total mark.
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 8, 2007.
Re-evaluation
Unless explicitly stated otherwise, any questions or concerns about marks on any particular piece of work 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:- M. Kifer, A. Bernstein, and P.M. Lewis Database Systems, An application oriented approach, second edition, Addison-Wesley, 2005, ISBN: 0-321-26845-8
- For this class, the previous edition will also be OK. The previous edition had a slightly different title: Databases and Transaction Processing, as well as a different order of the author names.
-
additional references:
- R. Ramakrishnan and J. Gehrke, Database Management Systems, 3rd Edition, McGraw-Hill, 2002, ISBN: 0-07-232206-3.
- R. Elmasri and S. Navathe, Fundamentals of Database Systems, 4th Edition, Addison-Wesley, 2003, ISBN: 0-321-12226-7. (The 3rd Edition, ISBN 0-8053-1755-4, is also acceptable).
Policy
Academic Integrity and Plagiarism
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, Sec. 30.3.2 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 offence and can result in suspension or expulsion from the University.
Collaboration
You are encouraged to discuss the course materials and assignments to the degree that is required to understand the problem statements. However, whatever you are submitting for evaluation must be your own work. You must develop your own solutions for assignments and projects, do not give access to your solutions and also do not seek access to someone else's solutions.
Late Assignments
Unless stated otherwise, assignments and the project are due at 5:00 p.m. Late assignments received before 5:00 p.m. one day after the due date will be penalized a flat 10% of the maximum mark. Late assignments received before 5:00 p.m. two days after the due date will be penalized a flat 20% of the maximum mark. No assignments will be accepted after 5:00 p.m. two days after the due date. This policy will be waived only in exceptional circumstances, such as documented medical emergencies. Please see the instructor about such matters.
University Policies
The University of Alberta policies include, but are not limited to, the following:
