Dad220 Ch 3 Already Passed

fully NULL foreign key {Ans: A fully NULL foreign key is a simple or composite foreign key in which all columns are NULL.}Qualifier {Ans: Qualifier describes the meaning of the attribute. Ex: First, Last, and Alternate. Sometimes a qualifier is unnecessary and can be omitted. Ex: StudentNumber.}Relationship Names {Ans: Relationships names have the form Entity-Verb-Entity, such as Division-Contains-Department. When the related entities are obvious, in ER diagrams or informal conversation, Verb is sufficient and entity names can be omitted. The verb should be active rather than passive. Ex: Manages rather than IsManagedBy. Occasionally, the same verb relates different entity pairs. Ex: Order-Contains-LineItem and Division-Contains-Department.}Restrict, when the row containing Maria Rodriguez is deleted? {Ans: the delete is rejected. Restrict rejects referential integrity violations. If Maria Rodriguez is deleted, the managers of Sales and Marketing would not match any ID, so the delete is rejected.}In interviews and documents, entities, relationships, and attributes surface as nouns and verbs: {Ans: Entities usually appear as nouns, but not all nouns are entities. Designers should ignore nouns that denote specific data or are not relevant to the database. Relationships are often expressed as verbs. Designers should ignore statements that are not