Question: Create the ERD in your drawing tool for microsoft visio for the following problem; Augment your ERD from problem 32 with the TestOrder entity type
Create the ERD in your drawing tool for microsoft visio for the following problem;
Augment your ERD from problem 32 with the TestOrder entity type and a relationship between TestOrder and Specimen. Multiple test orders can be created for a specimen, but a specimen does not have a test order until a delay, from hours to days. A test order is created for exactly one specimen. A test order contains a TONo (primary key), TOTestName, TOTestType (HPV, CT/GC, CT, or GC), and TOTestResult (positive, negative, equivocal, or failure). If a test order produces a failure, the specimen is given a new test order and tested again until a non-failure result is obtained.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
