Reference no: EM131340924
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 healthcare.
Explain the federal reserves open-market operations
: Discuss the Federal Reserve's open-market operations, and the importance of its role. How does another key central bank around the world conduct such operations, and why are they important?
|
Implement numbers sorting in a dynamic linked list
: Using queue, implement a complete traversal of all directories on your hard disk and print them on the console. Implement the algorithm Breadth-First-Search (BFS) - you may find some articles in the internet.
|
Explain the methods for establishing component priorities
: Describe The Methods For Establishing Component Priorities, Including: Business Functions And Processes, Bia Scenarios And Components and Financial And Service Impact Of Components Not Being Available.
|
What is the price of a t-bond with exactly
: What is the price of a T-Bond with exactly 24.5 years to maturity and coupons with rate 5.875% paid semi-annually? Its yield is 6.5% BEY (Bond Equivalent Yield is semi-annually compounded).
|
What patient resides in california
: What patient resides in California? What is the patient number?Who is Sofia Yakaria Pallares' provider? What credentials does her provider have?What patient was seen on November 5, 2010? What is the patient's date of birth?What date and time did pati..
|
Implement a complete traversal of all directories
: Using queue, implement a complete traversal of all directories on your hard disk and print them on the console. Implement the algorithm Depth-First-Search (DFS) - you may find some articles in the internet.
|
Covariance between returns on vbn and wilshire
: i) Calculate the covariance between the returns on VBN and the Wilshire 5000 index. ii) Does VBN's returns move with or against the returns on the Wilshire 5000? iii) Is VBN highly, moderately, or barely sensitive to fluctuations in the Wilshire 5000..
|
Identify five examples of gender-related behaviors
: Identify 3-5 examples of gender-related behaviors that are developed through reinforcement and punishment. Be sure to provide a balanced view for boys and girls, and select examples which apply to the development of both boys and girls.
|
Why would royalists have supported his ideas
: Why would royalists have supported his ideas? Why does the book say that many royalists rejected his ideas? Answer in a 1 page sentence paragraph.
|