What are the main components of a database?

/in /by

What are the main components of a database?

Database Records and Relational Data
HCIS/140 Version 6
2

University of Phoenix Material
Database Records and Relational Data
Complete Parts A and B.
Cite any outside sources. For additional information on how to properly cite your sources, log on to the Reference and Citation Generator in the Center for Writing Excellence.
Part A: Database Records l
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.
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 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
Birth date

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 a 150- to 350-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.

Copyright © 2018 by University of Phoenix. All rights reserved.