Database I

Curriculum Guideline

Effective Date:
Course Code
CSIS 2300
Database I
Computing Studies & Information Systems
Commerce & Business Administration
Start Date
End Term
Not Specified
Semester Length
15 Weeks
Max Class Size
Contact Hours
Lecture: 2 Hours per week Seminar: 2 Hours per week Total: 4 Hours per week
Method Of Instruction
Methods Of Instruction

Lecture, seminar and hands-on exercises in the lab

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
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.
  • 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).

    Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.


    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.


    Min grade C in CSIS 2200 


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

    • No equivalency courses
    Which Prerequisite