CSC 242

Winter 2024

Craig Miller

• Home
• Basic Information
• Grades and Policies
• Schedule

Weekly Notes

• Week 1
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 7
• Week 8
• Week 9
• Week 10

Labs

• Lab 1
• Lab 2
• Lab 3
• Lab 5
• Lab 6
• Lab 7
• Lab 8
• Lab 9

Assignments

• Assignment 1
• Assignment 2
• Assignment 3
• Assignment 4
• Assignment 5
• Assignment 6
• Assignment 7
• Assignment 8

Assignment 8
Database access
Submit before 11:30 Saturday March 16Monday March 18

Overview

For this assignment, you'll add a method to the Movies database class. Then, you'll create an interactive console that allows the user to issue commands that perform the basic operations of retrieving, updating, and deleting records.

Instructions and code writing

1. Review the Movies database class from lab 9.
2. Similar to the title_search method, define a genre_search method for the Movies class.
3. Using the command-based Python example from class, create an interactive console that allows the user to interact with the database through the Movies class. When the console program starts, it should create the database connection by constructing a Movies object. At minimum, your console should support the following operations:
   1. Load the movies from movies.txt --- note that this will erase any prior work.
   2. Show movies by title or genre
   3. Mark a movie as seen (the command may refer to the movie by its id)
   4. List movies depending on whether they have been seen (or not, your choice)
   5. Delete a movie (may reference by id)
4. (optional) Provide an alternate way to refer to a movie than by its id for the operations that refer to a specific movie.

Deliverable

Create a text, word or pdf file that contains the following:

1. A statement that summarizes your completion of the assignment. The statement should include any help you received or whether you discussed your assignment with others. Keep in mind that you may not copy code from others or allow others to copy your code.
2. Demonstration that shows that your submission meets the requirements for the assignment.
3. A summary of the files included in the zip folder

Put your doc file and your py files in a folder, zip it, and submit it on D2L. Check that your submitted zip file is complete.

Grading

The assignment is worth 5 points. Full credit will be awarded to complete, accurate and well presented submissions. Points will be deducted for the following:

• Missing requirements
• Inaccuracies (possibly excepting minor ones)
• Poorly written explanations