Question
An organization needs to provide Medical facilities to its employees and their dependents. Organization is having a list of Doctors, Hospitals and Test centres for the employees facility. An employee may get Medical facility from the list of Doctors, Hospitals and Test centres provided by the organization to them. Employee does not need to pay anything for the facilities availed. The Doctors, Hospitals and Test centres directly raise their bill to the organization.
Identify the entities, relationships, constraints and cardinality and construct an ER diagram for the above mentioned specifications. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram.
Answer :
Word Count : 474
In the given scenario, the organization is responsible for providing medical facilities to its employees and their dependents. To design the ER (Entity-Relationship) model, it is necessary to identify the entities, relationships, attributes, constraints, and cardinalities. Entities and Attributes: 1. Employee – Attributes can include Employee\_ID (Primary Key), Name, Department, Designation, Contact\_Number, and Address. 2. Dependent – Attributes can include Dependent\_ID (Primary Key), Name, Relation\_to\_Employee, Age, and Gender. Each dependent is linked to a specific employee. 3. Doctor – Attributes include Doctor\_ID (Primary Key), Name, Specialization, and Contact\_Number. 4. Hospital – Attributes include Hospital\_ID (Primary Key), Name, Address, and Contact\_Number. 5. Test\_Centre – Attributes include Centre\_ID (Primary Key), Name, Address, and Type\_of\_Tests. 6. Bill – Attributes include Bill\_ID ____ _____ _____ _________ ______ ___ ________ _______.
___ _________ _____ _______ _________ _______ ___ ____ _____ ______ ________.
___ _________ __________ ______ ____ ____ ______ _____ __________ _________.
________ ____ _______ _______ ___ _________ __________.
_______ ________ ________ _________ ___ _________ _________ __________ ____.
_____ ________ __________ ___ _______ ___ ____ _______ _________ ___ _____.
____ ______ ______ ________ _____ __________ _______ _______ _______ ____.
____ _________ ______ ___ ________.
______ ____ ____ ___ ______ _______ ______ ________ ___ _____ _____ ________.
_____ ____ ___ ___ _________ __________ ______ _________ __________ __________ _________ _______.
__________ _________ _________ _______ ___ ___ ___ _____ _______ ________ _____ _________.
_________ _____ ______ _______ ___.
__________ _________ _____ ________ ____ ______ _______ _________ ____ _______ __________ _____.
___ ______ _____ ________ ________ ________ __________ ______ _________ _________ ____ _______.
_________ ________ ___ _________ ___ ___ ___ _____ _________ _____ ________ _____.
__________ ______ ________ _____ ____ _______ ___ _____ _____ ___ ____.
___ _________ ___ ______ _______ __________ ________ _____ ___ _________.
______ ______ ________ _______ ________ ________ ___ __________ ________ ___.
___ ________ _______ ________ ______.
____ ___ _________ ____ ________.
______ _________ ___ ___ _______ __________ _____ __________ ________.
______ _____ ________ __________ ______.
__________ __________ _____ ________ __________ ___ ________ _______ _____ __________ ________ _______.
_____ ___ ______ _______ _______ __________ __________ ___ ______.
_______ _________ _________ ________ ___ _________ ______ ________.
__________ ___ ____ ___ __________ _____.
______ _______ ________ ____ __________ ________ ___.
______ _____ _______ _______ ____ ___ _________ ______ ___.
___ ______ __________ _______ _______ ___ _____ ___ ___.
______ __________ ______ _______ _____ ____ ____.
__________ ____ ___ ___ ________ _____ _____ ______ ____ ____ _____ ________.
_________ ________ _____ ___ _____ _______ ______.
______ ______ _________ _______ ____.
_____ ______ ___ _______ _______ ______.
__________ _________ ____ _____ ___ ________ _________ _____.
_______ __________ __________ _________ ____ _________ __________ _______ _____ __________ _____ _________.
______ ____ _____ __________ _________ _____ _______ ___.
___ _________ _______ _____ __________ ____ ___.
_____ _______ _____ _____ _________ _________ ______.
___ ___ ___ ____ ___ ________.
________ ____ _______ _________ ___ ______ ________ ___.
Get Full Answer on WhatsApp
In the given scenario, the organization is responsible for providing medical facilities to its employees and their dependents. To design the ER (Entity-Relationship) model, it is necessary to identify the entities, relationships, attributes, constraints, and cardinalities. Entities and Attributes: 1. Employee – Attributes can include Employee\_ID (Primary Key), Name, Department, Designation, Contact\_Number, and Address. 2. Dependent – Attributes can include Dependent\_ID (Primary Key), Name, Relation\_to\_Employee, Age, and Gender. Each dependent is linked to a specific employee. 3. Doctor – Attributes include Doctor\_ID (Primary Key), Name, Specialization, and Contact\_Number. 4. Hospital – Attributes include Hospital\_ID (Primary Key), Name, Address, and Contact\_Number. 5. Test\_Centre – Attributes include Centre\_ID (Primary Key), Name, Address, and Type\_of\_Tests. 6. Bill – Attributes include Bill\_ID ____ _____ _____ _________ ______ ___ ________ _______.
___ _________ _____ _______ _________ _______ ___ ____ _____ ______ ________.
___ _________ __________ ______ ____ ____ ______ _____ __________ _________.
________ ____ _______ _______ ___ _________ __________.
_______ ________ ________ _________ ___ _________ _________ __________ ____.
_____ ________ __________ ___ _______ ___ ____ _______ _________ ___ _____.
____ ______ ______ ________ _____ __________ _______ _______ _______ ____.
____ _________ ______ ___ ________.
______ ____ ____ ___ ______ _______ ______ ________ ___ _____ _____ ________.
_____ ____ ___ ___ _________ __________ ______ _________ __________ __________ _________ _______.
__________ _________ _________ _______ ___ ___ ___ _____ _______ ________ _____ _________.
_________ _____ ______ _______ ___.
__________ _________ _____ ________ ____ ______ _______ _________ ____ _______ __________ _____.
___ ______ _____ ________ ________ ________ __________ ______ _________ _________ ____ _______.
_________ ________ ___ _________ ___ ___ ___ _____ _________ _____ ________ _____.
__________ ______ ________ _____ ____ _______ ___ _____ _____ ___ ____.
___ _________ ___ ______ _______ __________ ________ _____ ___ _________.
______ ______ ________ _______ ________ ________ ___ __________ ________ ___.
___ ________ _______ ________ ______.
____ ___ _________ ____ ________.
______ _________ ___ ___ _______ __________ _____ __________ ________.
______ _____ ________ __________ ______.
__________ __________ _____ ________ __________ ___ ________ _______ _____ __________ ________ _______.
_____ ___ ______ _______ _______ __________ __________ ___ ______.
_______ _________ _________ ________ ___ _________ ______ ________.
__________ ___ ____ ___ __________ _____.
______ _______ ________ ____ __________ ________ ___.
______ _____ _______ _______ ____ ___ _________ ______ ___.
___ ______ __________ _______ _______ ___ _____ ___ ___.
______ __________ ______ _______ _____ ____ ____.
__________ ____ ___ ___ ________ _____ _____ ______ ____ ____ _____ ________.
_________ ________ _____ ___ _____ _______ ______.
______ ______ _________ _______ ____.
_____ ______ ___ _______ _______ ______.
__________ _________ ____ _____ ___ ________ _________ _____.
_______ __________ __________ _________ ____ _________ __________ _______ _____ __________ _____ _________.
______ ____ _____ __________ _________ _____ _______ ___.
___ _________ _______ _____ __________ ____ ___.
_____ _______ _____ _____ _________ _________ ______.
___ ___ ___ ____ ___ ________.
________ ____ _______ _________ ___ ______ ________ ___.
Get Full Answer on WhatsApp
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★