Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Database I

Course Code: CSIS 2300
Faculty: Commerce & Business Administration
Credits: 3.0
Semester: 15 Weeks
Learning Format: Lecture, Seminar
Typically Offered: TBD. Contact Department Chair for more info.
course overview

This course will provide the student with knowledge of database concepts. Emphasis will be placed on database design, development and querying using DBMS installed on both LAN and cloud environments. Concepts covered include ER modelling, normalization, and database design theory. Hands on activities will allow students to create, maintain and query various databases. An introduction and overview of stored procedures, triggers and data warehousing will also be covered.

Course Content

  1. Overview: Concept of information systems - entities, attributes, values
  2. Data model overview
  3. Database development and systems life-cycle
  4. Database integrity, privacy, data independence
  5. Indexed files, primary vs. foreign keys
  6. Data normalization: 1st, 2nd, 3rd and BCNF
  7. Understanding data requirements
  8. Conceptual, logical and physical design
  9. Queries/views using a database management system
  10. Database planning, design and administration
  11. Structured query language (SQL)
  12. Advanced SQL and problem solving
  13. Brief introduction to stored procedures and triggers
  14. Brief introduction to data warehousing
  15. Report design techniques

Methods of Instruction

Lecture, seminar and hands-on exercises in the lab

Means of Assessment

Participation 0% - 5%
Assignments/Project(s)*     20% - 30%
Tests/Quizzes** 10% - 20%
Mid-term Examination** 25% - 35%
Final Examination**     25% - 35%
Total       100%

*Some of these assessments may involve group work.

**In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).

Learning Outcomes

The student will be able to:
  1. Describe the database approach, its environment, database application life cycle and roles in data administration;
  2. Explain the functions of a relational database model;
  3. Explain and apply data modeling techniques;
  4. Apply techniques of database design, including:
    1. Enhanced entity-relationship modeling;
    2. Functional dependencies and normalization;
    3. Derivation of relational schema from EER model;
  5. Explain and apply the necessary commands to create, maintain and query a database within a DBMS;
  6. Apply SQL statements from the basic commands to more advanced commands;
  7. Apply simple report design techniques to present query data results for users;
  8. Demonstrate an understanding of stored procedures and triggers;
  9. Demonstrate an understanding of data warehousing.

course prerequisites

Min grade C in CSIS 2200 

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

Courses listed here are equivalent to this course and cannot be taken for further credit:

  • No equivalency courses

curriculum guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester/year of the course, consider the previous version as the applicable version.

course schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.