Google Code-in

Based on this previous task:

https://codein.withgoogle.com/dashboard/tasks/6456325823791104/

(please do that first if you haven't), now we want to use that data to build a database based on events.

When an article is submitted, it needs to be added to a database table (you can use anything you want for this database but we suggest sqlite3, since it's self contained and easy to use). When someone votes (up or down) an article that vote needs to be added to a vote table. Same with comments and so on.

If someone votes an article but there's no record for such article in the database you just ignore that vote, since that's a likely scenario: People will vote for old stuff that you just don't have. That's not an error.

By doing this task you will learn a lot about databases: Tables, indexes, normalization, constraints and more.