STA-230 Midterm 3: Managing a SQL Database

In this midterm, the goal is to create a useful (and usable) SQL database.

Requirements:

• Database:
  • Must include at least 3 tables
  • Must be stored more efficiently (number of cells in an excel worksheet) than they would as a single table
  • Must include a function that when given a new row of information, adds it to the proper table(s)
• Knowledge Demonstration:
  • Creating Tables
  • Filling Tables
  • Deleting Rows
  • Deleting Tables

Notes:

• For the Deletion, you need to demonstrate that you know how, even if it’s not necessary
• You may look for datasets anywhere

Submission:

• Code that when ran will generate your database
  • Include any csvs you need to do so if you download data from somewhere
• 1 page report that includes the following:
  • How you know that the information is stored more efficiently
  • Why this data is of interest
  • Evidence that you understand why you would want to add rows in the future

Rules

• Group Size (2)-3
  • Ideally 3. If the class is not evenly divisible by 3, I will allow 1-2 groups of 2
  • Send me an email with your proposed group by Tuesday April 8th at 5pm
  • If you don’t send me an email, I will assign your group
    • Please don’t make me do this, I believe there is some benefit to working in a chosen group
• Due Date
  • Friday April 25th at 10pm