WGU D426 OBJECTIVE ASSESSMENT FINAL EXAM
VERSION EXAM 2024 ACTUAL EXAM 160 QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A
A _________ ____________ relates an entity to itself. - ANSWER-Reflexive
Relationship
An _____________ ______________, commonly called an ER diagram, is a
schematic picture of entities, relationships, and attributes. Entities are drawn as
rectangles. - ANSWER-Entity-Relationship Diagram
An ______ _______ is a set of things. Ex: All employees in a company. -
ANSWEREntity Type
A _____________ _____ is a set of related things. - ANSWER-Relationship Type
An attribute instance is an individual value. - ANSWER-Attribute Instance
__________ develops an entity-relationship model, capturing data requirements
while ignoring implementation details. - ANSWER-Analysis
__________ design converts the entity-relationship model into tables, columns,
and keys for a particular database system. - ANSWER-Logical
__________ design adds indexes and specifies how tables are organized on
storage media. - ANSWER-Physical
,1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities - ANSWER-Analysis Steps
1. Implement entities
2. Implement relationships
3. Implement attributes
4. Apply normal form - ANSWER-Logical Design Steps
Refers to maxima and minima of relationships and attributes. -
ANSWERCardinality
______________ ____________ is the least number of instances of one entity
that can relate to a single instance of another entity. - ANSWER-Relationship
minimum
A _________ entity is a subset of another entity type, called the supertype entity.
- ANSWER-Subtype
A supertype entity identifies its subtype entities. The identifying relationship is
called an ____ ________________. - ANSWER-IsA relationship
A __________ of a supertype entity is a group of mutually exclusive subtype
entities. - ANSWER-Partition
, After entities, relationships, attributes, cardinality, and strong and weak entities
are determined, the database designer looks for supertype and subtype entities. -
ANSWER-Database Design
Creating supertype and subtype entities is the _____ of four analysis steps:
1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities - ANSWER-Last Step
Logical design converts an entity-relationship model to tables, columns, and keys
for a specific database system. - ANSWER-Logical Design
One popular convention, called Crow's Foot Notation, 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 "crow's foot notation". - ANSWER-Crow's
Foot Notation
An __________ ______ is documented in the data model, but not tracked with
data in the database. The logical rules and constraints that govern the data but
aren't explicitly stored as data themselves. - ANSWER-Intangible Entity
_________ _________ _____ values should be easy to type and store and is
associated with a SINGLE COLUMN. Small values are easy to specify in an SQL
WHERE clause and speed up query processing. Ex: A 2-byte integer is easier to
VERSION EXAM 2024 ACTUAL EXAM 160 QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A
A _________ ____________ relates an entity to itself. - ANSWER-Reflexive
Relationship
An _____________ ______________, commonly called an ER diagram, is a
schematic picture of entities, relationships, and attributes. Entities are drawn as
rectangles. - ANSWER-Entity-Relationship Diagram
An ______ _______ is a set of things. Ex: All employees in a company. -
ANSWEREntity Type
A _____________ _____ is a set of related things. - ANSWER-Relationship Type
An attribute instance is an individual value. - ANSWER-Attribute Instance
__________ develops an entity-relationship model, capturing data requirements
while ignoring implementation details. - ANSWER-Analysis
__________ design converts the entity-relationship model into tables, columns,
and keys for a particular database system. - ANSWER-Logical
__________ design adds indexes and specifies how tables are organized on
storage media. - ANSWER-Physical
,1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities - ANSWER-Analysis Steps
1. Implement entities
2. Implement relationships
3. Implement attributes
4. Apply normal form - ANSWER-Logical Design Steps
Refers to maxima and minima of relationships and attributes. -
ANSWERCardinality
______________ ____________ is the least number of instances of one entity
that can relate to a single instance of another entity. - ANSWER-Relationship
minimum
A _________ entity is a subset of another entity type, called the supertype entity.
- ANSWER-Subtype
A supertype entity identifies its subtype entities. The identifying relationship is
called an ____ ________________. - ANSWER-IsA relationship
A __________ of a supertype entity is a group of mutually exclusive subtype
entities. - ANSWER-Partition
, After entities, relationships, attributes, cardinality, and strong and weak entities
are determined, the database designer looks for supertype and subtype entities. -
ANSWER-Database Design
Creating supertype and subtype entities is the _____ of four analysis steps:
1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities - ANSWER-Last Step
Logical design converts an entity-relationship model to tables, columns, and keys
for a specific database system. - ANSWER-Logical Design
One popular convention, called Crow's Foot Notation, 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 "crow's foot notation". - ANSWER-Crow's
Foot Notation
An __________ ______ is documented in the data model, but not tracked with
data in the database. The logical rules and constraints that govern the data but
aren't explicitly stored as data themselves. - ANSWER-Intangible Entity
_________ _________ _____ values should be easy to type and store and is
associated with a SINGLE COLUMN. Small values are easy to specify in an SQL
WHERE clause and speed up query processing. Ex: A 2-byte integer is easier to
