Skip to Main Content
Health plan is generally acknowledged as the organization to commit at providing the delivery of predetermined health care benefits for a group of people. Simply, health plan is the list of health benefits covered by an organization for its employees. Two types of health plans were discovered to be in practice. Type 1 offers preset or packaged health plans that were put together by a Managed Care Organization (MCO). Meanwhile, Type 2 health plan was constructed by the hiring organization itself. Hence, providing exact mapping to the organization's employees' health requisites. However, storing Type 2 health plans within a single database introduces complexities. In this paper, we propose a physical model implementing a previously constructed semistructured data model which focuses on outpatient care medical service.