Georgian College - Course Outline

COURSE OUTLINE

Term: Fall 2014


Subject Code:
COMP
Course Number:
3002
PLA Applicable:
Yes
Course Name:
Advanced Database
Grade Mode:
Numeric
Credit Value:
3.0
Length:
42.0
Level:
Post Secondary

Prerequisite(s):

COMP 2003 Relational Database
or COMP 2064 Database Fundamentals (ODE)

Co-requisite(s) and Concurrent Prerequisite(s):

None

Equivalent(s):

CSC 2346 Advanced Database


Students are advised to retain course outlines for future use in support of applications for employment or transfer of credits

Course Description:

The Structured Query Language, SQL, is used at an advanced level with emphasis on real world commercial SQLs. A relational database is created and maintained using SQL and SQL procedural language.

Learning Outcomes:

Upon successful completion of this course, the student will have reliably demonstrated the ability to:

1. create logical and physical 3rd normal form entity models.
2. define and maintain a database using SQL and a DBMS interface.
3. design database objects using SQL procedural language.
4. define and implement constraints to ensure data integrity.
5. identify the role, the duties, and the responsibilities of a database administrator with respect to the maintenance and security of a database server.

Course Content:

1. Review of fundamental database concepts and SQL commands
2. Data modeling
- Overview of different types of databases (relational,
label dimensional, object oriented)
- Relational databases
- relationships and cardinality
- logical vs. physical data modeling
3. Database definition and maintenance using
- SQL (DML, DCL, DDL)
- Commits and rollbacks
- Indexes (tree and cluster)
- Data loads and imports
- Views
4. Overview of database administration and security
5. Data integrity and implementation of constraints
6. SQL procedural language
- Condition handling
- SQL codes and SQL states
- User defined functions
- Triggers
- Stored procedures

Evaluation:

Tests/examinations/assignments must be written/submitted at the time specified. Requests for adjustments to that schedule must be made before the test/exam/assignment date to the faculty member. Failure to do so will result in a mark of “0”, unless an illness/emergency can be proven with appropriate documentation at no cost to the College.

The passing grade for all courses is 50%, or letter grade of P (Pass) or S (Satisfactory) unless otherwise noted below. The passing weighted average for promotion through each semester of a program is 60% and is a requirement to graduate.

Tests (60%)
Assignments (40%)

Prior Learning Assessment:

This course is eligible for Prior Learning Assessment. If you feel you have acquired equivalent skills and knowledge through life and work experience, you can request an assessment. Contact your program co-ordinator, or the Office of the Registrar.

Appeals:

A student at Georgian College can appeal the following:

  1. a mark on the assignment, test, examination or practical experience;
  2. a final mark for a course or co-op work term;
  3. missing or incorrect assessment information on a grade report and/or transcript

A student cannot appeal a decision regarding whether or not a PLA or Exemption is available for an individual course, nor the method of challenge used.


© Georgian College 2013