Reference no: EM131015300

Database Records and Relational Data Worksheet

Complete Parts A and B of this worksheet.

Part A: Database Records l

Answer the following patient information questions using the table provided. Refer to Figure 4-10 on p. 83 of Health Information Technology and Management for assistance.

1. What patient resides in California? What is the patient number?

2. Who is Sofia Yakaria Pallares' provider? What credentials does her provider have?

3. What patient was seen on 11/05/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 ll

Write 150- to 350-word responses 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 healthcare.