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.

28 May 2025
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 (Primary Key), Amount, Date, and Status. This entity can be associated with Doctors, Hospitals, or Test Centres as they generate bills for services. Relationships: 1. Employee–Dependent Relationship: One employee can have zero or many dependents, but each dependent is linked to exactly one employee. (1\:N) 2. Employee–Doctor Relationship (Avails): An employee or dependent may avail treatment from any doctor in the list. One doctor can serve multiple
_____ ______ ________ ___ ____ _____ _______.
________ _____ ___ ____ _______ _____ ____ ________ ____ ____ ____.
_________ ___ _____ _____ _________ ___ ______.
__________ _______ ____ __________ _________ _____ ______ _____ __________ _______ _____.
____ __________ ______ _____ ___ ______ _____ _______ ___.
____ __________ ___ ____ ____ _________ ___ _________ __________ ________.
___ __________ _____ _________ ______ ____ _____ _________ _________ ________.
________ ___ _____ __________ ____ ____.
______ ____ __________ _________ ______ ______.
______ _________ ____ _______ ____ _____ ________ _______ ___ ___ __________.
__________ _____ ______ __________ _______ ________ _____ _________ ________ _____.
_______ _____ ________ ___ _______ ______ ________ ___ ________.
_____ _______ ________ ________ ___ ____ ____ _____.
______ ______ ____ ___ ___ ________.
__________ ______ _________ __________ _______ _______ __________ ___ ____ ________ __________ ___.
_____ _________ _________ ____ __________ __________ ___ ______ ____ ______ ______ _______.
__________ _______ _________ ________ ___ _________ _____.
___ __________ ________ _____ ______ ______.
______ _____ ___ _________ ____ ___ ______.
_____ _________ ______ _______ _________ _______ _______.
______ __________ _________ ________ __________ ____ ____ _______ ____ ______ ____ ____.
________ ____ ___ ___ _______ _________ ______.
_____ ____ ____ ______ __________ _______ __________ ________ ______.
_____ ___ _______ _________ _________ ________.
__________ _____ ________ ___ __________ ____ _____ ____ ____ __________ ___ ____.
______ ___ _______ _________ _____ ___ _________ _________ ________ ____ ____ ___.
____ ________ _______ ________ _____ _____ ________ ______ ______ ___.
________ ________ _____ __________ ___ _____ __________.
____ ______ ____ ________ _____ ______.
______ ______ _____ _________ ______.
_______ _________ _____ _____ ______.
______ ______ ______ _________ ______ _________ _________ _____.
____ _____ _____ __________ _________ ________ __________ ______ __________ ____ _______.
____ ___ _________ __________ _________ ____ ________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCS 23 2024 2025 - An organization needs to provide Medical facilities to its employees a | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→