Course Outline
Welcome to the course website for COMP 210: Database Design I.
As the course progresses, this website will grow to include lecture notes, project descriptions and deliverables, quiz answers,
and links to referenced materials.
Instructor
| Instructor: |
 |
Dave Rogers |
| Email Address: |
|
not available |
| Office: |
|
A2511 |
| Office Telephone: |
|
(867) 668-8868 |
| Office Hours: |
|
Tuesday 3:00 pm - 4:00 pm, Thursday 3:00 pm - 4:00 pm, or by appointment.
|
Class Email Announcements
A mailing list has been set up for the COMP 210 class.
Any message sent to this address will be redirected to every member of the class, including the instructor.
If you want to add your email address (multiple addresses are fine), send a note to the instructor.
Class Schedule
| Room: |
|
A2704 |
| Lecture: |
|
Tuesday 6:00 pm - 9:00 pm |
| Lab: |
|
Thursday 6:00 pm - 9:00 pm |
Course Description
Database design is one of the fastest growing fields in computer science.
Databases are the foundation of any information system.
All organizations, large and small, must rely on data management in all aspects of business operations.
In this course we shall concern ourselves with the techniques required to implement good database design both in theory and in practise.
The concepts introduced during the course will be materialized in a term-long project.
Objectives
Upon completion of the course, the student will:
- understand the role of database systems in organizations;
- gain familiarity with concepts in database planning and implementation;
- develop a mastery of conceptual data modeling using the E-R data model;
- develop a mastery of logical data modeling using the relational model;
- gain hands-on experience with the Oracle RDBMS, for schema generation and data manipulation; and
- become familiar with the full line of Oracle tools used to create an application.
Prerequisites
The only prerequisite is BUS 175: Microsoft Access.
Experience with relational database management systems (RDBMS) is an asset, but not required.
Admission to the course may also be granted at the instructor's discretion.
Textbook
The textbook is now available in the College Bookstore.
Policies
Attendance and Participation
All students are expected to attend all classes.
If you are receiving support, the funding agency may require regular attendance.
There are no marks deducted for absence or failure to participate in class discussion.
Of course, it is unlikely that you will master the material without effort.
Dishonesty
Cheating of any kind is a serious offense and all parties will receive a mark of 0.
Lab Work
In-Class lab work will be used for demonstration and instruction of concepts introduced theoretically in class.
No material will have to be completed and submitted in a given amount of lab time.
Quizzes
There will be 11 quizzes throughout the term.
The quizzes will cover the material taught in the lecture and lab.
The one quiz with the lowest mark will be discarded from the term evaluation.
Quizzes may not be rescheduled, except in exceptional circumstances and only where prior arrangements have been made with the instructor.
Project
The students will be required to model a real life situation, create tables using the Oracle RDBMS and construct a simple user interface application.
The project will be marked as a series of deliverables throughout the term, submitted on specified dates.
All such deliverables must be submitted at the beginning of class on the date they are due.
Late deliverables will be penalized 20% per working day, unless prior arrangements have been made with the instructor.
Final Examination
The Final Exam will cover all aspects of the course.
Evaluation
The breakdown of the course mark is as follows:
| Component |
Weight |
| Quizzes (best 10 of 11) |
40% |
| Term Project |
30% |
| Final Exam |
30% |
| Total |
100% |
Letter grading will follow the College's standard, which can be found in the Letter Grading section of Academic Regulations in the College Calendar.
Software
All software is available in the Computer Labs.
|
