Andrew’s Dental Chain: Data Modelling

Andrew Chen, chief executive officer of Andrew’s Dental Chain (ADC), faces the challenge of managing and scaling his rapidly growing dental business, which operates 15 clinics across Guangdong Province, China. ADC plans to double its locations within three years, but the current system of manual oversight is proving inadequate. The clinics function as independent entities, raising concerns about the consistency of patient care, staff qualifications, and operational efficiency. To support this expansion, a comprehensive data model for a new standardized information system must be designed to integrate data across all locations and enable better decision-making.

This exercise is intended for courses in information systems and data analytics, particularly at undergraduate and graduate levels. It can be taught from angles such as data modelling with a focus on Barker Notation, database design, and data-driven decision-making in health care. <br><br>After working through the exercise and assignment questions, students should be able to do the following:<ul><li>Create Data Models: Design a comprehensive data model using Barker Notation to represent complex relationships within a multilocation dental business.</li><li>Engage in Data-Driven Decision-Making: Utilize key performance metrics to make informed strategic decisions, optimize resource allocation, and improve business outcomes.</li><li>Implement Scalable Information Systems: Identify and address challenges in scaling information systems across multiple locations, ensuring successful implementation and long-term efficiency.</li><li>Understand Information Systems in the Health Care Context: Explore the specific needs and challenges of data management in dental and health care settings, such as patient care consistency, compliance, and treatment tracking.</li></ul>

• Database design
• Data modelling
• Information systems implementation
• Healthcare operations