for the visit table im getting this error please tell me whay im doing wrong

3 Request edit access ] =) Proj... File Edit View Tools Help Visit Column Name VisitID Patient ID DoctorID Dateof Visit RXID Symptoms Estimates Actuals Data Type INT INT INT DATE INT VARCHAR(60) DECIMAL(7.2) DECIMAL(7.2) Notes PK Not null Not null Not null Tasks: 1. No MySQL is needed to complete this step. The entities in the ERD above are incomplete: they are missing the relationships between them. Connect these enti adding relationships to create a complete Entity Relationship Diagram (ERD). Y to include all foreign keys (FK) and the relationship types such as - one-to-one, one-to-many or many-to-many (10 points) 2. In a txt file (using Notepad), write SQL commands to create the tables. Name thi file as Lastname_Med_DB.txt (being Lastname is your last name). (10 points) 3. Use the attached script (Medical_Insert) to create records in the database tables. Il addition to those records, in the same text file you created in step 2. add two SQL commands to insert the following records. Also Write SELECT statements to disp records from the tables you created. At this point, the records should match the one given above plus the ones you added with your first and last name. (8 points) a) a record into the DOCTOR table using your first and last name (you can make other info b) a record into the PATIENT table using your first and last name (you can make u other info) 4. In the same text file. create SELECT statements to generate the following reports, 3) Write a SELECT statement that retums patients information ID name and em ngage.com/st. A e a Search this course 0 + SQL 1 CREATE TABLE VISIT 2 VISITID INT PRIMARY KEY. 3 PATIENTID INT, 4 DOCTOR_ID INT, 5 DATE_OF_VISIT DATE, 6 RXID INT. 7 SYMPTOMS VARCHAR(60), 8 ESTIMATE$ DECIMAL (7,2), 9 ACTUAL$ DECIMAL (7,2) 10 ): 11 + SOL Viewer > Terminal ERROR 1064 (42000) at line 1: You have an error in your SOL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near PATIENTID INT. DOCTOR_ID INT. DATE OF VISIT DATE RXID INT. SYMPTOMS VARCHAR(6' at line 2 3 Request edit access ] =) Proj... File Edit View Tools Help Visit Column Name VisitID Patient ID DoctorID Dateof Visit RXID Symptoms Estimates Actuals Data Type INT INT INT DATE INT VARCHAR(60) DECIMAL(7.2) DECIMAL(7.2) Notes PK Not null Not null Not null Tasks: 1. No MySQL is needed to complete this step. The entities in the ERD above are incomplete: they are missing the relationships between them. Connect these enti adding relationships to create a complete Entity Relationship Diagram (ERD). Y to include all foreign keys (FK) and the relationship types such as - one-to-one, one-to-many or many-to-many (10 points) 2. In a txt file (using Notepad), write SQL commands to create the tables. Name thi file as Lastname_Med_DB.txt (being Lastname is your last name). (10 points) 3. Use the attached script (Medical_Insert) to create records in the database tables. Il addition to those records, in the same text file you created in step 2. add two SQL commands to insert the following records. Also Write SELECT statements to disp records from the tables you created. At this point, the records should match the one given above plus the ones you added with your first and last name. (8 points) a) a record into the DOCTOR table using your first and last name (you can make other info b) a record into the PATIENT table using your first and last name (you can make u other info) 4. In the same text file. create SELECT statements to generate the following reports, 3) Write a SELECT statement that retums patients information ID name and em ngage.com/st. A e a Search this course 0 + SQL 1 CREATE TABLE VISIT 2 VISITID INT PRIMARY KEY. 3 PATIENTID INT, 4 DOCTOR_ID INT, 5 DATE_OF_VISIT DATE, 6 RXID INT. 7 SYMPTOMS VARCHAR(60), 8 ESTIMATE$ DECIMAL (7,2), 9 ACTUAL$ DECIMAL (7,2) 10 ): 11 + SOL Viewer > Terminal ERROR 1064 (42000) at line 1: You have an error in your SOL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near PATIENTID INT. DOCTOR_ID INT. DATE OF VISIT DATE RXID INT. SYMPTOMS VARCHAR(6' at line 2