Assignment 2: ETL due 11:30am Thurs Sep 24

This assignment is "ready" and has been released.

Assignment Mechanics

In terms of the mechanics of assignment submission, there's actually nothing to do!

As part of assignment 1, you should have already created a private GitHub repo cs431-2026f-assignments-USERID and shared it with the course service account teachtool. We'll just pull your assignment repo at the deadline.

The Actual Assignment

The notebook that contains the actual assignment is here. This assignment focuses on ETL and data cleaning. The notebook is self-contained.

This assignment relies on the same software environment as assignment 1. Before you start this assignment, make sure you've already installed and properly configured your environment: instructions are provided here. You'll be ready to start the assignment once you are able to launch JupyterLab and view the assignment notebook in a browser.

Assignment Submission Details

Here's what you'll turn in: In your assignment repo, you should have a sub-directory called assignment2/. That directory should contain a single file assignment2.ipynb: a copy of the assignment notebook, but with code/answers/etc. filled in.

Grading Scheme

• Section 1, Understanding the Database: 8 points
• Section 2.1, Primary Keys: 8 points
• Section 2.2, The Reviews Table: 12 points
• Section 2.3, The Applications Table: 4 points
• Section 3, Skipping Ahead to the "Gold" Tables: 4 points
• Section 3.1, Issues with Release Dates: 3 points
• Section 3.2, Populating Review Counts: 7 points
• Section 3.3, Genre Normalization: 11 points
• Following instructions: 3 points

What does "following instructions" mean? These are "free points" if you follow the instructions provided in this assignment. These points are to handle the scenario where all your answers are correct, but you did not follow the instructions and that caused us to go out of our way to fix your submission so that it conforms to the instructions. (For example, you removed the ids that we used for tracking, which would make it much more difficult to grade.) In these and other related cases, we will dock points from this category.

Total: 60 points