Homework 8: 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 file (Word/Google Doc/PowerPoint slide, etc.) and in it describe a relational data model (one or more tables and their columns) for the data we've been using for Quizzer. Then provide the SQLite commands to create the table(s). Finally, provide the SQLite commands to populate the tables with the data that we stored in questions.php in HW7/class on 2022-10-04.

You should test this out using SQLite on your own laptop, or SSH into digdug and try it out there—you don't need to provide evidence that you tried it, but you should do it for the experience and to see if you run into any trouble.

Upload a PDF of your document with your model and SQLite commands.