A spreadsheet ( PatientLab ) below stores some sample data for a clinic office that includes the information of a patient, insurance, lab test, and lab test result Assume that one patient can have multiple different tests performed in one day and the same test can be performed for the same patient on different dates Patient ID Name Insuranc Code Insurance Name DOB Lab Test ID Lab Test Name Lab Result Lab Test Date P001 Joe Wei IN001 B B 1 1 1970 L001 WBC 3 5 5 2014 P001 Joe Wei IN001 B B 1 1 1970 L002 RBC 15 5 5 2014 P001 Joe Wei IN001 B B 1 1 1970 L003 MCV 90 5 5 2014 P002 John Nicholas IN002 Atena 2 2 1978 L002 RBC 16 5 6 2014 P002 John Nicholas IN002 Atena 2 2 1978 L004 MCH 32 5 6 2014 P001 Joe Wei IN001 B B 1 1 1970 L001 WBC 3 2 6 6 2014 Identify and explain what are problems with using this spreadsheet to store the data List out the problem and explain why it is a problem by giving an example Pay attention to the problem below (1) data storage, (2) data insertion and (3) data modification below (15 pts) a data storage b data insertion c data modification

The Answer is in the image, click to view ...

Question: A spreadsheet ( PatientLab ) below stores some sample data for a clinic office that includes the information of a patient, insurance, lab test, and

A spreadsheet (PatientLab) below stores some sample data for a clinic office that includes the information of a patient, insurance, lab test, and lab test result. Assume that one patient can have multiple different tests performed in one day and the same test can be performed for the same patient on different dates.

Patient _ID	Name	Insuranc_Code	Insurance_Name	DOB	Lab_Test_ID	Lab_Test_Name	Lab_Result	Lab_Test_Date
P001	Joe Wei	IN001	B&B	1/1/1970	L001	WBC	3	5/5/2014
P001	Joe Wei	IN001	B&B	1/1/1970	L002	RBC	15	5/5/2014
P001	Joe Wei	IN001	B&B	1/1/1970	L003	MCV	90	5/5/2014
P002	John Nicholas	IN002	Atena	2/2/1978	L002	RBC	16	5/6/2014
P002	John Nicholas	IN002	Atena	2/2/1978	L004	MCH	32	5/6/2014
P001	Joe Wei	IN001	B&B	1/1/1970	L001	WBC	3.2	6/6/2014

Identify and explain what are problems with using this spreadsheet to store the data? List out the problem and explain why it is a problem by giving an example. Pay attention to the problem below (1) data storage, (2) data insertion and (3) data modification below. (15 pts)

a. data storage

b. data insertion

c. data modification

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

1. Read the case study provided below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study,...

te ForrmulAy Project 2 (40 pts.) Central Hospital - A Capital Budgeting Oblective Central Hospital, established in 1904, is the premier hospital in Oklahid onditions nt over Es Patients travel from...

Objective Central Hospital, established in 1904, is the premier hospital in Oklahoma City specializing in cardiology. Patients travel from all over the county to be diagnosed for rare heart...

County Hospital wishes to improve the service level of its regular Xray operation, which runs from 8 A.M. to 5 P.M. Patients have identified the total required time as their main concern with this...

Can you review the comprehensive implementation plan and support in making it a better version? Contents 1. Executive Summary 3 2. Introduction 3 Overview of Riverside Health Network 3 Current...

On March 3, 2002, pursuant to a public offering, First All State Trucking Corp. (FAST) issued securities to investors in denominations of $1,000. The interest rate was 7 percent per year payable...

Why is target audience selection the critical first step in formulating a media strategy?

Problem 1 A Future Future Value Value Factor a) b) c) d) Problem 2 A B Present Present Value Value a) b) c) d) Problem 3 IRR Cash Flow Cummulative Cash Flow IRR= % Problem 4 Excel less the investment...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

9. What is human capital? How is human capital influencing the changing role of training from skill and knowledge acquisition to creating and sharing knowledge?

3. Which model or combination of models is best for organizing the training function? Why?

5. Explain the training needs created by concentration, internal growth, external growth, and disinvestment business strategies.