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 studentdbsqlite.
A table named students should be created with the following columns:
id INTEGER PRIMARY KEY AUTOINCREMENT
name TEXT
age INTEGER
major TEXT
gpa REAL
Implement a method to insert new student records into the database.
Implement a method to increase the GPA of all students older than a specified age.
Implement a method to display all student records.
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.
The application must use a simple consolebased 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
