Essay Database Records and Relational Data Worksheet

Words: 985
Pages: 4
Open Document
University of Phoenix Material

Database Records and Relational Data Worksheet

Complete Parts A and B of this worksheet.

Cite your sources.

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?
The patient that resides in California Sofia Yakaria Pallares. Her patient number is 10259. Gartee, R. (2011).

2. Who is the provider of Sofia Yakaria Pallares? What credentials does her provider have?
Ruth Ann Raymond is Sofia’s provider and Ruth Ann Raymond has her MD license. Gartee, R. (2011).

3. What …show more content…
You might have to go to one program to find all of the treatments the doctor has tried with a patient and then to another program to be able to see what kind of insurance the patient may have and how much insurance didn’t pay. Then you would be able to bill the patient after all that information is completed and you may have to use yet another program to do that. With relational data you can pull up one program and see anything about that patient in that one program. You can look at what time their appointment is, their address, the reason for their visits and all the insurance and billing information in one spot. Gartee, R. (2011).

3. Explain why the use of databases is important in health care.
In my opinion a database is important in health care because it tells everything about us that is needed to give us the best possible care. It is also beneficial to the organization you have an appointment with in terms of billing. When we go to a doctor or hospital they can pull up the database with our information and see first of all I do have an appointment and what time. Then they can pull up why I am there weather it is an illness I am being treated for or my annual checkup. If I am being treated for anything they can see what they have done and what the next course of action is to be. If they sent me to have test run at the hospital my results would be in the database as well. The doctor I see for my needs
Show More

Related Documents: Essay Database Records and Relational Data Worksheet

Nt1310 Unit 3 Unit3

1. Hard disk is a storage device which can be used in computer to store and save data. On the other hand RAM (random Access Memory) is a temporary storage memory, it helps to monitor the process of computer. Hard disk is a storage device until RAM is temporary storage memory 2. Software is a general term for the various kinds of programs used to operate computers and related devices 3. (1) Manage the computer's resources (2) establish a user interface, (3) execute and provide services for applications…

Words 1189 - Pages 5

Computer crime involves Essay example

common form of computer crime. Computers are used to steal  Money  Goods  Information  Computer resources  One common type of computer theft today is the actual theft of computers, such as notebook and PDAs  Notebook and PDAs are expensive  Data stored on a computer can be more valuable Denial o f Service ( DOS)  Attacks bombard servers and Web sites with so much bogus traffic that they are effectively shut down networks, denying service to legitimate customers and clients. Computer security…

Words 7422 - Pages 30

System Media Assignment

Hierarchical database; this is a ranked database, which purpose is to organize data to form a treelike structure, in a pyramid opposite. All access to the data starts from the hierarchy and moves downward. The hierarchy of parent and child data segment is an example. IMS is the most popularly used. It is developed by IBM and windows Registry by Microsoft. The Hierarchical database collects all instances of a specific record together as a record type. It also allows repeating information. Flat database; this…

Words 1941 - Pages 8

Winter Study Guide Essay

Comprehensive Exam (in reverse order) BUS 391 Chapter 7 Networks, Telecommunications, and Wireless Networks and Telecommunications Network Basics • Telecommunication system - enable the transmission of data over public or private networks • Network - a communications, data exchange, and resource-sharing system created by linking two or more computers and establishing standards, or protocols, so that they can work together • The three types of networks include: Local area…

Words 5237 - Pages 21

Your Problems Essay

issues… USE CHAT (or SKYPE?) TO COMMUNICATE. Sunday 6pm, 11 /30 ­ Target Date for completion Part I and Part II. Wednesday, Dec. 3rd by 11:00pm Deliverables due in Dropbox, Part I ­ ERD diagram and script to create our MS­Patient­Data­Worksheet Database. (Note: we do not need to submit our (PPT) presentation to dropbox.) Part II ­ All SQL queries. Group Project Part I and II Submitted Wednesday 12/3 Chat meeting here 6pm, Sunday 12/7 Sunday 12/7 ­ Chat meeting here 6pm Wednesday…

Words 2290 - Pages 10

Managing Information Technology (7th Edition) Essay

I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5 Data Governance at InsuraCorp CASE STUDY I-6 H.H. Gregg’s Appliances, Inc.: Deciding on a New Information Technology Platform CASE STUDY I-7 Midsouth Chamber of Commerce (B): Cleaning Up an Information Systems Debacle CASE STUDY…

Words 239873 - Pages 960