i need help with sql code highlighted $.$ i keep getting this Error Code: $1452.$ Cannot add or update a child row: a foreign key constraint fails $(`$healthcare$`.`$billing$`,$ CONSTRAINT $`$billing$\_$ibfk$\_1`$ FOREIGN KEY $(`$Record$\_$ID$`)$ REFERENCES $`$medicalrecord$`(`$Record$\_$ID$`))$ dont know what i did wrong $...$ Here is my full sql code 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 $($

RecordID INT PRIMARY KEY,

PatientID INT,

DoctorID INT,

Date DATETIME NOT NULL,

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$),$

FOREIGN KEY $($DoctorID$)$ REFERENCES Doctor$($DoctorID$)$

$)$;

CREATE TABLE MedicalRecord $($

RecordID INT PRIMARY KEY,

PatientID INT,

Diagnosis VARCHAR$(255)$ NOT NULL,

Treatment VARCHAR$(255)$ NOT NULL,

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$)$

$)$;

CREATE TABLE Billing $($

CREATE TABLE Billing $($

BillingID INT PRIMARY KEY,

RecordID INT,

PatientID INT,

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

PaymentStatus VARCHAR$(255)$ NOT NULL,

FOREIGN KEY $($RecordID$)$ REFERENCES MedicalRecord$($RecordID$),$

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$)$

$)$;

ALTER TABLE MedicalReco rd

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

FOREIGN KEY $($RecordID$)$

REFERENCES Appointment$($RecordID$)$;

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 Patient $($PatientID$,$ PatientName, PatientAddress, 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 $($DoctorID$,$ 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 $($RecordID$,$ PatientID, DoctorID, 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 $($RecordID$,$ PatientID, 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$,$ RecordID, PatientID, 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'$)$;