assignment

profileali-100k
Assignment-Week3Database.accdb
Home>Applied Sciences homework help>assignment
PatientID LastName FirstName StreetAddress City State Zip Phone Gender DateOfBirth Race Ethnicity Note
1 Wang Dongwen 13212 E. Shea Blvd. Scottsdale AZ 85259 480-884-0264 Male 3/3/45 Asian Not Hispanic or Latino
2 King Larry 321 CNN Center Atlanta GA 43210 Male 1/1/23 White Not Hispanic or Latino
3 McCain John 2201 E Camelback Rd #115 Phoenix AZ 85016 602-952-2410 Male 2/2/40 White Not Hispanic or Latino
4 Longoria Eva 123 Hollywood Blvd. Los Angles CA 95002 Female 4/4/70 White Hispanic or Latino
5 Houston Whitney 321 Rodeo Drive Hollywood CA 92001 Female 8/9/63 Black or African American Not Hispanic or Latino
6 Doe Jane 987 Sixth Street Mesa AZ 85555 Female 9/20/82 Native Hawaiin or Other Pacific Islander Not Hispanic or Latino
PatientID ProviderID
1 1
1 2
2 2
3 1
4 2
5 1
6 2
PatientID SSN Account Number Account Balance Saved Credit Card Type Saved Credit Card Number
1 123-45-6789 1001 ¤ 356.00 Visa 987654321012
2 234-56-7890 1002 ¤ 0.00
3 345-67-8901 1003 ¤ 0.00 MasterCard 876543210123
4 456-78-9012 1107 ¤ 20,000.00
5 567-89-0123 3298 ¤ 0.00
6 678-90-1234 7689 ¤ 3,290.00 American Express 765432101234
ProviderID LastName FirstName Discipline Specialty Note
1 Little Do MD Internal Medicine
2 Nurse Betty Nurse
VisitID PatientID VisitDate Note ProviderID
1 1 6/6/07 1
2 1 9/10/07 2
3 2 11/6/09 2
4 3 1/5/16 1
5 4 1/12/16 2
6 5 1/21/16 1
7 4 1/22/16 2
8 6 3/22/16 2