WGU D427 SQL APPLICATIONS PRACTICE
SCRIPT 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
⩥ Hashed Files. Answer: A file that has been encrypted for security
purposes.
⩥ Heap File. Answer: An unsorted set of records.
⩥ Information. Answer: The transformation of raw data into useful facts.
⩥ Punch Card. Answer: A card that is perforated and can hold
commands or data.
⩥ Structured Data. Answer: Information with a high degree of
organization.
⩥ Unstructured Data. Answer: Information that does not have structure
(such as text)
⩥ Binary Relationship. Answer: A relationship between two entity types.
,⩥ Unary Relationship. Answer: An associate occurrence of an entity
type with other occurrences of the same entity type.
⩥ Cardinality. Answer: The maximum number of entities that can be
involved in a particular relationship.
⩥ E-R Model
*E-R = Entity - Relationship. Answer: Diagram of entities together with
their attributes and the relationship among them.
⩥ Intersection Data. Answer: It is data that describes a many-to-many
relationship.
⩥ Modality. Answer: It is a minimum number of entity occurrences that
can be involved in a relationship.
⩥ One-to-one Binary Relationship. Answer: It means that a single
occurrence of one entity type can be associated with a single occurrence
of the other entity type and vice versa.
⩥ Ternary Relationship. Answer: Involves three different entity types.
, ⩥ Unique identifier. Answer: It is used to uniquely identify each record
in a database table.
⩥ Attribute. Answer: A property, characteristic, or fact that we know
about an entity.
⩥ "A salesperson works in one office."
What is the name of this relationship?. Answer: One-to-one binary
relationship
⩥ "A salesperson sells to many customers."
What is the name of this relationship?. Answer: One-to-many binary
relationship
⩥ "A salesperson is authorized to sell many products, and a product can
be sold by many salespersons."
What is the name of this relationship?. Answer: Many-to-many binary
relationship
SCRIPT 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
⩥ Hashed Files. Answer: A file that has been encrypted for security
purposes.
⩥ Heap File. Answer: An unsorted set of records.
⩥ Information. Answer: The transformation of raw data into useful facts.
⩥ Punch Card. Answer: A card that is perforated and can hold
commands or data.
⩥ Structured Data. Answer: Information with a high degree of
organization.
⩥ Unstructured Data. Answer: Information that does not have structure
(such as text)
⩥ Binary Relationship. Answer: A relationship between two entity types.
,⩥ Unary Relationship. Answer: An associate occurrence of an entity
type with other occurrences of the same entity type.
⩥ Cardinality. Answer: The maximum number of entities that can be
involved in a particular relationship.
⩥ E-R Model
*E-R = Entity - Relationship. Answer: Diagram of entities together with
their attributes and the relationship among them.
⩥ Intersection Data. Answer: It is data that describes a many-to-many
relationship.
⩥ Modality. Answer: It is a minimum number of entity occurrences that
can be involved in a relationship.
⩥ One-to-one Binary Relationship. Answer: It means that a single
occurrence of one entity type can be associated with a single occurrence
of the other entity type and vice versa.
⩥ Ternary Relationship. Answer: Involves three different entity types.
, ⩥ Unique identifier. Answer: It is used to uniquely identify each record
in a database table.
⩥ Attribute. Answer: A property, characteristic, or fact that we know
about an entity.
⩥ "A salesperson works in one office."
What is the name of this relationship?. Answer: One-to-one binary
relationship
⩥ "A salesperson sells to many customers."
What is the name of this relationship?. Answer: One-to-many binary
relationship
⩥ "A salesperson is authorized to sell many products, and a product can
be sold by many salespersons."
What is the name of this relationship?. Answer: Many-to-many binary
relationship
