Assignment: Database Records and Relational Data
Part A: Database Records
Answer the following patient information questions using the table provided
Refer to Figure 4-10 on p. 83 of your textbook Health Information Technology and Management for assistance. (IMAGE WAS UPLOADED TO THE ATTACHMENTS)
1. What patient resides in California? What is the patient number?
2. Who is Sofia Yakaria Pallares's provider? What credentials does her provider have?
3. What patient was seen on November 5, 2010? What is the patient's date of birth?
4. What date and time did patient #1298 visit the doctor's office? What is the patient's name and date of birth?
5. What patient lives at 1704 N. Atlantic Ave. Ontario, AZ 85320? What is their encounter number?
|
Patient Info Table
|
|
|
Pat#
|
Last_Name
|
First_Name
|
Middle_Name
|
Birthdate
|
|
10259
|
Pallares
|
Sofia
|
Yakaria
|
9/18/1985
|
|
30528
|
Peters
|
John
|
|
5/25/1965
|
|
1298
|
Johnson
|
Lucy
|
Ann
|
6/12/1975
|
|
Patient Address Table
|
|
|
Pat#
|
Address
|
City
|
State
|
Zip
|
|
10259
|
705 E. Woodlawn St.
|
Peoria
|
CA
|
91762
|
|
30528
|
1704 N. Atlantic Ave.
|
Ontario
|
AZ
|
85320
|
|
1298
|
5150 W. Eugie St.
|
Glendale
|
NY
|
95627
|
|
Patient Visits Table
|
|
|
Pat#
|
Encounter#
|
Date
|
Time
|
Provider#
|
|
10259
|
100876
|
20111221
|
10:00
|
2
|
|
30528
|
111218
|
20101105
|
11:30
|
3
|
|
1298
|
120548
|
20110604
|
17:15
|
1
|
|
|
|
|
|
|
|
|
Provider Info Table
|
|
|
Provider#
|
Last_Name
|
First_Name
|
Middle_Name
|
Credentials
|
|
1
|
Lee
|
Sam
|
|
MD
|
|
2
|
Raymond
|
Ruth
|
Ann
|
MD
|
|
3
|
East
|
Leann
|
|
ARNP
|
Part B: Database Records
Write a 150 word response to each of the following questions. Be clear and concise, use complete sentences, and explain your answers using specific examples.
1. What are the main components of a database?
2. Based on Part A of this assignment, explain how relational data is used?
3. Explain why the use of databases is important in health care.
Attachment:- Auto-Color.pdf