Print
Rubric
Lesson
Example

Projects.ADV.DB.EC.01

Database Extra Credit Project:
Team Stats

Problem

Sports teams use databases all the time to store information about their players and search that information. Your task is to create a database for a sports team that lets the user sort and search the information. The team can be a professional team or a team you are involved in.

Instructions

  1. Create a database in MySQL with at least 5 fields of information.
  2. Create a web page to display your data in an HTML table.
  3. Create a link that will allow you to sort each column of information.
  4. Create at least 3 queries. You can receive extra credit for each query you create up to 10.
  5. Turn in your site online by following the steps in Database Lesson 2. The host directory when you set up your remote site will be "ec." Check with Mr. Miller if you don't know how to find your site online.