Intermediate Python
Assignment 3
Due Date: December 1st by 11:30PM
The objective of every assignment is to make sure you practice what we learned throughout the
modules to cement your learning. Every assignment is based on a real-life scenario to prepare
you for a job in the industry. Assignment 3 covers topics that we will cover in module 5.
A Computer Scientist would like a program that stores the total count of Python repositories,
Java repositories and Swift repositories with a timestamp into a database. You can create the
database utilizing PHPMyAdmin locally.
To get started you must first create a database and a table in PHPMyAdmin the table with data
inserted should look like this:
TimeStamp
(string or timestamp)
PythonRepos
(integer)
SwiftRepos
(integer)
JavaRepos
(integer)
XXXXXXXXXX XXXXXXXXXX
You must make three API calls and store them into the database with the same timestamp. Every
time you run the program; a new row will be added to your database table!
Because the database is local, you must screenshot your database table within PHPMyAdmin in
order to show me that the program works.
Deliverables:
• Commented code (.py file)
• Screenshot of the database table (.png or .jpeg)
• Screenshot of the git log showing that you utilized git throughout the development
process.
• All the above-mentioned files must be zipped into one zip file named
studentNumber_StudentName_Assignment3 and submitted via D2L by the deadline
mentioned above.