COMP 3005 A Fall 2018| Lectures | Wed,Fri 11:30-1:00 location: Minto 2000 |
| Instructor | Louis Nel |
COMP 3005 [0.5 credit]
Database Management Systems
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.
The course covers the principles involved in the design and implementation of relational databases and applications that use them. The assignments will provide practice in the specification, design, and implementation of a relational databases and applications that makes use them, as well as theory of relational table design (normalization theory). Course topics include:
The course will be taught from lecture slides and demonstration code available to students on the course website. The course notes are based largely on the recommended text mentioned below. Please ensure you get the latest copy of the course notes since they will have been modified since my last offering of the course.
Note: course notes will be updated as the course progresses so check revision numbers from time to time to see that you have the latest versions.
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).
Some recommended texts or materials will be provided in the resources section of the course web site. The resources section will be updated as the course proceeds and students are encouraged to contribute to the resources list.
We remind you that lectures and course materials, including power point presentations, outlines, code examples, and similar materials, are protected by copyright. The professor is typically the exclusive owner of copyright and intellectual property of the course materials unless otherwise noted. You may take notes and make copies of course materials for your own private (educational) use. You may not, however, reproduce or distribute lecture notes and course materials publicly or use them for commercial purposes without my express written consent.
This notice has been added, in part, because course content has ended up on public sites like OneClass, Course Hero and GitHub without permission. Many students are eager to post work on GitHub but you have to be careful not to include copyrighted work of others.
You will need the following software for doing course assignments. All software should be freely available and should run on Windows, Mac OS, and Linux. Classroom demos may be Windows 10, Mac OSX, or Linux. Assignments must be submitted in the format specified in the assignment. Assignments in other formats will not graded.
| Software | |
|---|---|
Relational Database: |
SQLite http://www.sqlite.org/ SQLite will be our course SQL database. See resources section of course website for more details. |
| App Development Platform |
We will use the web technologies of COMP 2406 to wrap our SQLite databases in an client-server web app. See the resources section of the course website for more information. The last two assignments will require you to present your term database as a web app. The applications will involve using simple HTML webpages accessing a database server coded in javascript and based on the node.js javascript execution environment. It is not expected that you have taken COMP 2406 but you will be expected to learn the required technology based on demonstration code we provide. |
| Written Design Assignments | Many of the assignments will require design work presented as a report and these must be submitted as .pdf files (not word, html, xml, etc). Don't assume that the markers have specific word processing apps or programming development environments. You will need diagraming tools for ER diagrams and word processing for design exercise. You can use whatever you want but assignment submissions MUST be in .pdf .pdf scans of handwritten work will not be accepted -your work should look professional. Important: this is a large class and we will adopt adopt a zero-tolerence policy for work not submitted in the requested format. Submissions that do not comply will not be graded. |
| Compression | only .zip accepted (not rar, or tar, etc.) |
We will be using electronic submission of assignments using Carleton's culearn system. Electronic submission enforces strict deadlines. Only assignments accepted to culearn will be graded. No assignments will be accepted late or directly by email or in other forms. TA's are not allowed to accept assignments directly.
A schedule for TAs will be posted on the course website.
| deliverable | value | comment |
|---|---|---|
| Assignments | 55% | 5 (or possibly 6) assignments equally weighted There will be an ongoing individual term project. In the final stages you will need to embed your database inside a simple web application application. |
| Midterm | 10% | In class (date TBA). (If your final exam mark is better than the midterm mark, the midterm mark will be replaced by the final exam mark) |
| Final Exam | 35% | Formally scheduled exam during exam period |
Missed assignments score 0 unless it is for a medical, or similar, reasons and is accompanied by official medical documentation. You will be excused from an assignment for medical reasons if accompanied by proper documentation presented within two weeks of the assignment due date . There are no assignment extensions.
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 be used to make up for missed, or poorly done, assignments.
IMPORTANT: If you wish to appeal a mark (assignment, tutorial or midterm) you must make the appeal within two weeks of the mark being posted on culearn. After this we will not be obliged to entertain appeals or change marks.
Collaboration is encouraged but cheating, or copying, is not allowed. You may work together and consult but any work you hand in must be your own and judged to be unique. 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.
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 http://www.scs.carleton.ca/~ldnel/3005fall2018. It is your responsibility to check this web page frequently for new information and announcements. Paper copies of outlines and assignments will not be provided. We will not use mass emails for routine annoucements but might use them in exceptional circumstances.
You may need special arrangements to meet your academic obligations during the term. For an accommodation request, the processes are as follows:
Please contact your instructor with 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: carleton.ca/equity/wp-content/uploads/Student-Guide-to-Academic-Accommodation.pdf
Please contact your instructor with 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: carleton.ca/equity/wp-content/uploads/Student-Guide-to-Academic-Accommodation.pdf
If you have a documented disability requiring academic accommodations in this course, please contact the Paul Menton Centre for Students with Disabilities (PMC) at 613-520-6608 or pmc@carleton.ca for a formal evaluation or contact your PMC coordinator to send your instructor your Letter of Accommodation at the beginning of the term. You must also contact the PMC no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation from PMC, meet with your instructor as soon as possible to ensure accommodation arrangements are made. carleton.ca/pmc
As a community, Carleton University is committed to maintaining a positive learning, working and living environment where sexual violence will not be tolerated, and is survivors are supported through academic accommodations as per Carleton's Sexual Violence Policy. For more information about the services available at the university and to obtain information about sexual violence and/or support, visit: carleton.ca/sexual-violence-support
Carleton University recognizes the substantial benefits, both to the individual student and for the university, that result from a student participating in activities beyond the classroom experience. Reasonable accommodation must be provided to students who compete or perform at the national or international level. Please contact your instructor with 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. https://carleton.ca/senate/wp-content/uploads/Accommodation-for-Student-Activities-1.pdf
For more information on academic accommodation, please contact the departmental administrator or visit: students.carleton.ca/course-outline
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.
Plagiarism
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.