Course Overview
Organizations are increasingly dependent on Information Technology (IT) to operate effectively and efficiently. Employers expect their employees to have a better understanding of IT and better hands-on skill with computers than ever before. The overall goal of this course is to provide the understanding and skills necessary to be successful in this new work environment and provide some basic business analysis, database design, and database management skills using tools common in industry. In this course we will explore the role of Database Management Systems (DBMS) in organizations and the relationship between DBMS and other Information Systems (IS) including ERP, CRM, and SCM solutions. The curriculum is designed to ensure students can describe the critical function of a DBMS in organizational success, identify the comprehensive steps involved in database design and development, create and manage a basic database system, and employ database applications to execute various data management tasks. Students will learn about various data modeling techniques, including conceptual, logical, and physical data models. This knowledge will enable students to design, work with, and manage databases that accurately reflect business requirements, support data integrity, and efficiency.
Prerequisite(s)
- 50% in BSYS 2000
Credits
4.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe the role of DBMS in organizations.
- Explain basic database concepts using standard terminology and tools.
- Design a database model based on business requirements.
- Construct a database using a popular industry database management system involving multiple tables in one-to-many and many-to-many relationships.
- Create queries involving multiple tables and parameters.
- Prepare databases for business intelligence and analytics.
- Incorporate measures to ensure database validity and integrity.
Effective as of Fall 2024
Related Programs
Business Database Applications (OPMT 3361) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Business + Media
- Operations & Management Engineering
Diploma Full-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.