What are the main components of a database?

Database Records and Relational Data

HCIS/140 Version 6


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.