Develop a Python interface for your SQL database. Include a menu to search, update, and view reports.

CREATE SCHEMA healthcare;

use healthcare;

CREATE TABLE Patient $($

Patient$\_$ID INT PRIMARY KEY,

Patient$\_$Name VARCHAR$(255)$ NOT NULL,

Patient$\_$Address VARCHAR$(255)$ NOT NULL,

Contact VARCHAR$(255)$ NOT NULL,

Insurance VARCHAR$(255)$ NOT NULL

$)$;

CREATE TABLE Doctor $($

Doctor$\_$ID INT PRIMARY KEY,

Name VARCHAR$(255)$ NOT NULL,

Specialization VARCHAR$(255)$ NOT NULL,

Contact VARCHAR$(255)$ NOT NULL

$)$;

CREATE TABLE Appointment $($

Record$\_$ID INT PRIMARY KEY,

Patient$\_$ID INT,

Doctor$\_$ID INT,

Date DATETIME NOT NULL,

FOREIGN KEY $($Patient$\_$ID$)$ REFERENCES Patient$($Patient$\_$ID$),$

FOREIGN KEY $($Doctor$\_$ID$)$ REFERENCES Doctor$($Doctor$\_$ID$)$

$)$;

CREATE TABLE MedicalRecord $($

Record$\_$ID INT PRIMARY KEY,

Patient$\_$ID INT,

Diagnosis VARCHAR$(255)$ NOT NULL,

Treatment VARCHAR$(255)$ NOT NULL,

FOREIGN KEY $($Patient$\_$ID$)$ REFERENCES Patient$($Patient$\_$ID$)$

$)$;

CREATE TABLE Billing $($

Billing$\_$ID INT PRIMARY KEY,

Record$\_$ID INT,

Patient$\_$ID INT,

TotalAmount DECIMAL$(10,2)$ NOT NULL,

PaymentStatus VARCHAR$(255)$ NOT NULL,

FOREIGN KEY $($Record$\_$ID$)$ REFERENCES MedicalRecord$($Record$\_$ID$),$

FOREIGN KEY $($Patient$\_$ID$)$ REFERENCES Patient$($Patient$\_$ID$)$

$)$;

ALTER TABLE MedicalRecord

ADD CONSTRAINT FK$\_$MedicalRecord$\_$Appointment

FOREIGN KEY $($Record$\_$ID$)$

REFERENCES Appointment$($Record$\_$ID$)$;

INSERT INTO Patient $($Patient$\_$ID$,$ Patient$\_$Name, Patient$\_$Address, Contact, Insurance$)$

VALUES

$(1,$ 'John Doe', $\text{'}123$ Main St$,$ Anytown, CA $91234\text{'},\text{'}555-123-4567\text{'},$ 'Aetna'$),$

