CIT 111: Introduction to Databases

W05 Team Activity - SQL Select Practice

• Purpose: Participate in a 60-minute online team meeting to practice writing queries.
• Task: Devise questions to answer about data from our class database, then write queries to answer the question.

Overview

This week is all about practice. You may have heard of the 10,000 hour rule. The rule basically states that it takes 10,000 hours to master a complex set of skills. Software Development is just such a skill. This week you will get one more hour of practice querying databases.

As a group you will used data from the class databases provided to ask questions of your design about the data. You are not limited to one database, you may use more than one if you want.

Instructions

• Start with a prayer to invite the spirit to help you with your studies.
• Create a MS Word document in your Group's Channel in MS Teams named Team Activity 05.
• Each person will lead the discussion that asks a question about the data, then lead the creation of a SQL statement that provides the answer. Select a team member to begin. This team member will:
  1. Write a question to answer. The questions should include questions that will require,
     • WHERE conditions
     • Table Joins
     • Aggregates
     NOTE: You do not need to use all clauses in each question. Just make sure that all the clauses get covered during the session.
  2. Using MySQL Workbench, write a query to answer the selected question. This team members should help and discuss but the question leader types the query.
  3. When you are confident you have the correct answer. Record the following information in the Word document.
     1. The question being answered
     2. Team member name that lead the discussion for this question
     3. SQL query used to answer the questions
     4. Query results, either as a screen shot or table
  4. Select another team member to lead the discussion and repeat until you have spent 60 minutes.

Submission

• Submit the Word document you created in Teams to Canvas
• Complete the W05 Team Activity: Participation Report in Canvas

Useful Links:

• Next Activity: Joining and Summarizing Data
• Previous Activity: Joining Tables and Aggregating Data
• Go to: Week Index • Course Home • Canvas