1. Most medical practices use turn-key systems to handle billing data and basic electronic medical records. But a local physician wants a system to help him perform deeper statistical analyses on basic patient data. Specifically, he wants to track basic test results for patients and wants to compare them by families. For example, he wants to see if families where parents have high blood pressure also affect the blood pressure of the children and at what age those values change. Initially, he just wants to track basic medical values including heart rate, pressure, and basic blood test. Notes: 

Patient Last name, First Name Date of Birth Gender Race Tobacco y/n Alcohol y/n Marital Status Phone, e-mail Address, City, State, ZIP			Father: Mother: Family history notes, particularly if data is not available.
Test date: Last mealtime:
Test	Measure	Value	Low	High	Comments
Albumin	g/dL		3.9	5.0
Alkaline phosphatase	IU/L		44	147
ALT	IU/L		8	37
AST	IU/L		10	34
BUN	mg/dL		7	20
Calcium	mg/dL		8.5	10.9
Chloride	mmol/L		96	106
CO2	mmol/L		20	29
Creatine	mg/dL		0.8	1.4
Glucose	mg/dL		100
Potassium	mEq/L		3.7	5.2
Sodium	mEq/L		136	144
Total bilirubin	mg/dL		0.2	1.9
Total protein	g/dL		6.3	7.9
Blood pressure-systolic	mm Hg		90	140
Pressure-diastolic	mm Hg		60	90
Heart rate	bpm		50	90

Answer rating: 100% (QA)

To meet the requirements of the local physician a custom software system needs to be developed that can handle the storage analysis and comparison of ... View the full answer