Database I

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course Code
CSIS 2300
Credits
3.00
Semester Length
15 Weeks
Max Class Size
35
Method Of Instruction
Lecture
Seminar
Typically Offered
To be determined
Campus
Online

Overview

Course Description
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
Assignments/Project(s)    20% - 30%
Tests/Quizzes 10% - 20%
Mid-term Examination 25% - 35%
Final Examination* 25% - 40%
Total       100%

Some of these assessments may involve group work.

* Practical hands-on computer exam

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
At the end of this course, the successful 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:
  • Enhanced entity-relationship modeling;
  • Functional dependencies and normalization;
  • Derivation of relational schema from EER model;
  • Explain and apply the necessary commands to create, maintain and query a database within a DBMS;
  • Apply SQL statements from the basic commands to more advanced commands;
  • Apply simple report design techniques to present query data results for users;
  • Demonstrate an understanding of stored procedures and triggers;
  • Demonstrate an understanding of data warehousing.
  • Textbook Materials

    Textbooks and Materials to be Purchased by Students

    Kroenke. Database Concepts. Latest Edition. Prentice Hall.

    or other textbooks as approved by the department.

    Requisites

    Prerequisites

    Min grade C in CSIS 2200 

    Corequisites

    No corequisite courses.

    Equivalencies

    No equivalent courses.

    Requisite for

    Course 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 Transfers

    Institution Transfer Details Effective Dates
    Alexander College (ALEX) ALEX CPSC 2XX (3) 2015/01/01 to -
    Athabasca University (AU) DOUG CSIS 2300 (3) & DOUG CSIS 3300 (3) = AU COMP 378 (3) & AU COMP 3XX (3) 2015/01/01 to -
    Athabasca University (AU) DOUG CSIS 2300 (3) & DOUG CSIS 3300 (3) = AU COMP 378 (3) & AU COMP 3XX (3) 2015/01/01 to -
    Capilano University (CAPU) CAPU COMP 2XX (3) 2004/09/01 to -
    Coast Mountain College (CMTN) CMTN CPSC 2XX (3) 2015/01/01 to -
    Columbia College (COLU) COLU CSCI 2nd (3) 2015/01/01 to -
    Coquitlam College (COQU) No credit 2015/01/01 to -
    Kwantlen Polytechnic University (KPU) KPU INFO 2312 (3) 2012/09/01 to -
    Kwantlen Polytechnic University (KPU) KPU CISY 2314 (3) 2007/09/01 to 2012/08/31
    Langara College (LANG) LANG CPSC 2221 (3) 2011/05/01 to -
    North Island College (NIC) NIC CPS 146 (3) 2015/01/01 to -
    Okanagan College (OC) OC COSC 304 (3) 2015/01/01 to -
    Simon Fraser University (SFU) SFU CMPT 2XX (3) 2007/09/01 to -
    Thompson Rivers University (TRU) TRU COMP 2560 (3) 2010/09/01 to -
    Thompson Rivers University (TRU) TRU COMP 256 (3) 2007/09/01 to 2010/08/31
    Trinity Western University (TWU) TWU ISYS 337 (3) 2007/09/01 to 2017/12/31
    Trinity Western University (TWU) TWU CMPT 2XX (3) 2018/01/01 to -
    University Canada West (UCW) UCW CMPT 2XX (3) 2015/01/01 to -
    University Canada West (UCW) UCW CPSC 2XX (3) 2006/01/01 to 2014/12/31
    University of British Columbia - Okanagan (UBCO) UBCO COSC 2nd (3), Exempt COSC 304 2007/09/01 to -
    University of British Columbia - Vancouver (UBCV) UBCV CPSC 2nd (3), Exempt UBCV CPSC 304 (0) 2007/09/01 to -
    University of Northern BC (UNBC) UNBC CPSC 2XX (3), Waive UNBC CPSC 324 (3) for CPSC students 2015/01/01 to -
    University of the Fraser Valley (UFV) UFV CIS 230 (3) 2007/09/01 to 2019/08/31
    University of the Fraser Valley (UFV) UFV COMP 230 (3) 2019/09/01 to -
    University of Victoria (UVIC) UVIC CSC 2XX (1.5) 2007/09/01 to -
    Vancouver Community College (VCC) No credit 2015/01/01 to -
    Vancouver Island University (VIU) VIU CSCI 2nd (3) 2015/01/01 to -

    Course Offerings

    Winter 2021

    CRN
    Days
    Dates
    Start Date
    End Date
    Instructor
    Status
    Location
    13490
    Wed
    04-Jan-2021
    - 28-Mar-2021
    04-Jan-2021
    28-Mar-2021
    Mirjalili
    Saeed
    Full
    Online
    This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
    Max
    Enrolled
    Remaining
    Waitlist
    35
    35
    0
    0
    Days
    Building
    Room
    Time
    Wed
    15:30 - 18:20
    CRN
    Days
    Dates
    Start Date
    End Date
    Instructor
    Status
    Location
    14815
    Tue
    04-Jan-2021
    - 12-Apr-2021
    04-Jan-2021
    12-Apr-2021
    TBA
    (Faculty)
    Open
    Online
    This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
    Max
    Enrolled
    Remaining
    Waitlist
    35
    16
    19
    0
    Days
    Building
    Room
    Time
    Tue
    18:30 - 21:20
    CRN
    Days
    Dates
    Start Date
    End Date
    Instructor
    Status
    Location
    15071
    Mon
    04-Jan-2021
    - 12-Apr-2021
    04-Jan-2021
    12-Apr-2021
    Mirjalili
    Saeed
    Waitlist
    Online
    This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
    Max
    Enrolled
    Remaining
    Waitlist
    35
    35
    0
    1
    Days
    Building
    Room
    Time
    Mon
    11:30 - 14:20