SNHU DAD 220 (ACTUAL 2025/2026) QUESTION AND
VERIFIED ANSWER
In jeopardy-style online quiz you are playing the "answers" to
the bonus question: 1. All non-key columns must depend on
the whole primary key 2. A table with a simple primary key is
automatically in this form 3 this form does not eliminate all
redundancies
Second normal form
You are analyzing data for a new sports stats website and
have access to their databases related to the major league
baseball games. A coworker has created the table attendance,
which estimates the average attendance at home games next
season for franchises in each division of the national league
and the american league.
Select league, division, max(average) from attendance group
by league, division order by league, division
1. Select min(year) from opioid addiction
2. Select max(percentage) from opioid addiction
3.select count(*) from opioid addiction where percentage
<0.04
4. Select avg(percentage) from opioid addiction
1.2016
VERIFIED ANSWER
In jeopardy-style online quiz you are playing the "answers" to
the bonus question: 1. All non-key columns must depend on
the whole primary key 2. A table with a simple primary key is
automatically in this form 3 this form does not eliminate all
redundancies
Second normal form
You are analyzing data for a new sports stats website and
have access to their databases related to the major league
baseball games. A coworker has created the table attendance,
which estimates the average attendance at home games next
season for franchises in each division of the national league
and the american league.
Select league, division, max(average) from attendance group
by league, division order by league, division
1. Select min(year) from opioid addiction
2. Select max(percentage) from opioid addiction
3.select count(*) from opioid addiction where percentage
<0.04
4. Select avg(percentage) from opioid addiction
1.2016
