What is the difference between covering and overlapping constraints use in DBMS?

What is the difference between covering and overlapping constraints use in DBMS?

  • What is the difference between covering and overlapping constraints use in DBMS?

  • Answer:

    In reference with below Employee Entity Relational Model Overlap Constraints : Can "Karthik" (employee) be an Hourly_Emps as well as a Contract_Emps entity? (Allowed/Disallowed) - In this scenario the hourly employee karthik cannot be a contract employee - Disallowed - This explains the Overlap constraints. Covering Constraints : Does every hourly employees and contract employees are employees of this organization. Ans : Yes, whether contract/hourly employees are belongs to the master employees entity - This explains the Covering constraints.

dgcharitha at Database Administrators Visit the source

Was this solution helpful to you?

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.