What are the main components of a database

Assignment Help Other Subject
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.

 

 

Reference no: EM131260581

Questions Cloud

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.

Reviews

Write a Review

 

Other Subject Questions & Answers

  Five prevention and fire suppression

Compare and contrast the terms five prevention and fire suppression. provide two examples of fire prevention methods and two examples methods, which of the methods you provided do you believe would be most effective for reducing the risk of death ..

  Discusses a variety of genres in film

The chapter discusses a variety of genres in film. In Seminar, you will discuss these genres, as well as the purpose of film and its techniques.

  Discuss the possible sources of bias and inaccuracy

Discuss the possible sources of bias and inaccuracy whenever a person looks back on their past history. Be sure to discuss factors related to memory and factors related to cognition.

  What about cultural factors such as filial piety

How much variation across countries, do you think, are explained by can economic factors (public programs for old age security, health insurance, stability of economic situations)? Then what about cultural factors such as ‘filial piety' in Asian c..

  Research design for addressing the problem

Develop an alternative research design for addressing the problem presented. At the end of this assignment, you will be able to present to management two ways of capturing data to address the research problem.

  Breast cancer chemotherapy

For example, do you know any women who have had their breast cancer chemotherapy paid for by Avon? by Mary Kay? through a drug company?

  Explain case management models applied in the case managers

createnbspanbspcasenbspmanagementnbspmultimedianbsppresentation.nbspinclude the following in your presentationdescribe

  Bellman-ford algorithm

Suppose that in addition to a system of difference constraints, we want to handle equality constraintsof the form xi= xj+ bk. Show how the Bellman-Ford algorithm can be adapted to solve this variety of constraint system

  Discussing the value of general education skills

In the last few weeks, we have been discussing the value of General Education skills such as Critical Thinking and Communication. Now that you have identified how these skills are an important feature of your education, we are going to look at the..

  What are the pros and cons of using personal pronouns

What are the pros and cons of using personal pronouns in scholarly writing? Why would most academic institutions not permit the use of these pronouns? Do you agree or disagree with this perspective that institutions hold? Why or why not?

  Speech to the class-hardworking teammate

I was assigned to give a speech to the class that if I got arrested for being under age and under the influence of alcohol. How would I apologize to the entire team in front of the coaches as well, and convince them that I am truly sorry and want to ..

  Describe the ethical issues you may encounter

Write a 1,050- to-1,400 word paper that includes the following: Include what therapeutic approach you would apply in this case, and explain why you chose it. Describe the ethical issues you may encounter, as well as how you intend to approach them

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd