Table 9.5 Data for hospital blood test normalization exercise. Test Order Number Date Patient ID Patient Name Doctor ID Doctor Name Test Codes Test Descriptions

"Use visio to create an ERD using Crow's Foot and a UML class diagrams per the exercise details. submit visio work as PDF. Then use the two diagrams you created to create a physical model in Access."

Table 9.5 Data for hospital blood test normalization exercise. Test Order Number Date Patient ID Patient Name Doctor ID Doctor Name Test Codes Test Descriptions R32493 4/22/2012 P0657 Martin Jones D0076 Fernandez BMP R32497 4/22/2012 P0781 Basic metabolic panel Sedimentation rate Isabel Fu D0042 ESR R32501 4/22/2012 Scheimberg Wong P0897 Rajiv Patel D0161 LIPP ESR R32507 4/23/2012 P0684 Lyla Kahn D0076 Fernandez BMP R32509 4/23/2012 P0657 D0076 Fernandez BMP Martin Jones Martin Jones R32512 4/24/2012 P0657 D0161 Wong ESR INR Lipid profile Sedimentation rate Basic metabolic panel Hepatic function panel Basic metabolic panel Sedimentation rate Clotting time test Adrenal function Aldosterone level Sedimentation rate Lipid profile Basic metabolic panel Heart enzymes Hepatic function panel Sedimentation rate R32517 4/24/2012 P0844 Josh Strauss D0042 Scheimberg ADR ALD ESR 4/25/2012 R32608 P0897 D0093 Rajiv Patel Galloway LIPP BMP CKT HFP ESR D0093 Galloway P0781 Isabel Fu 4/25/2012 R32069 and write a da 22 Hospital blood tests: Consider Table 9.5, which gives information on blood tests ordered by doctors at a hospital. Only an illustrative subset of the rows are shown. A single test order may contain requests for multiple tests; for example, test order number R32501 includes both a lipid profile (code LIPP) and a sedimentation rate test (code ESR). Normalize this database so that it is in third normal form. Draw an ER diagram of the resulting database, and write a database design outline. ad and examine the spreadsheet and 9.2 Hospital blood tests: Consider Table 9.5, which gives information on blood tests ordered by doctors at a hospital. Only an illustrative subset of the rows are shown. A single test order may contain requests for multiple tests : for example, test order number R32501 includes both a lipid profile (code LIPP) and a sedimentation rate test (code ESR). Normalize this database so that it is in third normal form. Draw an ER diagram of the resulting database, and write a database design outline. Table 9.5 Data for hospital blood test normalization exercise. Test Order Number Date Patient ID Patient Name Doctor ID Doctor Name Test Codes Test Descriptions R32493 4/22/2012 P0657 Martin Jones D0076 Fernandez BMP R32497 4/22/2012 P0781 Isabel Fu D0042 ESR Scheimberg Wong R32501 4/22/2012 P0897 Rajiv Patel D0161 LIPP ESR R32507 4/23/2012 P0684 Lyla Kahn D0076 Fernandez BMP HFP R32509 4/23/2012 P0657 D0076 Fernandez BMP Martin Jones Martin Jones R32512 4/24/2012 P0657 D0161 Wong ESR INR Basie metabolic panel Sedimentation rate Lipid profile Sedimentation rate Basic metabolic panel Hepatic function panel Basic metabolic panel Sedimentation rate Clotting time test Adrenal function Aldosterone level Sedimentation rate Lipid profile Basic metabolic panel Heart enzymes Hepatic function panel Sedimentation rate R32517 4/24/2012 P0844 Josh Strauss D0042 Scheimberg ADR ALD ESR R32608 4/25/2012 P0897 Rajiv Patel D0093 Galloway LIPP BMP HFP R32069 4/25/2012 P0781 Isabel Fu D0093 Galloway ESR Table 9.5 Data for hospital blood test normalization exercise. Test Order Number Date Patient ID Patient Name Doctor ID Doctor Name Test Codes Test Descriptions R32493 4/22/2012 P0657 Martin Jones D0076 Fernandez BMP R32497 4/22/2012 P0781 Basic metabolic panel Sedimentation rate Isabel Fu D0042 ESR R32501 4/22/2012 Scheimberg Wong P0897 Rajiv Patel D0161 LIPP ESR R32507 4/23/2012 P0684 Lyla Kahn D0076 Fernandez BMP R32509 4/23/2012 P0657 D0076 Fernandez BMP Martin Jones Martin Jones R32512 4/24/2012 P0657 D0161 Wong ESR INR Lipid profile Sedimentation rate Basic metabolic panel Hepatic function panel Basic metabolic panel Sedimentation rate Clotting time test Adrenal function Aldosterone level Sedimentation rate Lipid profile Basic metabolic panel Heart enzymes Hepatic function panel Sedimentation rate R32517 4/24/2012 P0844 Josh Strauss D0042 Scheimberg ADR ALD ESR 4/25/2012 R32608 P0897 D0093 Rajiv Patel Galloway LIPP BMP CKT HFP ESR D0093 Galloway P0781 Isabel Fu 4/25/2012 R32069 and write a da 22 Hospital blood tests: Consider Table 9.5, which gives information on blood tests ordered by doctors at a hospital. Only an illustrative subset of the rows are shown. A single test order may contain requests for multiple tests; for example, test order number R32501 includes both a lipid profile (code LIPP) and a sedimentation rate test (code ESR). Normalize this database so that it is in third normal form. Draw an ER diagram of the resulting database, and write a database design outline. ad and examine the spreadsheet and 9.2 Hospital blood tests: Consider Table 9.5, which gives information on blood tests ordered by doctors at a hospital. Only an illustrative subset of the rows are shown. A single test order may contain requests for multiple tests : for example, test order number R32501 includes both a lipid profile (code LIPP) and a sedimentation rate test (code ESR). Normalize this database so that it is in third normal form. Draw an ER diagram of the resulting database, and write a database design outline. Table 9.5 Data for hospital blood test normalization exercise. Test Order Number Date Patient ID Patient Name Doctor ID Doctor Name Test Codes Test Descriptions R32493 4/22/2012 P0657 Martin Jones D0076 Fernandez BMP R32497 4/22/2012 P0781 Isabel Fu D0042 ESR Scheimberg Wong R32501 4/22/2012 P0897 Rajiv Patel D0161 LIPP ESR R32507 4/23/2012 P0684 Lyla Kahn D0076 Fernandez BMP HFP R32509 4/23/2012 P0657 D0076 Fernandez BMP Martin Jones Martin Jones R32512 4/24/2012 P0657 D0161 Wong ESR INR Basie metabolic panel Sedimentation rate Lipid profile Sedimentation rate Basic metabolic panel Hepatic function panel Basic metabolic panel Sedimentation rate Clotting time test Adrenal function Aldosterone level Sedimentation rate Lipid profile Basic metabolic panel Heart enzymes Hepatic function panel Sedimentation rate R32517 4/24/2012 P0844 Josh Strauss D0042 Scheimberg ADR ALD ESR R32608 4/25/2012 P0897 Rajiv Patel D0093 Galloway LIPP BMP HFP R32069 4/25/2012 P0781 Isabel Fu D0093 Galloway ESR