a) Child b) Owner c) Dominant
View QuestionFunctional dependencies are a generalization of
a) Key dependencies b) Relation dependencies c) Database dependencies d) ...
View QuestionThe completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
a) Total b) Partial c) Should be specified d) Cannot be determined Answer: b Explanation: Partial generalization ...
View QuestionConsider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________
a) Overlapping b) Disjointness c) Uniqueness d) Relational Answer: a Explanation: ...
View QuestionA _____________ constraint requires that an entity belong to no more than one lower-level entity set.
a) Disjointness b) Uniqueness c) Special d) Relational Answer: a Explanation: For ...
View QuestionIf an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
a) Hierarchy b) Multilevel inheritance c) Single inheritance d) Multiple inheritance
View QuestionThere are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
a) Commonality b) Specialization c) Generalization d) Similarity Answer: c Explanation: ...
View QuestionThe refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.
a) Hierarchy b) Bottom-up c) Top-down d) Radical Answer: c Explanation: The design process may also proceed in ...
View QuestionWhich relationship is used to represent a specialization entity?
a) ISA b) AIS c) ONIS d) WHOIS Answer: a Explanation: ...
View QuestionThe entity set person is classified as student and employee. This process is called _________
a) Generalization b) Specialization c) Inheritance d) Constraint generalization Answer: b Explanation: ...
View Question