C170 DATA MANAGEMENT APPLICATIONS
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS EXAMINATION TEST 2026
COMPLETE QUESTIONS AND SOLUTIONS
GRADED A+
⩥ True or False:
Analysis considers implementation issues related to a specific database
system. Answer: - False
- Analysis documents database requirements, without regard to
implementation details for any database system.
⩥ True or False:
An entity-relationship model is developed for all database design
projects. Answer: - False
- An entity-relationship model is developed in the analysis phase.
Analysis is sometimes omitted for simple databases with just a few users
and tables.
, ⩥ True or False:
Entities, relationships, and attributes always map directly to tables,
foreign keys, and columns, respectively.. Answer: - False
- In the logical design phase, entities, relationships, and attributes
usually become tables, foreign keys, and columns. Sometimes, however,
an entity splits into several tables, several entities merge into one table,
and relationships and attributes become tables.
⩥ Ternary Relationships. Answer: - involves three different entity types
- Ex: many-to-many-to-many ternary relationship among salespersons,
customers, and products
⩥ Relationship Maximum. Answer: - greatest number of instances of
one entity that can relate to a single instance of another entity
- a relationship has two maxima, one for each of the related entities
- Maxima are usually specified as "one" or "many"
- Ex: a department can have many employees; an employee can have
one department
⩥ Determine the maxima for each relationship. The correct answer may
depend on business rules.
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS EXAMINATION TEST 2026
COMPLETE QUESTIONS AND SOLUTIONS
GRADED A+
⩥ True or False:
Analysis considers implementation issues related to a specific database
system. Answer: - False
- Analysis documents database requirements, without regard to
implementation details for any database system.
⩥ True or False:
An entity-relationship model is developed for all database design
projects. Answer: - False
- An entity-relationship model is developed in the analysis phase.
Analysis is sometimes omitted for simple databases with just a few users
and tables.
, ⩥ True or False:
Entities, relationships, and attributes always map directly to tables,
foreign keys, and columns, respectively.. Answer: - False
- In the logical design phase, entities, relationships, and attributes
usually become tables, foreign keys, and columns. Sometimes, however,
an entity splits into several tables, several entities merge into one table,
and relationships and attributes become tables.
⩥ Ternary Relationships. Answer: - involves three different entity types
- Ex: many-to-many-to-many ternary relationship among salespersons,
customers, and products
⩥ Relationship Maximum. Answer: - greatest number of instances of
one entity that can relate to a single instance of another entity
- a relationship has two maxima, one for each of the related entities
- Maxima are usually specified as "one" or "many"
- Ex: a department can have many employees; an employee can have
one department
⩥ Determine the maxima for each relationship. The correct answer may
depend on business rules.
