<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PHTV9K7" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to Main Content
Product cover image for Clearbrook Diabetes Centre: Designing a Database

Clearbrook Diabetes Centre: Designing a Database

Derrick Neufeld, Anna Svikhnushin

Product #:W46502
Supplier:Ivey
Discipline:Information Systems, Operations Management
Setting:Canada, 2022
Details:Exercise (PDF) • 4 pages • 2025-10-28

Subjects:

Process improvementDigital transformationTechnology and analyticsInformation systems

Industries:

Healthcare sector

Geography:

CanadaNorth America
Your Price:$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

  • Free Educator Copy
  • Free Teaching Notes
  • Build your coursepack
  • Discounted academic price

The head nurse at the Clearbrook Diabetes Centre (CDC) faced mounting pressure to improve patient outcomes in light of rapidly advancing diabetes technologies. For years, CDC had relied on manual data collection during in-person consultations, overlooking new tools such as continuous glucose monitors and nutrition apps. Seeing the potential for a centralized, multi-user system to transform the care CDC provided its patients, DeMille sought guidance on building a relational database to track patient, treatment, and resource data, laying the groundwork for a possible digital overhaul.

Learning Objectives

This exercise is intended for courses in information systems, data analytics, health-care informatics, and non-profit management at both undergraduate and graduate levels. It can be taught from perspectives such as data modelling (with a focus on Barker Notation), database design, and the use of structured data to improve decision-making in health-care settings.

After working through the exercise and assignment questions, students will be able to do the following:
  • Analyze and develop a structured data model that captures CDC’s critical data elements and relationships (e.g., patients, certified diabetes educators (CDEs), appointments, glucose readings, and nutrition records).
  • Identify the operational and clinical challenges arising from CDC’s current paper- and spreadsheet-based data practices and evaluate how a relational database could improve efficiency, care quality, and scalability.
  • Apply data analytics concepts to patient-generated data to improve care outcomes, identify high-risk cases, and assess CDE effectiveness.
  • Evaluate the benefits and challenges of transitioning a non-profit health-care provider to a centralized database, considering issues such as data migration, privacy and security, staff resistance, and budget constraints.
  • Formulate strategic recommendations that leverage structured data to support both improved patient care and potential expansion of CDC’s model to other clinics.
Loading
Exercise: Clearbrook Diabetes Centre: Designing a Database (English version) | Ivey Publishing