If NONEXEMPT EMPLOYEE inherits the values of all attributes of EMPLOYEE, this is

Question

If NONEXEMPT EMPLOYEE inherits the values of all attributes of EMPLOYEE, this is an example of:

Select one:

a. Attribute inheritance

b. Completeness

c. Disjoint rule

d. A modeling mistake

e. Overlap rule

If an EMPLOYEE may only be either NONEXEMPT or EXEMPT, this is an example of:

Select one:

a. Attribute inheritance

b. Completeness

c. Disjoint rule

d. A modeling mistake

e. Overlap rule

Question text

When you realize that you can create a supertype with a set of entities, you are approaching the problem using a process known as

Select one:

a. Disjointness

b. Generalization

c. Specialization

d. Overlapping

When you realize that the entity EMPLOYEE can be viewed as having subtypes, you are approaching the problem using a process known as

Select one:

a. Disjointness

b. Generalization

c. Specialization

d. Overlapping

Attribute inheritance eliminates redundancy that would exist if a supertype isn't used.

True

False

If you find that a relationship has attributes, you should consider converting the relationship

Select one:

a. An associative entity

b. An attribute-to-attribute relationship

c. A constraint

d. An identifier

e. A supertype/suptype relationship

Which of the following type of business rules are not normally captured in an EER diagram?

Select one:

a. External entities

b. Relationship constraints

c. Supertype/subtype relationships

d. Terms

In the business rule "a person can rent a car only if he or she possesses a valid driver's license," which is the constraining object?

Select one:

a. Car

b. Driver's license

c. Person

d. Possesses

Explanation / Answer

Please Note: I am supposed to answer the first question, according to Chegg Answering Guidelines. I have answered four questions below. Please Re-Post for receiving the answers on the other Questions.

Answer)

If NONEXEMPT EMPLOYEE inherits the values of all attributes of EMPLOYEE, this is an example of:

Select one:

a. Attribute inheritance

b. Completeness

c. Disjoint rule

d. A modeling mistake

e. Overlap rule

Answer)

a. Attribute inheritance - is the concept when the subtype entities inherit values of all attributes of the supertype. Here, NONEXEMPT EMPLOYEE inherits the values of all attributes of EMPLOYEE.

If an EMPLOYEE may only be either NONEXEMPT or EXEMPT, this is an example of:

Select one:

a. Attribute inheritance

b. Completeness

c. Disjoint rule

d. A modeling mistake

e. Overlap rule

Answer)

c. Disjoint rule - explains that if an entity is of a subtype, then it cannot be of another subtype. Here, EMPLOYEE may only be either NONEXEMPT or EXEMPT.

Question text

When you realize that you can create a supertype with a set of entities, you are approaching the problem using a process known as

Select one:

a. Disjointness

b. Generalization

c. Specialization

d. Overlapping

Answer)

b. Generalization - is the process where we can combine characteristics from two or more classes into a generalized superclass.

When you realize that the entity EMPLOYEE can be viewed as having subtypes, you are approaching the problem using a process known as

Select one:

a. Disjointness

b. Generalization

c. Specialization

d. Overlapping

Answer)

c. Specialization - is the process where in group of entities is divided into sub-groups. Here entity EMPLOYEE can be viewed as having subtypes.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.