SNHU DAD 220 CERTIFICATION SCRIPT 2026 QUESTIONS
WITH SOLUTIONS GRADED A+
● 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..
Answer: 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: True False.
Answer: 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. Answer: 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:
The relationship maximum is One-Two. The relationship minimum is One-Two. The
relationship minimum is Many-One. The relationship minimum is Two-One.. Answer: The
relationship minimum is One-Two.
● Your nephew has been asked to work on a database for NBA teams. The following are the
requirements he has been given: - All teams play in the Eastern Conference or the Western
Conference. - Teams in each conference are named for cities or states. - Some teams have
moved from one conference to another. He asks for help in defining entities and attributes.
WITH SOLUTIONS GRADED A+
● 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..
Answer: 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: True False.
Answer: 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. Answer: 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:
The relationship maximum is One-Two. The relationship minimum is One-Two. The
relationship minimum is Many-One. The relationship minimum is Two-One.. Answer: The
relationship minimum is One-Two.
● Your nephew has been asked to work on a database for NBA teams. The following are the
requirements he has been given: - All teams play in the Eastern Conference or the Western
Conference. - Teams in each conference are named for cities or states. - Some teams have
moved from one conference to another. He asks for help in defining entities and attributes.
