WGU C175 DATA MANAGEMENT FOUNDATIONS TEST
QUESTIONS & ANSWERS
What is a general definition of data? - ANSWER Raw facts recorded on printed
or electronic media
What are data? - ANSWER Facts collected and stored within a database system
What is a characteristic feature of unstructured data? - ANSWER It has no data
model
Examine diagram #4
Which of the following characterizes unstructured data? - ANSWER A.
Which of flat files is true? - ANSWER They possess no internal hierarchical
organization
Which technology possesses no internal organization? - ANSWER Flat files
How were data accessed before database management systems? - ANSWER
Sequentially from plain files
What is the uniquely distinguishable item related to which data can be grouped
in an entity-relationship diagram? - ANSWER Entity types
See diagram #9
Which classification fits the box marked "Quantity" in the given entity-
relationship diagram? - ANSWER Intersection data
, Which classification is an entity? - ANSWER Event
See diagram #11
What is the entity-relationship diagram about a car rental agency depicting? -
ANSWER One maker produced at least one of the agency's cars
A salesperson is authorized to sell 12 products; a product may be sold by 10
salespersons.
What kind of binary relationship is established in this diagram? - ANSWER
Many-to-many
See diagram #13
What kind of relationship is represented by the cardinality in the diagram? -
ANSWER Many customers to many products
See diagram #14
How is the cardinality of the customers misrepresented? - ANSWER There are
a number of customers, but the cardinality indicates one customer
See diagram #15
What is the correct interpretation of the modality on the right-hand side of the
relationship? - ANSWER At least zero customers
See entity-relationship diagram #16
What is the product modality? - ANSWER At least one
See entity-relationship diagram #17
QUESTIONS & ANSWERS
What is a general definition of data? - ANSWER Raw facts recorded on printed
or electronic media
What are data? - ANSWER Facts collected and stored within a database system
What is a characteristic feature of unstructured data? - ANSWER It has no data
model
Examine diagram #4
Which of the following characterizes unstructured data? - ANSWER A.
Which of flat files is true? - ANSWER They possess no internal hierarchical
organization
Which technology possesses no internal organization? - ANSWER Flat files
How were data accessed before database management systems? - ANSWER
Sequentially from plain files
What is the uniquely distinguishable item related to which data can be grouped
in an entity-relationship diagram? - ANSWER Entity types
See diagram #9
Which classification fits the box marked "Quantity" in the given entity-
relationship diagram? - ANSWER Intersection data
, Which classification is an entity? - ANSWER Event
See diagram #11
What is the entity-relationship diagram about a car rental agency depicting? -
ANSWER One maker produced at least one of the agency's cars
A salesperson is authorized to sell 12 products; a product may be sold by 10
salespersons.
What kind of binary relationship is established in this diagram? - ANSWER
Many-to-many
See diagram #13
What kind of relationship is represented by the cardinality in the diagram? -
ANSWER Many customers to many products
See diagram #14
How is the cardinality of the customers misrepresented? - ANSWER There are
a number of customers, but the cardinality indicates one customer
See diagram #15
What is the correct interpretation of the modality on the right-hand side of the
relationship? - ANSWER At least zero customers
See entity-relationship diagram #16
What is the product modality? - ANSWER At least one
See entity-relationship diagram #17
