QUESTION: “What is the SQL operator (i.e., keyword) used in conjunction with pattern matching?”
QUESTION: “With which type of constraint is the specification of a deletion rule associated?”
QUESTION: With which of the four types of constraints in Exercise 4 is a requirement that an attribute did not contain a null value associated?
QUESTION: “What is the purpose of the cross-referencing design?”
QUESTION: “What is the difference between a total category and a partial category”?
QUESTION: “How does categorization differ from specialization”?
QUESTION: “What is the difference between a specialization hierarchy and a specialization lattice?”
QUESTION: “What is the type of inheritance property”?
QUESTION: Is the use of the “set null” rule applicable to an identifying relationship type? If yes, explain. If no, definitely explain.
QUESTION: Give examples of types of business rules that are not reflected in a Presentation Layer ER diagram?