Departments table

$\backslash$table$[[$Column Name,Type$],[$DeptID$,$INTEGER PRIMARY KEY$],[$Name$,$TEXT$]]$

Students table

$\backslash$table$[[$Column Name,Type$],[$Student ID$,$INTEGER PRIMARY KEY$],[$Name$,$TEXT$],[$MajorID$,\backslash$table$[[$INTEGER $($Foreign key that references the Major ID column in$],[$the Majors table$)]]],[$DeptID$,$INTEGER $($Foreign key that references the DeptID column in$],[,$the Departments table$)]]$

Figure $14-12$ shows an entity relationship diagram for the database.

Figure $14-12$ Entity relationship diagram for the student$\_$info, db database

Write a program that creates the database and the tables.

Write a program that performs CRUD operations on the Majors table. Specifically, the program should allow the user to do the following: $q,$ Add a new major

$q,$ Search for an existing major

$q,$ Update an existing major

$q,$ Delete an existing major

$q,$ Show a list of all majors

Write a program that performs CRUD operations on the Departments table. Specifically, the program should allow the user to do the following: $q,$ Add a new department

$q,$ Search for an existing department

$q,$ Update an existing department

$q,$ Delete an existing department

$q,$ Show a list of all departments