02 Feb Using SQL aggregate functions

Unit 5 Assignment 1

SQL Functions

Part 1

As part of developing a Web application to track volunteer activities, create a table for the volunteer database to store user names for the volunteers to log in to the system. Use an INSERT INTO statement with a subquery containing a SQL string function to create user names for the volunteers based on their legal names and insert them into the new table. Submit the SQL to create the new table, the SELECT INTO query, and the result of a SELECT query to show the contents as part of this assignment.

Part 2

Using SQL aggregate functions such as COUNT(), MIN(), and MAX(), write three queries to report on various aspects of the organization’s volunteers. Submit the text of the queries and the results as part of this assignment.

Part 3

Write a final report on the volunteer database. Identify the key components of the database and discuss how the database life cycle has progressed through the phases of investigation, system design, development, execution, and maintenance. Focus on the correct use of terminology and writing clearly.

Resources

SQL Functions Scoring Guide.