What else am I missing from my SQL statements from this ER diagram? SQL statements below

 

 

/*Data Definition- DDL (CREATE DATABASE, CREATE TABLE)*/ 

CREATE TABLE DOCTIME ( 

dID NOT NULL PRIMARY KEY,

 firstName VARCHAR (12),

 lastName VARCHAR (12),

 AgeINTEGER,

 Appointment DATE, ); 

Transcribed Image Text:

patient Pat ID/PK) pat name pat add pat State pat City pat zip pat ins patphone version 3 ok Appointment! APPTID (PK) pat ID (FK) DOCID (FK) emergency Appt type Appt time Appt datel 1," 0.1 Insurance Incio ... Doctor (tor DOCID (PK) Visit Visit ID (PK) APP+ ID (FK) biagnosis Bill PATID. Bill Ip noc 10 (FK) VISITID Billamt Bill pay Bill ID (FK) Ray in inc In foi bat in Bellanit Pay amt patient Pat ID/PK) pat name pat add pat State pat City pat zip pat ins patphone version 3 ok Appointment! APPTID (PK) pat ID (FK) DOCID (FK) emergency Appt type Appt time Appt datel 1," 0.1 Insurance Incio ... Doctor (tor DOCID (PK) Visit Visit ID (PK) APP+ ID (FK) biagnosis Bill PATID. Bill Ip noc 10 (FK) VISITID Billamt Bill pay Bill ID (FK) Ray in inc In foi bat in Bellanit Pay amt