STA-230 Midterm 3: Managing a SQL Database
In this midterm, the goal is to create a useful (and usable) SQL
database, and show that you know how to work with it.
Requirements:
- Database:
- Must include at least 3 tables
- Must be stored more efficiently (number of total cells in the data
tables) 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 to
delete rows or columns from a table, even if it’s not necessary
- You may look for datasets anywhere, cannot use ones we’ve seen in
class
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 how and why you may 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
- Due Date