COMP 3005 (B) Winter 2016
Database Management Systems

Course Outline

Lectures Wed, Fri, 2:30-4:00 Minto 5050
Instructor Louis Nel

Calendar Description:

Introduces students to concepts of database management systems, database design and file structures. Topics include: entity-relationship modeling and object oriented database design, data models (relational, network and object oriented), the relational algebra, SQL, normalization theory, physical data organization, object oriented databases and OQL.

Precludes additional credit for BUSI 3400.
Prerequisite(s): COMP 2402, or both of SYSC 2004 and SYSC 2100.
Lectures three hours a week.


Course Description:

The course covers the principles involved in the design and implementation of relational databases primarily. The assignments will provide practice in the specification, design, and implementation of a relational database, as well as theory of relational table design (normalization theory). Course topics include:



The course will be taught from lecture slides available to students on the course web site in .pdf form. The course notes are based largely on the reference text mentioned below. Copies of the text should be available in the book store. Please ensure you get the latest copy of the course notes since they will have been modified since the last offering of the course. The recommended textbook is: Elmasri and Navathe, "Fundamentals of Database Systems" 7th edition, Addison Wesley (ealier editions of the book are fine also for this course).

Course Material Copyright Notice:

We remind you that lectures and course materials, including power point presentations, outlines, sample code and similar materials, are protected by copyright. The professor is typically the exclusive owner of copyright and intellectual property of the course materials. You may take notes and make copies of course materials for your own private (educational) use. You may not, and may not allow others, to reproduce or distribute lecture notes and course materials publicly without our express written consent.

Note that professors often use examples from books and other copyrighted content specifically so you can go to those sources for further explanation. Only a small portion of the work is typically reproduced and kept behind password protected sites (so as not to constitute publishing the copied work). You must be respectful of this. (This notice has been added partly because course content has ended up on public sites (like OneClass and Course Hero) without permission.)

About sample code:
We often post sample code on the course web site to accompany lecture content or to use as a starting point for exercises and assignments. Often the sample code is intentionally taken from a book, or online source, so that you can be referred to that source for further explanation.

You are free to use whatever sample code we post on the course web site as the starting point for your own work intended for submission as course assignments. Assignment submission are considered private and not published to the world at large. You may NOT however publish the sample code to the world at large. For example, using sample code from a copyrighted source in a public GITHub repository IS a copyright violation. If you are going to post any code to a public repository like GITHub make sure it is all your own work. GitHub as become a defacto repository used in much software development, however its free accounts do not allow private repositories at this time. Therefore anything placed in a free account is published to the world at large and should NEVER contain content that could represent a copyright violation.


You will need the following software for doing course assignments. All software should be freely available and should run on platforms: Windows, Mac OS, Linux. All classroom demos will be done on Windows 8.1. Assignments must be submitted in the format specified. Solutions in other formats will not graded.


Relational Database:


SQLite will be our course SQL database.

App Programming Language

Java JDK 1.8 or later

IDE, Java projects format

Eclipse IDE for Java Developers (all assignment demo code will be provided as an Eclipse project and assignments will be submitted and evaluated as an eclipse project)

Alternate App Development

With COMP 2406 now established as a core course in SCS we are also going to provide, those that would like to, the opportunity to use the node.js/express.js web app enviroment to do some assignments instead of the java/eclipse environment. The database will still be SQLite but you can wrap it in a node.js based web-server/web-page-client if you prefer. Details will be provided with the relevant assignments.

Written Design Assignments

.pdf documents only (not word, xml, etc)

You will need diagraming tools for ER diagrams and word processing for design exercise. You can use whatever you want but submissions MUST be in .pdf

.pdf scans of handwritten work will not be accepted.

Compression only .zip accepted (not rar, or tar, etc.)



We will be using electronic submission of assignments using the CULearn system here at Carleton ( 

Be forewarned: electronic submission enforces strict deadlines. Only assignments submitted through culearn will be graded for marks. No assignments will be accepted late or directly by email or in other forms.

Teaching Assistants:

A schedule for TAs will be posted on the course web site as soon as they become available.

Marking Scheme:

deliverable weight comment
Assignments 55% 5 assignments equally weighted. All count.
Midterm 10% In class (date TBA) (If your final exam mark is better than your midterm mark, we will replace your midterm mark with your exam mark.)
Final Exam 35% Exam marks will NOT replace assignment marks


Missed assignments or tests will score 0 unless it is for a medical, or similar, reason and is accompanied by official medical documentation in which case you can be excused from the assignment.

If your final exam mark is better than the midterm mark we will replace the midterm mark with the final exam mark.

Midterm or Exam marks will not, however, be used to make up for missed, or poorly done, assignments.

If you wish to appeal an assignment or midterm mark you must make the appeal within two weeks of the assignment mark being posted in culearn. After that we will not be obliged to entertain the appeal.

Cheating, or Copying, is not allowed. Any two assignments judged to be too similar will both receive a grade of 0, and will be handled as a formal academic offence -see calendar for details.

Course Web Page:

As well as being announced in class, all important information, such as course news, assignments, TA hours, instructor office hours, will be available on the course web page at It is your responsibility to check this web page frequently for new information. Paper copies of outlines and assignments will not be provided.


Student Academic Integrity Policy

Every student should be familiar with the Carleton University student academic integrity policy. A student found in violation of academic integrity standards may be awarded penalties which range from a reprimand to receiving a grade of F in the course or even being expelled from the program or University. Some examples of offences are: plagiarism and unauthorized co-operation or collaboration. Information on this policy may be found in the Undergraduate Calendar, Section 14, Page 59.


As defined by Senate, "plagiarism is presenting, whether intentional or not, the ideas, expression of ideas or work of others as one's own". Such reported offences will be reviewed by the office of the Dean of Science.

Unauthorized Co-operation or Collaboration

Senate policy states that "to ensure fairness and equity in assessment of term work, students shall not co-operate or collaborate in the completion of an academic assignment, in whole or in part, when the instructor has indicated that the assignment is to be completed on an individual basis". Please refer to the course outline statement or the instructor concerning this issue.

Academic Accommodation

You may need special arrangements to meet your academic obligations during the term because of disability, pregnancy or religious obligations. Please review the course outline promptly and write to your instructor concerning any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. It takes time to review and consider each request individually, and to arrange for accommodations where appropriate. Please make sure you respect these timelines particularly for in-class tests, midterms and final exams, as well as any change in due dates for papers. You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at

Students with Disabilities Requiring Academic Accommodations Register with the Paul Menton Centre for Students with Disabilities (PMC) for a formal evaluation of disability-related needs. Documented disabilities could include but are not limited to mobility/physical impairments, specific Learning Disabilities (LD), psychiatric/psychological disabilities, sensory disabilities, Attention Deficit Hyperactivity Disorder (ADHD), and chronic medical conditions. Registered PMC students are required to contact the PMC, 613-520-6608, every term to ensure that I receive your Letter of Accommodation, no later than two weeks before the first assignment is due or the first in-class test/midterm requiring accommodations. If you only require accommodations for your formally scheduled exam(s) in this course, please submit your request for accommodations to PMC by the deadlines published on the PMC website:

Religious Obligation

Write to your instructor concerning any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website

Pregnancy Obligation

Write to your instructor concerning any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website

Medical Certificate

The following is a link to the official medical certificate accepted by Carleton University for the deferral of final examinations or assignments in undergraduate courses. To access the form, please go to