Answer Happy

In the light of COVID-19, where everyone is asked to stay healthy, telehealth services have become an increasingly important health tool in our daily life. Telehealth is the use of digital information and communication technologies, such as computers and mobile devices, to access and manage patient health care services. The use of this service provides a platform when patients and the doctors are not in the same place at the same time. When creating a telehealth system for a hospital, a database needs to be created to manage all the required data. Assuming that you are assigned as a database designer for the telehealth system, you are required to propose a database design for the telehealth system implementation by providing the following: (a) Identify ALL possible entities in the telehealth process (give suitable entity name), complete all the entities with suitable attributes together with assign primary key. (Use your assumption to determine the attributes.) (b) Identify ALL relationships, cardinality, and/or participation for each identified entity. (c) Draw an Entity Relationship Diagram (ERD) by clearly stating the relationships between entities, cardinalities and attributes with correct notation. (d) Based on ERD created in (c), convert it into relational schema. State the primary key and foreign key for each relational schema (relations).