DAD 220 - 4-1 EXAM 2025 QUESTIONS
AND ANSWERS
To be used as a primary key, which of these characteristics must an attribute have in a single
instance of the entity? Select all that apply.
Question options:
There must be a maximum of one attribute instance.
There must be many instances of the attribute.
There must be at most one entity instance that each attribute instance describes.
There must be at least one instance of the attribute.
There must be zero or more instances of the attribute. - ANS There must be a maximum of
one attribute instance.
There must be at most one entity instance that each attribute instance describes.
There must be at least one instance of the attribute.
A singular attribute is also known as a unique attribute.
Question options:
1 Copyright ©2025 FYNDLAY ALL RIGHTS RESERVED.
, True
False - ANS False
In the list below are relationship names and types of relationship maxima or minima that each
could have. Match each relationship in the list below to the type of relationship maxima or
minima.
Instructions: Choose your responses from the drop-down menus below. Responses can only be
used once.
_____ Maxima is One-Many
_____ Maxima is One-One
_____ Minima is One-Zero
_____ Minima is Zero-Zero
1. Person-Assigned-SocialSecurityNumber
2. CubicleNumber-Assigned-to-Employee
3. Birthdate-Recorded-for-a Person
4. Women-Bearing-Children - ANS 2. CubicleNumber-Assigned-to-Employee - Maxima is One-
Many
1. Person-Assigned-SocialSecurityNumber - Maxima is One-One
3. Birthdate-Recorded-for-a Person - Minima is One-Zero
4. Women-Bearing-Children - Minima is Zero-Zero
A ride-sharing app's discount system for riders is made so a ride discount only initiates if at least
two RiderIDs book a ride in the same CarID at the same time. Which of the following answers is
true of the relationship RideDiscount-is-Applicable? Select one.
Question options:
2 Copyright ©2025 FYNDLAY ALL RIGHTS RESERVED.
AND ANSWERS
To be used as a primary key, which of these characteristics must an attribute have in a single
instance of the entity? Select all that apply.
Question options:
There must be a maximum of one attribute instance.
There must be many instances of the attribute.
There must be at most one entity instance that each attribute instance describes.
There must be at least one instance of the attribute.
There must be zero or more instances of the attribute. - ANS There must be a maximum of
one attribute instance.
There must be at most one entity instance that each attribute instance describes.
There must be at least one instance of the attribute.
A singular attribute is also known as a unique attribute.
Question options:
1 Copyright ©2025 FYNDLAY ALL RIGHTS RESERVED.
, True
False - ANS False
In the list below are relationship names and types of relationship maxima or minima that each
could have. Match each relationship in the list below to the type of relationship maxima or
minima.
Instructions: Choose your responses from the drop-down menus below. Responses can only be
used once.
_____ Maxima is One-Many
_____ Maxima is One-One
_____ Minima is One-Zero
_____ Minima is Zero-Zero
1. Person-Assigned-SocialSecurityNumber
2. CubicleNumber-Assigned-to-Employee
3. Birthdate-Recorded-for-a Person
4. Women-Bearing-Children - ANS 2. CubicleNumber-Assigned-to-Employee - Maxima is One-
Many
1. Person-Assigned-SocialSecurityNumber - Maxima is One-One
3. Birthdate-Recorded-for-a Person - Minima is One-Zero
4. Women-Bearing-Children - Minima is Zero-Zero
A ride-sharing app's discount system for riders is made so a ride discount only initiates if at least
two RiderIDs book a ride in the same CarID at the same time. Which of the following answers is
true of the relationship RideDiscount-is-Applicable? Select one.
Question options:
2 Copyright ©2025 FYNDLAY ALL RIGHTS RESERVED.
