| Lectures | Tue, Thu 8:30-10:00 Tory 360 |
| Instructor | Louis Nel |
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 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).
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.
| Software | |
|---|---|
Relational Database: |
SQLite http://www.sqlite.org/ SQLite will be our course SQL database. |
| App Programming Language | Java JDK 1.6 or later (use 1.8.x_xx) http://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html#javasejdk |
| 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 Platform |
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 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 (www.carleton.ca/culearn).
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.
A schedule for TAs will be posted on the course web site as soon as they become available.
| deliverable | weight | comment |
|---|---|---|
| Assignments | 55% | 5 assignments equally weighted |
| 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% | |
| Note: assignment marks will not be transferred to the exam. |
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.
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/3005fall2015. 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.
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.
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 http://carleton.ca/equity/accommodation
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: http://www2.carleton.ca/pmc/new-and-current-students/dates-and-deadlines/
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 http://www.carleton.ca/equity/accommodation/student_guide.htm
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 http://www.carleton.ca/equity/accommodation/student_guide.htm
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 http://www2.carleton.ca/registrar/forms/