Common use of Database Design Clause in Contracts

Database Design. Figure 9 presents the Entity Relationship (ER) schema of the Medication service that is included in the Care and Wellness database schema. All the tables currently included in this database are described in Table 3. Similarly to the Agenda Service described earlier, in order to protect the structure and data of the base tables, we have implemented the VIEW_PERSON_MEDICATION and VIEW_MEDICINE view structures that provide all data required by the Care and Wellness methods. NAME FK1 ROUTE_ID DATE_END FK2 FREQUENCY_ID DOSE COMMENTS MEDICINE_FREQUENCY PERSON_MEDICATION MEDICINE MEDICINE_ROUTE

Database Design. Figure 9 11 presents the Entity Relationship (ER) schema of the Medication service that is included in the Care and Wellness database schema. All the tables currently included in this database are described in Table 3. Similarly to the Agenda Service described earlier, in order to protect the structure and data of the base tables, we have implemented the VIEW_PERSON_MEDICATION and VIEW_MEDICINE view structures that provide all data required by the Care and Wellness methods. NAME FK1 ROUTE_ID FK2 PERSON_ID DATE_START DATE_END FK2 FREQUENCY_ID DOSE COMMENTS MEDICINE_FREQUENCY PERSON_MEDICATION MEDICINE MEDICINE_ROUTEMEDICINE_ROUTE MEDICINE