Fall 2017

Lab08
SQL

Due: Monday December 12, 2016 11:59 PM

Lab08 - SQL

Requirements

All tables and their associated fields are created according to design50 pts
All tables include test data10 pts
SQL query questions are answered or explained40 pts
Total100 pts

Resources

Objective

To implement your database

Instructions

For this lab you will need to implement your database in a database management system called MySQL.

Begin by downloading and installing MySQL on your computer along with the GUI tools which will be needed to access and manipulate your database. There are many resources available on the internet that describe this process.

Once MySQL is setup and it working, execute the SQL statements that are needed to create the tables for your database and to place sample data into those tables.

When your database is created and data has been included in your tables, backup your database and submit the backup file as the first part of your solution for this lab.

For the second part of your lab solution, write SQL select statements needed to answer the following questions. If your design does not allow for the question to be answered, describe why and what changes need to be made to the database's design to allow the question to be answered. Include your answers in a text file and include that file as the second part of your solution for this lab.

  1. What are the first and last names of all of the student's that are in the contest this year?
  2. Choose a student from your data. What are all of the titles of their individual entries?
  3. Choose an art portfolio from your data. What are the names of the uploaded images for that portfolio?
  4. What are the total round 3 votes for all individual entries?