Sharpen your pencil

Here is the schema for the Dataville Dispatch’s database. Circle the tables that you’d need to pull together into a single table in order to show which author has the articles with the most web hits and web comments.

Then draw the table below that would show the fields you’d need in order create those scatterplots.

Sharpen your pencil Solution

What tables do you need to join together so that you can evaluate each author’s popularity, by counting the web hits and comments that author receives?