MSIS$/$IT$230$

DATA FOR INSERT STATEMENTS

Patient

PatientID PatientLName PatientFName Street City State Zip Gender Password

SJ$001$ Jones Samuel $15$ Main Street Chelsea MA $01503$ M SJones$1234$

NS$001$ Smith Nancy $12$ Royal Pointe Drive Cambridge MA $02144-2525$ F NSmith$6954$

RA$001$ Adams Robert $420$ Brook Ave SE Boston MA $02155-0154$ M RAdams$2323$

BB$001$ Brooks Bradford $425$ West WT Harris Boston MA $02156$ M BBrooks$9815$

SM$001$ McDonald Susan $32$ Harvard Street Cambridge MA $02140$ F SMcDonald$1257$

SW$001$ Winsor Stephen $54$ Tremont Street Boston MA $02157-5658$ M SWinsor$1299$

TA$001$ Anthony Todd $1$ Cambridge Street Cambridge MA $02142-2562$ M TAnthony$5972$

JW$001$ Walker Joanne $543$ Boylston Street Boston MA $02157-2222$ F JWalker$2222$

TH$001$ Hastings Timothy $54$ Linden Street Woonsocket RI $01989$ M THastings$2187$

MY$001$ Young Margaret $12$ First Street Pawtucket RI $01925$ F MYoung$7098$

CM$001$ MacNamara Christine $37$ Colony Circle Tewksbury MA $02654-0001$ F CMacNamara$0014$

DW$001$ Winsor Deborah $14$ Lyman Road Nashua NH $03254$ M DWinsor$0818$

HB$001$ Brown Harold $178$ Cross Street Worcester MA $01565$ M HBrown$2525$

CN$001$ Noble Charles $17$ Seaside Lane Plymouth MA $01598-5555$ M CNoble$9514$

FL$001$ Lawton Frances $100$ Torrey Pine Drive Providence RI $01922$ F FLawton$7536$

PH$001$ Hohl Patrick $12$ Michigan Blvd$.$ Revere MA $02023$ M PHohl$6007$

KY$001$ Yang Kim $18$ Boston Post Road Sudbury MA $01958-2345$ F KYang$4870$

JS$001$ Santiago Jose $444$ Hickory Lane Portsmouth NH $03365$ M JSantiago$1188$

Employee

EmployeeID TypeID EmployeeLName EmployeeFName Password Gender DateOfHire

PP$001$ PHY Pierce Paul ppierce$1234$

M $12/15/2009$

AA$001$ SURG Adams Abigail aadams$1598$

F $04/09/2022$

WS$001$ TECH Smithson William wsmithson$3578$

M $07/21/2015$

AB$001$ TECH Bonner Allison abonner$1265$

F $04/15/2015$

MB$001$ LPN Brady Marcia mbrady$9635$

F $04/30/2019$

KN$001$ ADMIN Nelson Kenneth knelson$7532$

M $05/01/2022$

CA$001$ PA Alexander Constance calexander$9514$

F $09/25/2014$

TN$001$ RN Nguyen Trin tnguyen$2468$

M $02/02/2017$

SB$001$ ADMIN Brandt Stephen sbrandt$5454$

M $08/13/2014$

JE$001$ SCHED Espanet Jesse jespanet$1245$ M $01/17/2020$

JE$002$ PA Espanet Jordan jespanet$1246$ F $03/12/2016$

EL$001$ SURG Lawton Eleanor elawton$5577$

F $06/01/2015$

RK$001$ RN King Robert rking$5079$

M $11/10/2015$

RK$002$ PHY Kershaw Rowena rkershaw$6901$

F $10/10/2010$

RM$001$ PHY McNamara Richard rmcnamara$0015$

M $06/30/2019$

LC$001$ RN Chin Lori lchin$3690$

F $08/13/2013$

JM$001$ SURG Martinez Jose jmartinez$2468$

M $01/15/2017$

MB$002$ PHY Brown Marcus mbrown$7777$ M $02/02/2015$

$$

EmployeeType Specialty MedicalConditions

TypeID Description SpecialtyID Description ConditionID Description

