1
For Expert help and assignment solutions, +254707240657
WGU D426/427 Questions and Answers
(100% Correct Answers) Already Graded
A+
What is a subquery [ Ans: ] A query within another SQL query.
What is an alias in SQL [ Ans: ] A temporary name assigned to a
column or table, created with the AS keyword.
© 2025 Assignment Expert
What is a materialized view [ Ans: ] A view for which data is
stored at all times and must be refreshed when the base table
changes.
What does the WITH CHECK OPTION clause do [ Ans: ] Ensures
Guru01 - Stuvia
that inserts and updates in a view satisfy the view's WHERE clause.
What is an entity in entity-relationship modeling [ Ans: ] A person,
place, product, concept, or activity.
What is a relationship in entity-relationship modeling [ Ans: ] A
statement about two entities.
What is an attribute in entity-relationship modeling [ Ans: ] A
descriptive property of an entity.
What is a reflexive relationship [ Ans: ] A relationship that relates
an entity to itself.
What is an entity-relationship diagram (ER diagram) [ Ans: ] A
schematic picture of entities, relationships, and attributes, where
entities are drawn as rectangles.
What is an entity type [ Ans: ] A set of things, such as all
employees in a company.
What is a relationship type [ Ans: ] A set of related things, such as
employee-manages-department pairs.
What is an attribute type [ Ans: ] A set of values, such as all
employee salaries.
, 2
For Expert help and assignment solutions, +254707240657
What is an entity instance [ Ans: ] An individual thing, such as the
employee Sam Snead.
What is a relationship instance [ Ans: ] A specific statement
about entity instances, such as "Maria Rodriguez manages Sales."
What is an attribute instance [ Ans: ] An individual value, such as
a salary of $35,000.
What is cardinality in entity-relationship modeling [ Ans: ] The
maxima and minima of relationships and attributes.
What is a subtype entity [ Ans: ] A subset of another entity type,
called the supertype entity.
What is a supertype entity [ Ans: ] An entity that has one or more
© 2025 Assignment Expert
subtype entities, such as "vehicle" with subtypes like "car" and
"truck."
What is an IsA relationship [ Ans: ] The identifying relationship
Guru01 - Stuvia
between a supertype and its subtypes.
What is a partition in entity-relationship modeling [ Ans: ] A group
of mutually exclusive subtype entities within a supertype entity.
What is crow's foot notation [ Ans: ] A convention for depicting
cardinality in ER diagrams, using symbols like circles, short lines,
and three short lines (a crow's foot).
What is an intangible entity [ Ans: ] An entity documented in the
data model but not tracked with data in the database.
What are the characteristics of a primary key [ Ans: ] A primary
key should be stable, simple, and meaningless.
What is an artificial key [ Ans: ] A single-column primary key
created by the database designer when no suitable primary key
exists.
What is functional dependence [ Ans: ] The dependence of one
column on another.
What is redundancy in databases [ Ans: ] The repetition of
related values in a table.
For Expert help and assignment solutions, +254707240657
WGU D426/427 Questions and Answers
(100% Correct Answers) Already Graded
A+
What is a subquery [ Ans: ] A query within another SQL query.
What is an alias in SQL [ Ans: ] A temporary name assigned to a
column or table, created with the AS keyword.
© 2025 Assignment Expert
What is a materialized view [ Ans: ] A view for which data is
stored at all times and must be refreshed when the base table
changes.
What does the WITH CHECK OPTION clause do [ Ans: ] Ensures
Guru01 - Stuvia
that inserts and updates in a view satisfy the view's WHERE clause.
What is an entity in entity-relationship modeling [ Ans: ] A person,
place, product, concept, or activity.
What is a relationship in entity-relationship modeling [ Ans: ] A
statement about two entities.
What is an attribute in entity-relationship modeling [ Ans: ] A
descriptive property of an entity.
What is a reflexive relationship [ Ans: ] A relationship that relates
an entity to itself.
What is an entity-relationship diagram (ER diagram) [ Ans: ] A
schematic picture of entities, relationships, and attributes, where
entities are drawn as rectangles.
What is an entity type [ Ans: ] A set of things, such as all
employees in a company.
What is a relationship type [ Ans: ] A set of related things, such as
employee-manages-department pairs.
What is an attribute type [ Ans: ] A set of values, such as all
employee salaries.
, 2
For Expert help and assignment solutions, +254707240657
What is an entity instance [ Ans: ] An individual thing, such as the
employee Sam Snead.
What is a relationship instance [ Ans: ] A specific statement
about entity instances, such as "Maria Rodriguez manages Sales."
What is an attribute instance [ Ans: ] An individual value, such as
a salary of $35,000.
What is cardinality in entity-relationship modeling [ Ans: ] The
maxima and minima of relationships and attributes.
What is a subtype entity [ Ans: ] A subset of another entity type,
called the supertype entity.
What is a supertype entity [ Ans: ] An entity that has one or more
© 2025 Assignment Expert
subtype entities, such as "vehicle" with subtypes like "car" and
"truck."
What is an IsA relationship [ Ans: ] The identifying relationship
Guru01 - Stuvia
between a supertype and its subtypes.
What is a partition in entity-relationship modeling [ Ans: ] A group
of mutually exclusive subtype entities within a supertype entity.
What is crow's foot notation [ Ans: ] A convention for depicting
cardinality in ER diagrams, using symbols like circles, short lines,
and three short lines (a crow's foot).
What is an intangible entity [ Ans: ] An entity documented in the
data model but not tracked with data in the database.
What are the characteristics of a primary key [ Ans: ] A primary
key should be stable, simple, and meaningless.
What is an artificial key [ Ans: ] A single-column primary key
created by the database designer when no suitable primary key
exists.
What is functional dependence [ Ans: ] The dependence of one
column on another.
What is redundancy in databases [ Ans: ] The repetition of
related values in a table.