$(2,$ 'Jane Smith', $\text{'}456$ Elm St$,$ Anytown, CA $91234\text{'},\text{'}555-987-6543\text{'},$ 'Blue Cross Blue

Shield'$),$

$(3,$ 'Mike Jones', $\text{'}789$ Oak St$,$ Anytown, CA $91234\text{'},\text{'}555-234-5678\text{'},$ 'Cigna'$),$

$(4,$ 'Alice Lee', $\text{'}1011$ Cedar St$,$ Anytown, CA $91234\text{'},\text{'}555-345-6789\text{'},$

'UnitedHealthcare'$),$

$(5,$ 'Bob Brown', $\text{'}1213$ Walnut St$,$ Anytown, CA $91234\text{'},\text{'}555-456-7890\text{'},$ 'Humana'$)$;

INSERT INTO Doctor $($Doctor$\_$ID$,$ Name, Specialization, Contact$)$

VALUES

$(1,\text{'}$Dr$.$ Smith', 'General Medicine', $\text{'}555-555-1212\text{'}),$

$(2,\text{'}$Dr$.$ Jones', 'Cardiology', $\text{'}555-555-2323\text{'}),$

$(3,\text{'}$Dr$.$ Lee', 'Dermatology', $\text{'}555-555-3434\text{'}),$

$(4,\text{'}$Dr$.$ Brown', 'Neurology', $\text{'}555-555-4545\text{'}),$

$(5,\text{'}$Dr$.$ Williams', 'Orthopedics', $\text{'}555-555-5656\text{'})$;

INSERT INTO Appointment $($Record$\_$ID$,$ Patient$\_$ID$,$ Doctor$\_$ID$,$ Date$)$

VALUES

$(1,1,1,\text{'}2023-10-26\text{'}),$

$(2,2,3,\text{'}2023-11-02\text{'}),$

$(3,3,2,\text{'}2023-11-09\text{'}),$

$(4,4,4,\text{'}2023-11-16\text{'}),$

$(5,5,5,\text{'}2023-11-23\text{'}),$

$(6,1,2,\text{'}2023-12-07\text{'}),$

$(7,3,1,\text{'}2023-12-14\text{'}),$

$(8,5,4,\text{'}2023-12-21\text{'})$;

INSERT INTO MedicalRecord $($Record$\_$ID$,$ Patient$\_$ID$,$ Diagnosis, Treatment$)$

VALUES

$(1,1,$ 'Hypertension', 'Medications, lifestyle changes'$),$

$(2,2,$ 'Eczema', 'Topical steroids, emollients'$),$

$(3,3,$ 'Anxiety', 'Therapy, medication'$),$

$(4,4,$ 'Migraine headaches', 'Pain medication, preventive medication'$),$

$(5,5,$ 'Knee pain', 'Physical therapy, pain medication'$)$;

INSERT INTO Billing $($BillingID$,$ Record$\_$ID$,$ Patient$\_$ID$,$ TotalAmount, PaymentStatus$)$

VALUES

$(1,1,1,200\mathrm{.}00,$ 'Paid'$),$

$(2,2,2,150\mathrm{.}00,$ 'Paid'$),$

$(3,3,3,100\mathrm{.}00,$ 'Paid'$),$

$(4,4,4,250\mathrm{.}00,$ 'Paid'$),$

$(5,5,5,300\mathrm{.}00,$ 'Paid'$),$

$(6,6,1,175\mathrm{.}00,$ 'Paid'$),$

$(7,7,3,125\mathrm{.}00,$ 'Paid'$),$

$(8,8,5,225\mathrm{.}00,$ 'Paid'$)$;

SELECT $*$ FROM Patient;

SELECT $*$ FROM Patient WHERE Patient$\_$Address LIKE $\text{'}\%$Anytown, CA$\%\text{'}$;

SELECT $*$ FROM Patient WHERE Insurance $=$ 'Blue Cross Blue Shield';

UPDATE Doctor SET Name $=\text{'}$Dr$.$ Johnson' WHERE Doctor$\_$ID $=2$;

UPDATE Doctor SET Contact $=\text{'}555-555-2323\text{'}$ WHERE Doctor$\_$ID $=2$;

UPDATE Doctor SET Specialization $=$ 'Cardiology' WHERE Doctor$\_$ID $=2$;

INSERT INTO Appointment $($Record$\_$ID$,$ Patient$\_$ID$,$ Doctor$\_$ID$,$ Date$)$

VALUES

$(9,4,2,\text{'}2024-02-17\text{'})$;

SELECT Patient.Patient$\_$Name, SUM$($Billing$.$TotalAmount$)$ AS TotalBilling

FROM Patient

JOIN MedicalRecord ON Patient.Patient$\_$ID $=$ MedicalRecord.Patient$\_$ID

JOIN Billing ON MedicalRecord.Record$\_$ID $=$ Billing.Record$\_$ID

WHERE Patient.Patient$\_$ID $=2$;

SHOW INDEX FROM Doctor;

SHOW INDEX FROM Appointment;

SHOW INDEX FROM Billing;