WGU C175 Final+1+2 Exam 2026 Actual Complete Real
Verified Exam Questions with verified Answers
(Correct Answers) Already Graded A+|| Newest Exam
!!!
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
Difference between Unary and Binary: - Answer-- Unary:
One entity involved in relationship (one box, one line)
- Binary: Two entities (two boxes combined by one line)
If an entity is mandatory, how is it depicted in an ER
diagram? - Answer-With a single vertical line through the
relationship line
What does an 'M' mean when shown on an entity in an ER
diagram? - Answer-Mandatory
,2|Page
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
Define: Singular Attribute - Answer-Each entity instance
has at most ONE attribute instance
Define: Plural Attribute - Answer-Each entity instance can
have MANY attribute instances
Define: Unique Attribute - Answer-Each attribute instance
describes only ONE entity instance
How do entity and attribute maxima appear in an ER
diagram? - Answer-As M or 1 following the attribute name
What combination of entity and attribute maxima/minima is
considered unique? - Answer-If the first number is a 1
, 3|Page
What combination of entity and attribute maxima/minima is
considered singular? - Answer-If the second number is 1
What combination of entity and attribute maxima/minima is
considered plural? - Answer-If the second number is M
Define: Select Operation - Answer-Selects table rows
based in logical expression (σ)
Define: Project Operation - Answer-Selects Table Columns
(II)
Define: Join Operation - Answer-Joins two tables (⋈)
Define: Union operation - Answer-Combines ALL rows of
two compatible tables into a single table (U)
Define: Intersect Operation (and how it appears on an ER
diagram) - Answer-Operates on two compatible tables and
returns only rows that appear in BOTh tables (∩)