check whether the tables are correct?

   

CREATE TABLE Patient ( Patient ID NUMERIC (5) NOT NULL, Patient Name VARCHAR (50) NOT NULL, Patient DOB DATETIME, Patient Address VARCHAR (25), CONSTRAINT Patient_PK PRIMARY KEY (Patient_ID) ); CREATE TABLE Provider ( Provider_ID Provider_Name Provider_Speciality ); ); Provider Qualification Provider Contact VARCHAR (50), PRIMARY KEY (Provider_ID), CREATE TABLE Appointment ( Appointment ID Patient ID Provider ID NUMERIC (5) NOT NULL, VARCHAR (50) NOT NULL, VARCHAR (50), VARCHAR (50), Appointment Date DATETIME, Appointment Time DATETIME, Appointment Status VARCHAR (10), PRIMARY KEY (Appointment_ID), FOREIGN KEY (Patient_ID) FOREIGN KEY (Provider_ID) CREATE TABLE Encounter ( Encounter ID Patient ID Provider_ID Appointment ID Encounter_Type Encounter_Start NUMERIC (5) NOT NULL, NUMERIC (5) NOT NULL, NUMERIC (5) NOT NULL, REFERENCES Patient (Patient_ID), REFERENCES Provider (Provider_ID) NUMERIC (5) NOT NULL, NUMERIC (5) NOT NULL, NUMERIC (5) NOT NULL, NUMERIC (5) NOT NULL, VARCHAR (10), DATETIME, Encounter End DATETIME, Appointment Status VARCHAR (10), PRIMARY KEY (Appointment_ID), FOREIGN KEY (Patient_ID) REFERENCES Patient (Patient_ID), FOREIGN KEY (Provider_ID) REFERENCES Provider (Provider_ID)