Is the use of the “set null” rule applicable to an identifying relationship type? If yes, explain. If no, definitely explain.

QUESTION: Is the use of the “set null” rule applicable to an identifying relationship type? If yes, explain. If no, definitely explain.   [signinlocker] SOLUTION   The Set Null rule cannot be applied to an identifying relationship type because a weak entity type cannot possibly...
Continue reading »

Give examples of types of business rules that are not reflected in a Presentation Layer ER diagram?

QUESTION: Give examples of types of business rules that are not reflected in a Presentation Layer ER diagram?   [signinlocker] SOLUTION   Business rules that cannot be reflected in a Presentation Layer ER diagram include the four categories of business rules (attribute-level business rules, entity-level...
Continue reading »