HCIS 140 Week 1 Database Records and Relational Data Worksheet

HCIS 140 Entire Course Link 
https://uopcourses.com/category/hcis-140/

HCIS 140 Week 1 Database Records and Relational Data Worksheet
Complete the University of Phoenix Material: Database Records and Relational Data Worksheet.
Click the Assignment Files tab to submit your assignment.
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 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 11/05/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 150- to 350-word responses 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.
 
Powered by