To create databases and manipulate data within these databases, we use open source software called Sqlite. In this activity, you are requested to create a database that has the following tables:

Student_table

student_id	student_firstname	student_lastname	major	GPA	Email
0887	John	Steve	IT	3.46	jsteve@auaf.edu.af
0888	Sarah	Paul	Business	3.95	spaul@auaf.edu.af

Course_table

course_id	course_name	total_credit	Term	student_id
ITC215	Programming 1	3	Spring 2021	0887
ITC345	Python	4	Fall 2021	0888

Tasks:

1. Once the database and tables are created, you need to insert data to the database. Therefore, use your Python knowledge to allow user to enter data into the tables.
2. Allow user to search for a specific course/student using the ID.
3. Show a list of students or a list of available courses.
4. Allow the user to update specific content within a table.
5. Delete a record from a database
6. Show a list of students who are enrolled in a particular course.
7. Show a list of courses that are offered in a specific term