DATA MANAGEMENT FOUNDATIONS OA WGU
C175/D426 LATEST VERSION ALL 400
QUESTIONS WITH ANSWERS
What does a 'PI' mean when shown on an entity
in an ER diagram? - answer-Primary Identifier -
used for attribute(s) that uniquely identify the
whole entity
How are maxima and minima depicted in an ER
diagram? - answer-Maxima is the first
letter/number shown (outside of the entity) and
Minima is the letter next to it in parentheses
In what two ways does a DBMS environment
increase effectiveness in working with data? -
answer-- Enables Data Sharing
- Storage of vast volumes of data
A company posts an internet-based newsletter
about their products. What advantage will this
company gain from the relational database
management system that will store customer
,information? - answer-Improved query response
time
What is the method of organizing attributes into
tables? - answer-Data NORMALIZATION
What should a company expect from
implementing a business intelligence system? -
answer-- Financial: Increased profitability
- Productivity: Increased throughput, decreased
workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - answer-A database
model based on mathematical principles
What are the 3 mathematical concepts of the
relational model? - answer-- Domain
- Tuple
- Relation
, Define: Domain - answer-Set of values = 'Data
Type'
Define: Tuple - answer-Finite sequence of values
pulled from a fixed domain = 'Row'
Define: Relation - answer-A named set of tuples,
all from same domain = 'Table'
A tuple position is called a: - answer-Attribute
How is cardinality depicted in a diagram for
many, one, and zero? - answer-- Many = Crow's
Foot
- One = a bar across the end of a relationship (--
||--)
- Zero = Circle
C175/D426 LATEST VERSION ALL 400
QUESTIONS WITH ANSWERS
What does a 'PI' mean when shown on an entity
in an ER diagram? - answer-Primary Identifier -
used for attribute(s) that uniquely identify the
whole entity
How are maxima and minima depicted in an ER
diagram? - answer-Maxima is the first
letter/number shown (outside of the entity) and
Minima is the letter next to it in parentheses
In what two ways does a DBMS environment
increase effectiveness in working with data? -
answer-- Enables Data Sharing
- Storage of vast volumes of data
A company posts an internet-based newsletter
about their products. What advantage will this
company gain from the relational database
management system that will store customer
,information? - answer-Improved query response
time
What is the method of organizing attributes into
tables? - answer-Data NORMALIZATION
What should a company expect from
implementing a business intelligence system? -
answer-- Financial: Increased profitability
- Productivity: Increased throughput, decreased
workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - answer-A database
model based on mathematical principles
What are the 3 mathematical concepts of the
relational model? - answer-- Domain
- Tuple
- Relation
, Define: Domain - answer-Set of values = 'Data
Type'
Define: Tuple - answer-Finite sequence of values
pulled from a fixed domain = 'Row'
Define: Relation - answer-A named set of tuples,
all from same domain = 'Table'
A tuple position is called a: - answer-Attribute
How is cardinality depicted in a diagram for
many, one, and zero? - answer-- Many = Crow's
Foot
- One = a bar across the end of a relationship (--
||--)
- Zero = Circle
