Assignment DB

Question 1

Single

-

row/Group Functions: Give an example of when you would use a single

-

row function and a group

function. What are the main differences between single

-

row and group functions?

1.

In no more than 200 words, explain the di

fferences between a single row function and a group function.

2.

Post to the forum and respond to at least two other colleagues’ posts.

3.

This must be completed by Wednesday of Week 4, respond to colleagues’ by Sunday Week 4.

Group By/Having Clauses: What is an appropriate use of the "GROUP BY" clause? What is an appropriate use

o

f the "HAVING" clause?

1.

In no more than 200 words, explain the when it is appropriate to use a Group By and Having Clause.

2.

Post to the forum and respond to at least two other colleagues’ posts.

3.

This must be completed by Wednesday of Week 4, respon

d to colleagues’ by Sunday Week 4.

Storing Manipulated Data: Would it be e

asier to store the necessary manipulated data in the database table

rather than using functions? Why or why not? Provide examples in your answer.

1.

In no more than 200 words, explain the pros and cons of storing manipulated data.

2.

Post to the forum a

nd respond to at least two other colleagues’ posts.

3.

This must be completed by Wednesday of Week 4, respond to colleagues’ by Sunday Week 4.

Question 1

Single-row/Group Functions: Give an example of when you would use a single-row function and a group

function. What are the main differences between single-row and group functions?

1. In no more than 200 words, explain the differences between a single row function and a group function.

2. Post to the forum and respond to at least two other colleagues’ posts.

3. This must be completed by Wednesday of Week 4, respond to colleagues’ by Sunday Week 4.

Group By/Having Clauses: What is an appropriate use of the "GROUP BY" clause? What is an appropriate use

of the "HAVING" clause?

1. In no more than 200 words, explain the when it is appropriate to use a Group By and Having Clause.

2. Post to the forum and respond to at least two other colleagues’ posts.

3. This must be completed by Wednesday of Week 4, respond to colleagues’ by Sunday Week 4.

Storing Manipulated Data: Would it be easier to store the necessary manipulated data in the database table

rather than using functions? Why or why not? Provide examples in your answer.

1. In no more than 200 words, explain the pros and cons of storing manipulated data.

2. Post to the forum and respond to at least two other colleagues’ posts.

3. This must be completed by Wednesday of Week 4, respond to colleagues’ by Sunday Week 4.