PHY Physician ANES Anesthesiology APP Appendicitis

RN Registered Nurse RAD Radiology ARTH Arthritis

LPN Licensed Practical Nurse FAM Family Medicine ASTH Asthma

TECH Technician INT Internal Medicine BRONC Bronchitis

SCHED Scheduler NEU Neurology CHSTP Chest Pain

ADMIN Office Staff OBS Obstetrics COVID COVID$-19$

PA Physician Assistant OPH Ophthalmology DIAB$1$ Type $1$ Diabetes

SURG Surgeon PED Pediatrics DIAB$2$ Type $2$ Diabetes

ENT Ears, Nose, Throat EAR Earache

GENSG General Surgery GLSTO Gallstones

VASSG Vascular Surgery HDACH Headaches$/$Migraines

ORTSG Orthopedic Surgery CHOL High Cholesterol

URO Urology OSTEO Osteoporosis

CARDIO Cardiovascular PNEUM Pneumonia

STOM Stomachache and abdominal pain

TONSI Tonsilitis

ULCER Stomach ulcer

PSOR Psoriasis

OBES Obesity

FRACT Fracture

Surgery Prescription

SurgeryID Description PrescriptionID Description

GALL Gall Bladder Removal AT$25$ Atenolol $25$mg

APP Appendectomy TAM Tamsulosin $0\mathrm{.}4$mg

CAT Cataract EZE Ezetimibe $10$mg

CORON Coronary Artery Bypass FIN Finasteride $5$mg

LBP Low Back Pain ARTOR Atorvastatin $20$mg

INGH Inguinal Hernia Repair AMOX Amoxicillin $500$mg

JNTREP Joint Replacement SERT Sertraline $50$mg

OHRT Open Heart FAMO Famotidine $20$mg

ANGIO Angioplasty WARF Warfarin $5$mg

ARTH Arthroscopy PROZ Prozac $20$mg

$$

Schedule

EmployeeID DayOfWeek SortSeq StartTime EndTime

PP$001$ MO $112$:$0020$:$00$

PP$001$ WE $38$:$0017$:$00$

PP$001$ FR $512$:$0020$:$00$

AA$001$ TU $28$:$0017$:$00$

AA$001$ TH $48$:$0017$:$00$

RK$002$ TU $28$:$0017$:$00$

RK$002$ TH $412$:$0020$:$00$

MB$002$ MO $18$:$0012$:$00$

MB$002$ TU $28$:$0012$:$00$

MB$002$ WE $38$:$0012$:$00$

MB$002$ TH $48$:$0012$:$00$

MB$002$ FR $58$:$0012$:$00$

WS$001$ MO $112$:$0017$:$00$

WS$001$ TU $212$:$0017$:$00$

WS$001$ WE $312$:$0017$:$00$

WS$001$ TH $412$:$0017$:$00$

WS$001$ FR $512$:$0017$:$00$

LC$001$ MO $18$:$0017$:$00$

LC$001$ WE $38$:$0017$:$00$

LC$001$ FR $58$:$0017$:$00$

MB$001$ TU $28$:$0012$:$00$

MB$001$ TH $48$:$0012$:$00$

KN$001$ MO $18$:$0012$:$00$

Appointment

AppointmentID PatientID EmployeeID Date StartTime Duration Status

APP$001$ SJ$001$ MB$00207/05/202309$:$002$ Scheduled

APP$002$ RA$001$ AA$00109/13/202312$:$003$ Scheduled

APP$003$ TA$001$ PP$00107/11/202316$:$001$ Scheduled

APP$004$ CM$001$ JE$002$ Null Null

APP$005$ HB$001$ RK$00208/23/202308$:$001$ Scheduled

APP$006$ FL$001$ EL$001$ Null Null

APP$007$ JW$001$ WS$00107/25/202315$:$002$ Scheduled

APP$008$ MY$001$ EL$001$ N$--$ Drop and Create statemements for Medical Clinic database

CREATE SCHEMA IF NOT EXISTS $`$MSIS$230`$;

USE $`$MSIS$230`$ ;

$--$ drop all tables with foreign keys f