- | P a g e
WGU D426 OBJECTIVE ASSESSMENT FINAL
EXAM NEWEST 2025 ACTUAL EXAM
COMPLETE 100 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
A ____ does not have an identifying attribute. Instead, a weak entity usually has a relationship, called an ____, to another entity, called an ____. Cardinality of the identifying entity is 1(1). - ANSWER-Weak entity; identifying relationship; identifying entity
A ____ is a subset of another entity type, called the supertype entity. - ANSWER-Subtype entity
A supertype entity identifies its subtype entities. The identifying relationship is called an ____. - ANSWER-IsA relationship
____ are entities that have many common attributes and relationships. - ANSWER-Similar entities
- / 3
- | P a g e
A ____ of a supertype entity is a group of mutually exclusive subtype entities. - ANSWER-Partition
Each partition corresponds to an optional ____ of the supertype entity. - ANSWER-Partition attribute
Variations in cardinality conventions are common. One popular convention, called ____, depicts cardinality as a circle (zero), a short line (one), or three short lines (many). The three short lines look like a bird's foot, hence the name "____". - ANSWER- Crow's foot notation
Decompose a complex model into a group of related entities, called a ____. - ANSWER-Subject area
Refer to strong entities as ____ and weak entities as ____. - ANSWER-Independent; dependent
____ is commonly used for software development. Software data structures are similar to database structures, so UML includes ER conventions. - ANSWER-Unified Modeling Language (UML)
- / 3
- | P a g e
____ stands for Information DEFinition version 1x. ____ became popular, in part, due to early adoption by the United States Department of Defense. - ANSWER-IDEF1X
____ appeared in an early ER modeling paper by Peter Chen.____ is not standardized but often appears in literature and tools.
- ANSWER-Chen notation
A strong entity becomes a ____. The primary key must be unique and non-NULL, and should be stable, simple, and meaningless. Single-column primary keys are best, but if no such column exists, a composite primary key may have the required properties. - ANSWER-Strong table
An ____ is a single-column primary key created by the database designer when no suitable single-column or composite primary key exists. - ANSWER-Artificial key
A subtype entity becomes a ____. - ANSWER-Subtype table
A weak entity becomes a ____. - ANSWER-Weak table
- / 3