Question: What else am I missing from my SQL statements from this ER diagram? SQL statements below /*Data Definition- DDL (CREATE DATABASE, CREATE TABLE)*/
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, ); 
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
Step by Step Solution
3.51 Rating (164 Votes )
There are 3 Steps involved in it
It seems like youre missing some details from the ER diagram that would help in completing the SQL s... View full answer
Get step-by-step solutions from verified subject matter experts
