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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started