vcc.ca
OPMT 2210: Supply Chain Technology & Database Design
Effective date
May 2025
Department
Global Supply Chain Management
School
Hospitality, Food Studies and Applied Business
Description
In this course, students explore how technology and database systems contribute to the efficiency and effectiveness of modern supply chain operations. The course covers foundational concepts in database design and management, emphasizing their application in the context of supply chain processes. Students will explore various supply chain technologies and their integration with database systems to facilitate seamless information flow and decision-making throughout the supply chain.
Credits
3.0
Year of study
2nd Year Post-secondary
Prerequisites
OPMT 1120, MGMT 1015.
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Identify and explain key supply chain technologies, including Internet of Things, Generative AI, barcode systems, and cloud computing.
- Analyze and evaluate technology solutions for supply chain optimization.
- Leverage technology for supply chain visibility and collaboration.
- Recognize the critical role of databases in managing and optimizing supply chain processes.
- Define blockchain technology and its application in supply chain management.
- Apply predictive analytics techniques for demand forecasting.
- Evaluate the automation and optimization of warehousing processes through databases.
- Evaluate the role of ERP systems in integrating and streamlining supply chain processes.
- Explain the concept of big data and analytics in the context of supply chain management.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 45
Total Hours: 45
Total Hours: 45
Instructional Strategies
Lectures, group work, case studies.
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Project |
40 |
Two or more projects based on case studies |
|
Assignments |
30 |
Individual and group assignments |
|
Assignments |
20 |
Two or more presentations based on real world examples |
|
Participation |
10 |
|
Course topics
- Introduction to Supply Chain Technology Supply Chain Visibility and Tracking Technologies Fundamentals of Structured Query Language (SQL). Role of technology in supply chain optimization. Database-driven decision-making in logistics and inventory control. Internet of Things (IoT), barcode technology, and Cloud computing for supply chain optimization Enterprise resource Planning (ERP): Database architecture, implementation, challenges, and best practices. Blockchain technology: basics and applications. Big Data analytics for supply chain. Collaborative Planning, Forecasting, and Replenishment (CPFR) Supply Chain Financing Platforms
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/. - To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.