This assignment should be done in SQL

Based on the relational schema (3NF) from the diagram on the picture, analyze the tables, their relationships, and the sample data below:

a. CREATE THE TABLES, using the best data types based on analysis. Follow each table name with an underscore and your first, middle, and last initials (if you do not have a middle initial, use X). For example, if your name is Alice B Chandler, table name would be named the Patient table PATIENT_abc. Also, keep in mind that foreign key relationships require the same data types on both sides (e.g., if declared PatientID as INTEGER in the Patient table, it must be declared as INTEGER in the Rental table, too).

b. Execute a DESCRIBE statement for each table to show its general structure.

PATIENT REASON ApptReasonCode ApptReasonDesc PatientID PatientFName PatientLName PatientPhone APPTDETAIL APPOINTMENT ApptiD ApptReasonCode BlockCode ApptDate ApptTime PatientID DoctoriD BillingType InsColD ApptStatusCode 0O DOCTOR DoctorlD DoctorFName DoctorLName BLOCK BlockCode BlockDesc BlockTime BILLINGTYPE BillingType BillingTypeDesc INSCO InsColD InsCoName STATUS ApptStatusCode ApptStatusDesc