Question

. 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.

Answer 1

ANSWER::

ER diagram for Specimen -TestOrder ( augmented from 32)

ERD - Specimen - Testorder Patient 1.1 PatNO (PK) PatFirstName PatLastName PatDOB LabVisit LVNO (PK) LVDate LVProvNo LVOrdNo (O) Specimen SpecNo (PK) SpecArea SpecColl Method LVNO (FK) 1,N 1.N --- O TestOrder TO TestName TO TestType TO TestResult SpecNo (FK)

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU