WGU C175 Data management Exam
Preparation Questions and Assured Success
Solutions Newly updates 2024/2025
Entity - correct answer a person, place, thing, concept, or event for which data can be
sored
Attribute - correct answer a characteristic of an entity or object. It has a name and a
data type.
Relationship - correct answer an association between entities
Constraint - correct answer a restriction placed on data, usually expressed in the form
of rules
One-to-one (1:) relationship - correct answer exists between a pair of tables when a
single record in the first table is related to only one record in the second table, and a
single record in the second table is related to only one record in the first table
One-to-many (1:m) relationship - correct answer exists between a pair of tables when
a single record in the first single record in the first table can be related to one or more
records in the second table, but a single record in the second table can be related to
only one record in the first table.
Many-to-many (m:m) relationship - correct answer exists between a pair of tables
when a single record in the first table can be related to one or more records in the
second table and a single record in the second table can be related to one or more
records in the first table.
Business rule - correct answer a description of a policy, procedure, or principle within
an organization.
,Hierarchical model - correct answer an early database model whose basic concepts
and characteristics formed the basis for subsequent database development. It is based
on an upside-down tree structure in which each record is called a segment. The top
record is the root segment. Each segment has a 1:m relationship to the segment directly
below it.
Segment - correct answer in the hierarchical data model, the equivalent of a file
system's record type.
Network model - correct answer an early data model that represented data as a
collection of record types in 1:m relationships.
Schema - correct answer a logical grouping of database objects, such as tables,
indexes, views, and queries that are related to each other.
Subschema - correct answer the portion of the database that interacts with application
programs
Data manipulation language (dml) - correct answer the set of commands that allows an
end user to manipulate the data in the database, such as select, insert, update, delete
etc.
Data definition language (ddl) - correct answer the language that allows a database
administrator to define the database structure, schema, and subschema
Relational model - correct answer based on mathematical set theory and represents
data as independent relations. Each relation (table) is related to each other through the
sharing of common entity characteristics. Developed by e. F. Codd of ibm in 1970
Relation or table - correct answer a two-dimensional structure composed of
intersecting rows (entities) and columns (attributes).
Tuple - correct answer a row in the relational model
, Relational database management system (rdbms) - correct answer a collection of
programs that manages a relational database
Sql-based relational database parts - correct answer 1. End-user interface
2. A collection of tables stored in the database
3. Sql engine
Entity relationship (er) model (erm) - correct answer a data model that describes
relationships (1:1, 1:m, and m:n) among entities at the conceptual level with the help of
er diagrams.
Entity relationship diagram (erd) - correct answer a diagram that depicts an entity
relationship model's entities, attributes, and relations
Entity instance or entity occurance - correct answer a row in a relational table
Entity set - correct answer a collection of like entities
Object-oriented data model (oodm) - correct answer a data model whose basic
modeling structure is an object
Object - correct answer an abstract representation of a real world entity that has a
unique identity, embedded properties, and the ability to interact with other objects and
itself
Object-oriented database management system (oodbms) - correct answer data
management software used to manage data in an object-oriented database model
Relational database - correct answer a collection of relations that contain the data
describing a particular business environment.
Preparation Questions and Assured Success
Solutions Newly updates 2024/2025
Entity - correct answer a person, place, thing, concept, or event for which data can be
sored
Attribute - correct answer a characteristic of an entity or object. It has a name and a
data type.
Relationship - correct answer an association between entities
Constraint - correct answer a restriction placed on data, usually expressed in the form
of rules
One-to-one (1:) relationship - correct answer exists between a pair of tables when a
single record in the first table is related to only one record in the second table, and a
single record in the second table is related to only one record in the first table
One-to-many (1:m) relationship - correct answer exists between a pair of tables when
a single record in the first single record in the first table can be related to one or more
records in the second table, but a single record in the second table can be related to
only one record in the first table.
Many-to-many (m:m) relationship - correct answer exists between a pair of tables
when a single record in the first table can be related to one or more records in the
second table and a single record in the second table can be related to one or more
records in the first table.
Business rule - correct answer a description of a policy, procedure, or principle within
an organization.
,Hierarchical model - correct answer an early database model whose basic concepts
and characteristics formed the basis for subsequent database development. It is based
on an upside-down tree structure in which each record is called a segment. The top
record is the root segment. Each segment has a 1:m relationship to the segment directly
below it.
Segment - correct answer in the hierarchical data model, the equivalent of a file
system's record type.
Network model - correct answer an early data model that represented data as a
collection of record types in 1:m relationships.
Schema - correct answer a logical grouping of database objects, such as tables,
indexes, views, and queries that are related to each other.
Subschema - correct answer the portion of the database that interacts with application
programs
Data manipulation language (dml) - correct answer the set of commands that allows an
end user to manipulate the data in the database, such as select, insert, update, delete
etc.
Data definition language (ddl) - correct answer the language that allows a database
administrator to define the database structure, schema, and subschema
Relational model - correct answer based on mathematical set theory and represents
data as independent relations. Each relation (table) is related to each other through the
sharing of common entity characteristics. Developed by e. F. Codd of ibm in 1970
Relation or table - correct answer a two-dimensional structure composed of
intersecting rows (entities) and columns (attributes).
Tuple - correct answer a row in the relational model
, Relational database management system (rdbms) - correct answer a collection of
programs that manages a relational database
Sql-based relational database parts - correct answer 1. End-user interface
2. A collection of tables stored in the database
3. Sql engine
Entity relationship (er) model (erm) - correct answer a data model that describes
relationships (1:1, 1:m, and m:n) among entities at the conceptual level with the help of
er diagrams.
Entity relationship diagram (erd) - correct answer a diagram that depicts an entity
relationship model's entities, attributes, and relations
Entity instance or entity occurance - correct answer a row in a relational table
Entity set - correct answer a collection of like entities
Object-oriented data model (oodm) - correct answer a data model whose basic
modeling structure is an object
Object - correct answer an abstract representation of a real world entity that has a
unique identity, embedded properties, and the ability to interact with other objects and
itself
Object-oriented database management system (oodbms) - correct answer data
management software used to manage data in an object-oriented database model
Relational database - correct answer a collection of relations that contain the data
describing a particular business environment.
