COMP 2003 Relational Database
or COMP 2064 Database Fundamentals (ODE)
CSC 2346 Advanced Database
Students are advised to retain course outlines for future use in support of applications for employment or transfer of credits
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.
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.
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
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
- Stored procedures
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.
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.
A student at Georgian College can appeal the following:
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.