When a new patient is admitted for treatment in the hospital, the new patient record must be added to the ExampleHMO database.
INSERT INTO PATIENT
VALUES('123-45-6789', 'BOB', 'Bob', '123 Some St.', 'hypertension', 9.00,'LEE');
INSERT INTO PATIENTCHOICE
VALUES('123-45-6789', 'drug-research', 'opt-in');
Select * FROM PATIENT WHERE NAME = 'Bob';
SSN USERID NAME ADDRESS PHARMACY ACCT_BALANCE PCP_ID
----------- --------- ------- ------------- ------------ ------------- ------
123-45-6789 BOB Bob 123 Some St. XXXXXXXXXXX 0.00 LEE