D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
D426 WGU SQL & Database Concepts Quiz - ER Diagrams,
Normalization & Indexing Recent Update.
Multiple Choice Quiz
Review of D426 v3: ER Diagrams, Indexing, Normalization
SQL & Database Concepts Quiz
Entity-Relationship Modeling (1–10)
1. What is the modality in an ER diagram?
A) The total number of relationships
B) The type of relationship
C) The minimum number of entity instances in a relationship
D) The data type of an attribute
2. In crow’s foot notation, what symbol represents a maximum of
many?
A) Short bar
B) Circle
C) Arrow
D) Crow’s foot (three lines)
3. In an ER diagram, what symbol represents a minimum of zero?
A) Crow’s foot
B) Diamond
C) Circle
D) Double bar
4. What type of entity must have a primary key?
A) Subtype entity
B) Weak entity
C) Strong entity
D) Associative entity
5. A weak entity depends on what kind of relationship?
A) Recursive relationship
B) Optional relationship
C) Identifying relationship
D) Many-to-many relationship
6. True or False: An identifying entity in a weak entity relationship is
always singular and required.
A) True
B) False
D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
, D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
C) Depends on the entity
D) Only in crow's foot diagrams
7. What is the relationship between a supertype and subtype in an ER
model?
A) They represent different databases
B) Subtypes are unrelated to supertypes
C) Subtypes are subsets of supertypes
D) Supertypes are optional for subtypes
8. In an ER diagram, where are modality and cardinality symbols
placed relative to the entity?
A) Both close to the entity
B) Modality near, cardinality far
C) Modality farther, cardinality closer
D) Both far from the entity
9. A manager being a subtype of an employee is an example of what
modeling concept?
A) Foreign key relationship
B) Attribute inheritance
C) Subtype-supertype relationship
D) Cardinality control
10. What does the diamond represent in an ER diagram involving
weak entities?
A) Optional relationship
B) Recursive loop
C) Identifying relationship
D) Supertype connector
Functional Dependence & Normalization (11–22)
11. If Grade depends on (StudentID, CourseCode), which
column(s) form the determinant?
A) Grade
B) StudentID
C) CourseCode
D) (StudentID, CourseCode)
12. Define functional dependence using the notation A → B.
A) Each A maps to one B
D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
Update.
D426 WGU SQL & Database Concepts Quiz - ER Diagrams,
Normalization & Indexing Recent Update.
Multiple Choice Quiz
Review of D426 v3: ER Diagrams, Indexing, Normalization
SQL & Database Concepts Quiz
Entity-Relationship Modeling (1–10)
1. What is the modality in an ER diagram?
A) The total number of relationships
B) The type of relationship
C) The minimum number of entity instances in a relationship
D) The data type of an attribute
2. In crow’s foot notation, what symbol represents a maximum of
many?
A) Short bar
B) Circle
C) Arrow
D) Crow’s foot (three lines)
3. In an ER diagram, what symbol represents a minimum of zero?
A) Crow’s foot
B) Diamond
C) Circle
D) Double bar
4. What type of entity must have a primary key?
A) Subtype entity
B) Weak entity
C) Strong entity
D) Associative entity
5. A weak entity depends on what kind of relationship?
A) Recursive relationship
B) Optional relationship
C) Identifying relationship
D) Many-to-many relationship
6. True or False: An identifying entity in a weak entity relationship is
always singular and required.
A) True
B) False
D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
, D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
C) Depends on the entity
D) Only in crow's foot diagrams
7. What is the relationship between a supertype and subtype in an ER
model?
A) They represent different databases
B) Subtypes are unrelated to supertypes
C) Subtypes are subsets of supertypes
D) Supertypes are optional for subtypes
8. In an ER diagram, where are modality and cardinality symbols
placed relative to the entity?
A) Both close to the entity
B) Modality near, cardinality far
C) Modality farther, cardinality closer
D) Both far from the entity
9. A manager being a subtype of an employee is an example of what
modeling concept?
A) Foreign key relationship
B) Attribute inheritance
C) Subtype-supertype relationship
D) Cardinality control
10. What does the diamond represent in an ER diagram involving
weak entities?
A) Optional relationship
B) Recursive loop
C) Identifying relationship
D) Supertype connector
Functional Dependence & Normalization (11–22)
11. If Grade depends on (StudentID, CourseCode), which
column(s) form the determinant?
A) Grade
B) StudentID
C) CourseCode
D) (StudentID, CourseCode)
12. Define functional dependence using the notation A → B.
A) Each A maps to one B
D426 WGU SQL & Database Concepts Quiz - ER Diagrams, Normalization & Indexing Recent
Update.
