Website and Database Development (7185) Project 4 – Games and Coasters
This project is for students to practice using SQL SELECT statements. The project uses a coasters table to practice extracting data about roller coasters, and a games table to extract different information about board games. Students practice using the WHERE, ORDER BY, GROUP BY, and LIKE clauses, and the COUNT, MIN, MAX, and DISTINCT aggregate functions in SQL. The goal is to have students practice asking questions of the data.
Note: This project is designed to be purely SQL, no web pages or HTML content
Note: This project also makes use of a sqlite database (but the SELECT statements should be useable in any relational database)
Materials
-
Project Overview and Details - Project 4: Coasters and Games
https://docs.google.com/document/d/1Qj0PeiExeVcb-3ci1_jIg9X61BD192VWqZsZEA-BzAA/edit?usp=sharing -
Project 4 Student Handout
https://docs.google.com/document/d/18mP9gkPMY8mJ8DQRlFHgwAtYXHuqa2bQ/edit?usp=drive_link&ouid=113850185765170542758&rtpof=true&sd=true -
Google Drive Folder of Resources for Project 4
https://drive.google.com/drive/folders/1k5KCIebA2TmBiQ4Fqp8nOAcWZg52-CRD?usp=drive_link