Question: Create a program that manages a student database using an SQLite database called student _ db . sqlite. 1 . A table named students should

Create a program that manages a student database using an SQLite database called student_db.sqlite.
1. A table named students should be created with the following columns:
- id (INTEGER PRIMARY KEY AUTOINCREMENT)
- name (TEXT)
- age (INTEGER)
- major (TEXT)
- gpa (REAL)
2. Implement a method to insert new student records into the database.
3. Implement a method to increase the GPA of all students older than a specified age.
4. Implement a method to display all student records.
5. Allow the user to filter students based on specific criteria, such as students whose name contains a certain substring, students older than a certain age, or students with a GPA greater than a specified value.
6.The application must use a simple console-based interface where users input commands to test the program.
DO NOT USE TKINTER!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!