Reference no: EM131260581
Database Records and Relational Data Worksheet
Complete Parts A and B of this worksheet.
Cite any outside sources. For additional information on how to properly cite your sources, check out the Reference and Citation Generator resource 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
|
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 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.
|
Research paper of approximately five
: Prepare a short research paper of approximately five (5) pages, double-spaced, exclusive of cover, title page, table of contents, endnotes and bibliography. Your paper must use APA formatting with the exception that tables and figures can be inse..
|
|
What is the difference between computer hardware and softwar
: What is the difference between computer hardware and software? Why is the use of information systems in health care important? Explain your answer.
|
|
Construct a bond graph model of the system
: Consider the system from Problem 12-5. Neglect thermal capacitance of the piston walls but include leakage past the piston to the atmosphere. Using one thermodynamic accumulator and one 4-port isentropic nozzle, construct a bond graph model of the..
|
|
What should brewerton do to maximize his expected payoff
: If he does not exercise this option, then the payoff is $40,000. - What should Brewerton do to maximize his expected payoff? - What is the value of this expected payoff?
|
|
What are the main components of a database
: What are the main components of a database? Based on Part A of this assignment, explain how relational data is used? Explain why the use of databases is important in health care.
|
|
Examine the various techniques
: There are many techniques that are used to harden a system. Examine the various techniques that are used and select two that you would recommend being used in your organization and two that you would not recommend. Provide a rationale for your res..
|
|
Hope limit and next header of a ipv6 header
: What is the length of hope limit and Next Header of a ipv6 header?
|
|
What is advice to musa
: Philip Musa can build either a large electronics section or a small one in his Birmingham drugstore. - What is your advice to Musa?
|
|
Construct a bond graph model of this system
: Construct a bond graph model of this system, including all the dynamics suggested in the figure. Assign causality to show that formulation will be straightforward. This model could be used to test control strategies for an adaptive suspension.
|