Describe "Disjointness Constraints" and provide an example business rule involving an overlap rule.

Solutions

Expert Solution

DISJOINT CONSTRAINTS:

It is the relationship between members of the subclasses and indicates whether it is possible for a member of superclass to be a member of one,or more than one,subclass.

It applies only when a super class has more than one subclass.If the subclasses are disjoint,then an entitiy occurances can be a member of only one of thesubclasses.eg,postgradsor undergrads.

If the value of a descriminator is not null and appears in supertype entity instance then that must be linked with theonly one subtype.This is called disjoint constraint.

business rule involving an overlap rule.

In overlapping constraint,the supertype entity instance can appear in many subtype instances.

In overlapping example consider a teacher can be a student also.then 't' can be linked with student and teacher subtype entity.

suppose Member is super class and its sub-classes one is student and another one is faculty.if(Member)of subclass(student or faculty)not both then it is disjoint.if member both of its subclass then it non-disjoint or overlapping

venereology answered 9 months ago

Next > < Previous

Related Solutions

Provide an example of a skill-, rule-, and knowledge-based failure. Describe how you would deal with...

Provide an example of a skill-, rule-, and knowledge-based failure. Describe how you would deal with each of the failure examples. This is for a discussion post. Please provide 200 words in your response. Thanks in advance.

What is the purpose of the overlap rule? An element of a superclass may not belong...

What is the purpose of the overlap rule? An element of a superclass may not belong to multiple subtypes An element of a supertype can belong to multiple subtypes A subtype of a supertype can be a supertype of a further subtype Two subtypes must have the exact same membership

What is the theory of constraints? Provide some examples of possible constraints for a manufacturer.

Please list and describe six environmental forces that impact business. Provide a specific example of how...

Please list and describe six environmental forces that impact business. Provide a specific example of how the careful consideration of each environmental force is vital to business planning.

Discuss the fiduciary duty and the business judgment rule. Can you find and example?

Define communication and describe the main purposes for communication in business. Use examples and discuss constraints...

Define communication and describe the main purposes for communication in business. Use examples and discuss constraints of all types - in other words what may get in the way of meaningful communication. 200 words

Please describe three different types of growth strategies and provide a real-life business example of each...

Please describe three different types of growth strategies and provide a real-life business example of each one

Describe the defining characteristics of a confounder and provide an example (do NOT use an example...

Describe the defining characteristics of a confounder and provide an example (do NOT use an example mentioned in class).

What is the focus of Business Analytics. Provide the three main levels and provide an example...

What is the focus of Business Analytics. Provide the three main levels and provide an example of their application. Many business are focusing on data harvesting as part of their core competency (Amazon, Facebook, and Google are perfect examples). How could these companies utilize this immense data along with Business Analytics to create and sustain competitive advantage.

Find an example from the last year of a news story involving Moral Hazard. Describe the...

Find an example from the last year of a news story involving Moral Hazard. Describe the relevant players, who/what has committed the Moral Hazard, and the remedy that was used. Clear your choice of story with your instructor before doing your analysis.

Subjects