Homework 9: Databases

Watch these videos:

• Basic relational data modeling (YouTube Links to an external site.)
• SQLite3 (YouTube Links to an external site.)
• Creating and deleting files and directories on the command line (YouTube Links to an external site.)

Create a document in which you describe a relational data model (one or more tables and their columns) for the data we've been using for Quizzer—you can depict the database tables using word processor tables (like in Word/Google Docs/PowerPoint) or using a diagram designer (like draw.io Links to an external site.) and importing the generated figure. Then provide the SQLite commands to:

• create the table(s)
• populate the tables with at least five question-answer pairs

You should test this out using SQLite on your own laptop, or SSH into digdug and try it out there. If you're on macOS, you probably have sqlite3 available (try typing it into the terminal). In the next homework, I'll show you how to install it on Windows. For now, digdug is fine if you don't have it installed. Include a screenshot of your sqlite3 interactions in your document.

Upload a PDF of your document (to summarize, it should include the tables, the commands to create and populate the tables, and a screen shot of using sqlite3 on the command line).