COURSE OUTLINE SEARCH

Welcome to the new Course Outline Search Tool. We are currently in the process of completing this resource, if the outline you are looking for is not available, please see details below.

Search by Course Name or Code

Printer Friendly Version

Course Outline

Course Name: Database Systems (DIGI 3502)

Academic Period: 2025 - 2026

Faculty:

Faculty Availability:

Associate Dean:
Bruce Sinclair
bruce.sinclair@humber.ca

Schedule Type Code:

Land Acknowledgement

Humber College is located within the traditional and treaty lands of the Mississaugas of the Credit. Known as Adoobiigok [A-doe-bee-goke], the “Place of the Alders” in Michi Saagiig [Mi-Chee Saw-Geeg] language, the region is uniquely situated along Humber River Watershed, which historically provided an integral connection for Anishinaabe [Ah-nish-nah-bay], Haudenosaunee [Hoeden-no-shownee], and Wendat [Wine-Dot] peoples between the Ontario Lakeshore and the Lake Simcoe/Georgian Bay regions. Now home to people of numerous nations, Adoobiigok continues to provide a vital source of interconnection for all.

Equity, Diversity and Inclusion Statement

Humber College and the University of Guelph-Humber (Humber) are leaders in providing a learning, working and living environment that recognizes and values equity, diversity and inclusion in all its programs and services. Humber commits to reflect the diversity of the communities the College serves. Students, faculty, support and administrative staff feel a sense of belonging and have opportunities to be their authentic selves.

Faculty or Department	Longo Faculty of Business
Program(s)	Digital Business Management, Bachelor of Commerce (DB411) Finance, Bachelor of Commerce (22271) Healthcare Management, Bachelor of Commerce (HM411) Management Studies, Bachelor of Commerce (22291)
Course Name:	Database Systems (DIGI 3502)
Pre-Requisites	none
Co-Requisites	none
Pre-Requisites for	DIGI 4500
Equates	none
Restrictions	none
Credit Value	3
Total Course Hours	42

	Developed By:	Prepared By:	Approved by:
	Omar Wahdan		Bruce Sinclair

Humber Learning Outcomes (HLOs) in this course.

The HLOs are a cross-institutional learning outcomes strategy aimed at equipping Humber graduates with the employability skills, mindsets, and values they need to succeed in the future of work. To explore all the HLOs, please consult the Humber Learning Outcomes framework.

Equity, Diversity, Inclusion & Belonging
Systems Thinking
Critical Thinking
Collaboration
Communication
Digital Fluency
Innovation
Leadership
Professionalism
Strategic Problem-Solving

Course Description

In this course, students will learn about the design and management of relational database systems within the context of small and medium sized organizations as they relate to e-business applications. The course also introduces related topics, such as data mining, data warehousing, multimedia databases and distributed database systems. Database software used by small businesses will be used in a lab environment.

Course Rationale

The course delivers an overview of database concepts, design, building, implementation, and integration using modern tools.

Program Outcomes Emphasized in this Course

Digital Business Management, Bachelor of Commerce (DB411)

Explain the key concepts, principles, and practices of digital business management functions, processes, and systems.
Describe current technological alternatives to support solving specific business problems in various industries.
Employ digital tools, data science, business analytics, and research methods to improve digital organizational decision making.
Propose appropriate strategies and methods to improve the online performance of an organization, utilizing current technologies.
Create a development plan for e-business applications to support an organization's strategic and operational goals.
Communicate effectively and persuasively in oral, written, digital and visual forms, appropriate to external and internal stakeholders with diverse skills, expectations and behaviours.
Identify current and future opportunities and challenges in the fast- changing digital environment.
Reflect on personal competence and professional skills to identify gaps and plan for ongoing learning.

Finance, Bachelor of Commerce (22271)

Healthcare Management, Bachelor of Commerce (HM411)

Management Studies, Bachelor of Commerce (22291)

Course Learning Method(s)

Action Learning
Problem Based Learning (PBL)
Case Based Learning
Collaborative Learning
Project Based Learning
Group or Team Work
Lecture
Online

Course Learning Outcomes (CLO)

Learning Outcome	Learning Objectives	Summative Assessments	Formative Assessments
Describe the role of various computer database management systems and their impact on e-business strategies.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Identify how commercial and open-source Web scripting environments and software tools are used in e-business database applications development, including point-of-sales applications.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Compare types of database servers and client software and their applications, including data mining and data warehousing.		Computer Lab and In-Class Activities Individual Assignment Mid-Term Examination Group Project Final Comprehensive Examination
Research and describe multi-media database management applications in an e-business environment.		Computer Lab and In-Class Activities Individual Assignment Mid-Term Examination Group Project Final Comprehensive Examination
Research and describe current and expected future Internet technologies and services with respect to their respective value to databases and e-business.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Create data forms and extract data reports.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Design , develop and implement a database Point of Sale application.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Create and modify the Entity Relationship Diagram (ERD) for new and existing databases.		Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Implement and use Structured Query Language (SQL) to manipulate and retrieve data from a database.		Computer Lab and In-Class Activities Group Project Final Comprehensive Examination
Research , describe, and compare various Database Management System (DBMS) products and their applications.		Computer Lab and In-Class Activities Group Project Final Comprehensive Examination

Assessment Weighting

Assessment	Weight
Writing Assignment
Individual Assignment	10%
Final Exam
Final Comprehensive Examination	35%
Group Project
Group Project	15%
Midterm Exam
Mid-Term Examination	30%
Demonstration
Computer Lab and In-Class Activities	10%
Total	100%

Modules of Study

