INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (100,'AGNES','118 W MAIN STREET');
INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (101,'PALLADIUS','2191 THE CIRCLE AT NORTH HILLS');
INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (102,'MARTIN','213 MARTINIQUE DRIVE');
INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (103,'STEVENS','571 HOLCOMB AVENUE');
INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (104,'TEMPEST','498 WESTRIDGE PLACE');
INSERT INTO BUILDING(BUILDING_CODE,BUILDING_NAME,BUILDING_ADDRESS)
VALUES (105,'MASON','197 COMMONWEALTH BLVD');

INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('120','SOUTHERN SANDS PLAN','SANDS');
INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('121','BLUE CROSS/BLUE SHIELD','BCBS');
INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('122','EXPRESS SCRIPTS HMO','EXPRESSHMO');
INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('123','TRICARE','TRICARE');
INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('124','AETNA PPO','AETPPO');
INSERT INTO INSURANCE_PLAN(INSURANCE_PLAN_ID,DESCRIPTION,PLAN_NAME)
VALUES ('125','ATHENA HEALTH SOLUTIONS','ATHENA');

INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('500','KATHLIN','JONES','397457',100);
INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('501','SCOTTIE','MARR','123456',101);
INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('502','RAY','STANZ','679034',102);
INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('503','EGON','SPANGLER','651327',103);
INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('504','SCOTT','SUMMERS','457890',104);
INSERT INTO PHYSICIAN(PHYSICIAN_CODE,FIRST_NAME,LAST_NAME,CONTACT_NO,BUILDING_CODE)
VALUES ('505','MATT','MURDOCK','974632',105);

INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('10','120','STEVEN','CHAVEZ','125689');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('30','121','SHEILA','KANE','898967');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('60','121','RONNIE','SULLIVAN','674352');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('20','122','AMBER','WILLIAMS','345678');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('50','123','VIOLETTA','MITCHELL','122456');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('70','124','CHRIS','FIGUEROA','176689');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('80','125','LAMAR','PATTON','611479');
INSERT INTO PATIENTS(PATIENT_ID,INSURANCE_PLAN_ID,PAT_FIRST_NAME,PAT_LAST_NAME,CONTACT_NO)
VALUES ('40','125','EDITH','BRADLEY','898900');