Database For ****FEDULIKE

profilesbhblw56
community_health_and_wellness_clinic1.accdb
Home>Nursing homework help>Database For ****FEDULIKE
Nurses Last Name First Name Nurse ID Address Zip Code Office Telephone Mobile Phone Email
1 Julian Riqu 153 2727 lemmon Ave 75204 2143456759 904567892 [email protected]
2 Sibeer Karen 240 2801 Mckinney ave 75220 972345678 224509550 [email protected]
4 Tom Jerry 445 2340 Justice ave 76110 305904879 243589750 [email protected]
7 Olamide Badoo 450 234 Ebinpejo St 78560 349043260 887653450 [email protected]
5 Hanes Rando 543 456 Linkein st 78990 334567890 239555650 [email protected]
10 Nguyen Yeh 553 343 Liberty blvd 92456 223567984 554558750 [email protected]
8 keck Angela 749 873 Kirk St 89450 783456989 664433560 [email protected]
6 Georgia Natalie 754 456 apple close 90560 205438990 554679810 [email protected]
9 Hernandez Jesus 889 676 London ave 77580 567390325 900547850 [email protected]
3 Morales Jane 900 209 3rd St 78900 234908540 230045890 [email protected]
Records Account Number Medical Record Number Provider ID Chief Complaint Nurse ID Date Admitted
1 1122340 273546 3467 Dyspnea 153 12/7/15
2 1145670 234560 5520 Rash 240 7/16/14
3 1122340 273546 7743 Ankle Pain 900 9/22/15
4 1234573 344374 3419 chest pain 445 10/18/13
5 9923457 434560 5619 elevated blood sugar 543 4/22/16
6 7849032 750490 4518 Abnormal Labs 754 10/24/12
7 2000495 874930 2278 Eye redness 450 11/26/15
8 7002348 500321 6201 Aggravated Assault 749 1/10/16
9 4390221 789430 1820 Gunshot wound 889 7/16/14
10 2458700 962340 405 Fall 553 10/21/14
11 0 0 0
12 0 0 0
PATIENTS Field First Name Medical Record Number Address Zip Code Office Telephone Mobile Number Email Last Name
2 Anne 234560 756 Justin pl 94580 740932640 664489320 [email protected] Jacques
1 Hamilton 273546 818 Maroko ave 26540 789345620 445567389 [email protected] Bara
4 Parsley 344374 7769 downtown st 33390 803434440 933048320 [email protected] Holter
5 Paul 434560 34 first street 34870 940456637 487609580 [email protected] Walden
3 Myra 456790 314 huntsville blvd 84349 805423907 703251402 [email protected] Pricey
8 Elizabeth 500321 67300 Livernois rd 40050 587564390 893123450 [email protected] Leathan
6 tyrone 750490 4595 Madaru close 56390 764930202 694011223 [email protected] Detrick
9 Nadi 789430 2345 pakis ave 78630 340978210 988066720 [email protected] Shaw
7 Jon 874930 3214 Joy road 43030 313729870 248909430 [email protected] Duckert
10 Dami 962340 33 luth st 43567 443388770 782304090 [email protected] Hicks
PROVIDERS Last Name First Name Address Zip Code Office Phone Mobile Phone Field Email Address Provider ID
10 Brad Pitt 2134 hollywood blvd 32900 342890930 540218590 405 [email protected] 405
9 Williams Serena 4319 Tennis St 89030 549032859 578555989 1820 [email protected] 1820
7 Adebowale biyi 2143 10th street 54230 313258231 248787330 2278 [email protected] 2278
4 Johnson Phillip 23 appleton blvd 21108 305970945 803436759 3419 [email protected] 3419
1 Brown Janet 612 third st 75204 206657890 234897900 3467 [email protected] 3467
6 Yao Chen 26 Lake city st 32050 890502233 196346581 4518 [email protected] 4518
2 Ade Love 2217 Ivan st 48220 910787555 555367896 5520 [email protected] 5520
5 Justice Jung 2893 buff blvd 32034 670907673 421903334 5619 [email protected] 5619
8 Hunt Brad 6739 Live blvd 55440 433298730 555605780 6201 [email protected] 6201
3 Rodriguez Carlos 8836 Burnette st 48210 214443456 510905674 7743 [email protected] 7743
11 0 0 0 0
SELECT [PATIENT RECORDS].[Chief Complaint], [PATIENT RECORDS].[Date Admitted], [PATIENT RECORDS].[Records], [PATIENT RECORDS].[Account Number], [PATIENT RECORDS].[Medical Record Number], [PATIENT RECORDS].[Provider ID], [PATIENT RECORDS].[Nurse ID] FROM [PATIENT RECORDS];
SELECT Nurses.[Nurses], Nurses.[Last Name], Nurses.[First Name], Nurses.[Nurse ID], Nurses.[Address], Nurses.[Zip Code], Nurses.[Office Telephone], Nurses.[Mobile Phone], Nurses.[Email] FROM Nurses;
SELECT [PATIENT RECORDS].[Medical Record Number], [PATIENT RECORDS].[Chief Complaint], [PATIENT RECORDS].[Nurse ID], [PATIENT RECORDS].[Date Admitted] FROM [PATIENT RECORDS];