Module	Course Learning Outcomes	Assessments
Course Introduction	Describe the role of various computer database management systems and their impact on e-business strategies. Identify how commercial and open-source Web scripting environments and software tools are used in e-business database applications development, including point-of-sales applications.	Computer Lab and In-Class Activities Mid-Term Examination Group Project
Database Systems	Compare types of database servers and client software and their applications, including data mining and data warehousing. Research and describe multi-media database management applications in an e-business environment.	Computer Lab and In-Class Activities Individual Assignment Mid-Term Examination Group Project
Data Models	Compare types of database servers and client software and their applications, including data mining and data warehousing. Research and describe multi-media database management applications in an e-business environment.	Computer Lab and In-Class Activities Individual Assignment Mid-Term Examination Group Project
The Relational Database Model	Create data forms and extract data reports. Design , develop and implement a database Point of Sale application.	Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Entity Relationship (ER) Modeling	Research and describe multi-media database management applications in an e-business environment. Create data forms and extract data reports. Design , develop and implement a database Point of Sale application. Research , describe, and compare various Database Management System (DBMS) products and their applications.	Computer Lab and In-Class Activities Mid-Term Examination Group Project Final Comprehensive Examination
Advanced Data Modeling	Research and describe multi-media database management applications in an e-business environment. Create data forms and extract data reports. Design , develop and implement a database Point of Sale application. Create and modify the Entity Relationship Diagram (ERD) for new and existing databases.	Computer Lab and In-Class Activities Individual Assignment Group Project Final Comprehensive Examination
Normalization of Database Tables	Create and modify the Entity Relationship Diagram (ERD) for new and existing databases. Research , describe, and compare various Database Management System (DBMS) products and their applications.	Computer Lab and In-Class Activities Group Project Final Comprehensive Examination
Introduction to Structured Query Language (SQL)	Create and modify the Entity Relationship Diagram (ERD) for new and existing databases. Research , describe, and compare various Database Management System (DBMS) products and their applications.	Computer Lab and In-Class Activities Group Project Final Comprehensive Examination
Business Intelligence and Data-Warehousing	Research and describe multi-media database management applications in an e-business environment. Research and describe current and expected future Internet technologies and services with respect to their respective value to databases and e-business. Research , describe, and compare various Database Management System (DBMS) products and their applications.	Computer Lab and In-Class Activities Final Comprehensive Examination

Required Resources

Title	ISBN
MindTap: Campbell, J., Carey, P., Shaffer, A., & Shellman, M. (2025). New Perspectives Microsoft® 365® Access® Comprehensive (1st ed.). Toronto, ON: Cengage.	9780357882344
Coronel, C., & Morris, S. (2023). Database Systems: Design, Implementation, & Management (14th ed.). Toronto, ON: Cengage.	9780357673034

Supplemental Resources

Title	ISBN
To be supplied by the professor.

Resource(s):

Course material costs can be found through the Humber Bookstore.

Additional Tools and Equipment

Microsoft Access

Prior Learning Assessment & Recognition (PLAR)

Prior Learning Assessment and Recognition (PLAR) is the formal evaluation and credit-granting process whereby candidates may obtain credits for prior learning. Prior learning includes the knowledge competencies and skills acquired, in both formal and informal ways, outside of post-secondary education. Candidates may have their knowledge, skills and competencies evaluated against the learning outcomes as defined in the course outline. Please review the Assessment Methods Glossary for more information on the Learning Portfolio assessment methods identified below.

The method(s) that are used to assess prior learning for this course may include:

Challenge Exam (results recorded as a % grade and added to student’s CGPA)
Learning Portfolio (results reflected as SAT and not added to student’s CGPA)
Interview

Please contact the Program Coordinator for more details.

Academic Regulations

It is the student's responsibility to be aware of the College Academic Regulations. The Academic Regulations apply to all applicants to Humber and all current students enrolled in any program or course offered by Humber, in any location. Information about academic appeals is found in the Academic Regulations.

Anti-Discrimination Statement

At Humber College, all forms of discrimination and harassment are prohibited. Students and employees have the right to study, live and work in an environment that is free from discrimination and harassment. If you need assistance on concerns related to discrimination and harassment, please contact the Centre for Human Rights, Equity and Inclusion or the Office of Student Conduct.

Accessible Learning Services

Humber strives to create a welcoming environment for all students where equity, diversity and inclusion are paramount. Accessible Learning Services facilitates equal access for students with disabilities by coordinating academic accommodations and services. Staff in Accessible Learning Services are available by appointment to assess specific needs, provide referrals and arrange appropriate accommodations. If you require academic accommodations, contact:

Accessible Learning Services

North Campus: (416) 675-6622 X5090

Lakeshore Campus: (416) 675-6622 X3331

Academic Integrity

Academic integrity is essentially honesty in all academic endeavors. Academic integrity requires that students avoid all forms of academic misconduct or dishonesty, including plagiarism, cheating on tests or exams or any misrepresentation of academic accomplishment.

Disclaimer

While every effort is made by the professor/faculty to cover all material listed in the outline, the order, content, and/or evaluation may change in the event of special circumstances (e.g. time constraints due to inclement weather, sickness, college closure, technology/equipment problems or changes, etc.). In any such case, students will be given appropriate notification in writing, with approval from the Senior Dean (or designate) of the Faculty.

Copyright

Copyright is the exclusive legal right given to a creator to reproduce, publish, sell or distribute his/her work. All members of the Humber community are required to comply with Canadian copyright law which governs the reproduction, use and distribution of copyrighted materials. This means that the copying, use and distribution of copyright- protected materials, regardless of format, is subject to certain limits and restrictions. For example, photocopying or scanning an entire textbook is not allowed, nor is distributing a scanned book.

See the Humber Libraries website for additional information regarding copyright and for details on allowable limits.

Humber College Institute of Technology and Advanced Learning • 2025/2026.