Database Records and Relational Data Worksheet

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.

 

Field of study: 
Date Due: 
Friday, November 23, 2018

Answer

Database Records and Relational Data Worksheet

Purchase this answer to view and download it immediately
Money Back Guarantee