WGU D514 OBJECTIVE ASSESSMENT FINAL/WGU
D514 ANALYTICAL METHODS OF HEALTHCARE
LEADERS OA EXAM WITH ACTUAL QUESTIONS AND
CORRECT ANSWERS
CROSS-JOIN - : answers :A __________ combines two tables without comparing columns
without an ON clause. This is the only JOIN that does not require a condition.
SELF-JOIN - : answers :A ___________ joins a table to itself.
Subquery - : answers :Sometimes called a nested query or inner query, is a query within
another SQL query.
Materialized View - : answers :In some databases, view data can be stored. A
________________ ______ is a view for which data is stored at all times. Whenever a base
table changes, the corresponding view tables can also change, so this view must be refreshed.
WITH CHECK OPTION - : answers :When ______ ______ __________ is specified, the
database rejects inserts and updates that do not satisfy the view query WHERE clause.
Intangible Entity - : answers :An _____________ entity is documented in the data model, but
not tracked with data in the database. In an ER diagram, intangible entities are distinguished
with special notation, such as a dashed rectangle or distinct color.
Dependent Entities - : answers :Weak Entities
,Subject Area - : answers :A group of related entities.
Unified Modeling Language (UML) - : answers :Commonly used for software development.
Software data structures are similar to database structures
Logical Design Phase (First Step) - : answers :Each entity becomes a table and each attribute
becomes a column. Tables and columns are revised in subsequent steps.
Third Normal Form - : answers :Informally, a table is in ______ ________ ______ when all
non-key columns depend on the key, the whole key, and nothing but the key.
Second Normal Form - : answers :A table is in _________ ________ ______ when all non-key
columns depend on the whole primary key. In other words, a non-key column cannot depend on
part of a composite primary key. A table with a simple primary key is in this form.
First Normal Form - : answers :Every non-key column depends on the primary key. Every
primary key value appears in exactly one row, and each non-key cell contains exactly one value.
Each primary key is related to exactly one non-key value.
Entity-Relationship Model - : answers :An ______ __________________ ________ is a high-
level representation of data requirements, ignoring implementation details.
Entity - : answers :A person, place, product, concept, or activity.
Relationship - : answers :A statement about two entities.
Attribute - : answers :A descriptive property of an entity.
, Reflexive Relationship - : answers :A _________ ____________ relates an entity to itself.
Entity-Relationship Diagram - : answers :An _____________ ______________, commonly
called an ER diagram, is a schematic picture of entities, relationships, and attributes. Entities are
drawn as rectangles.
Entity Type - : answers :An ______ _______ is a set of things. Ex: All employees in a
company.
Relationship Type - : answers :A _____________ _____ is a set of related things.
Attribute Instance - : answers :An attribute instance is an individual value.
Analysis - : answers :__________ develops an entity-relationship model, capturing data
requirements while ignoring implementation details.
Logical - : answers :__________ design converts the entity-relationship model into tables,
columns, and keys for a particular database system.
Physical - : answers :__________ design adds indexes and specifies how tables are organized
on storage media.
Analysis Steps - : answers :1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
Logical Design Steps - : answers :1. Implement entities
D514 ANALYTICAL METHODS OF HEALTHCARE
LEADERS OA EXAM WITH ACTUAL QUESTIONS AND
CORRECT ANSWERS
CROSS-JOIN - : answers :A __________ combines two tables without comparing columns
without an ON clause. This is the only JOIN that does not require a condition.
SELF-JOIN - : answers :A ___________ joins a table to itself.
Subquery - : answers :Sometimes called a nested query or inner query, is a query within
another SQL query.
Materialized View - : answers :In some databases, view data can be stored. A
________________ ______ is a view for which data is stored at all times. Whenever a base
table changes, the corresponding view tables can also change, so this view must be refreshed.
WITH CHECK OPTION - : answers :When ______ ______ __________ is specified, the
database rejects inserts and updates that do not satisfy the view query WHERE clause.
Intangible Entity - : answers :An _____________ entity is documented in the data model, but
not tracked with data in the database. In an ER diagram, intangible entities are distinguished
with special notation, such as a dashed rectangle or distinct color.
Dependent Entities - : answers :Weak Entities
,Subject Area - : answers :A group of related entities.
Unified Modeling Language (UML) - : answers :Commonly used for software development.
Software data structures are similar to database structures
Logical Design Phase (First Step) - : answers :Each entity becomes a table and each attribute
becomes a column. Tables and columns are revised in subsequent steps.
Third Normal Form - : answers :Informally, a table is in ______ ________ ______ when all
non-key columns depend on the key, the whole key, and nothing but the key.
Second Normal Form - : answers :A table is in _________ ________ ______ when all non-key
columns depend on the whole primary key. In other words, a non-key column cannot depend on
part of a composite primary key. A table with a simple primary key is in this form.
First Normal Form - : answers :Every non-key column depends on the primary key. Every
primary key value appears in exactly one row, and each non-key cell contains exactly one value.
Each primary key is related to exactly one non-key value.
Entity-Relationship Model - : answers :An ______ __________________ ________ is a high-
level representation of data requirements, ignoring implementation details.
Entity - : answers :A person, place, product, concept, or activity.
Relationship - : answers :A statement about two entities.
Attribute - : answers :A descriptive property of an entity.
, Reflexive Relationship - : answers :A _________ ____________ relates an entity to itself.
Entity-Relationship Diagram - : answers :An _____________ ______________, commonly
called an ER diagram, is a schematic picture of entities, relationships, and attributes. Entities are
drawn as rectangles.
Entity Type - : answers :An ______ _______ is a set of things. Ex: All employees in a
company.
Relationship Type - : answers :A _____________ _____ is a set of related things.
Attribute Instance - : answers :An attribute instance is an individual value.
Analysis - : answers :__________ develops an entity-relationship model, capturing data
requirements while ignoring implementation details.
Logical - : answers :__________ design converts the entity-relationship model into tables,
columns, and keys for a particular database system.
Physical - : answers :__________ design adds indexes and specifies how tables are organized
on storage media.
Analysis Steps - : answers :1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
Logical Design Steps - : answers :1. Implement entities
