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.
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
For what reasons is 2-phase locking protocol required? Explain. Discuss the disadvantages of basic 2-phase locking protocol. List the ways and means that can be used to overcome the disadvantages.
What are integrity constraints? Discuss the various types of integrity constraints that can be imposed on database.
Compute the closure of the following set F of functional dependencies for relation schema
R = (A, B, C, D, E).
List the candidate keys for R.
List and explain the 4 basic properties of a Transaction with the help of appropriate examples.
Write SQL commands for each of the following. Also illustrate the usage of each command through suitable example.
(i) Creation of views
(ii) Creation of sequences
(iii) Outer join
(iv) To give access permission to any use
How are database security and database integrity related? Briefly discuss the different levels of security measures which may be considered to protect the database.
Write a query in SQL for the following:
(i) Find the name of authors whose books are published by "ABC Press".
(ii) Find the name of the author and price of the book, whose Book_ID is '100'.
(iii) Find the title of the books which are published by Publisher_ID '20' and are published in year 2011.
(iv) Find the address of the publisher who has published Book_ID "500".