Create the ERD in your drawing tool for microsoft visio for the following problem;

Augment your ERD from problem 31--> [31. Draw an ERD containing the Lab, LabVisit, and Patient entity types connected by 1-M relationships from Lab to LabVisit and Patient to LabVisit. Choose appropriate relationship names using your common knowledge of interactions between labs, lab visits, and patients. Define minimum cardinalities so that a lab is required for a lab visit and a patient is required for a lab visit. For the Lab entity type, add attributes LabNo (primary key), LabName, LabStreet, LabCity, LabState, and LabZip. For the Patient entity type, add attributes PatNo (primary key), PatLastName, PatFirstName, PatDOB (date of birth). For the LabVisit entity type, add attributes for the LVNo (primary key), LVDate, LVProvNo, and optional LVOrdNo (for orders from physicians). Choose appropriate data types for the attributes based on your common knowledge.] with the Specimen entity type. For each specimen collected, the database should record a unique SpecNo, SpecArea (vaginal, cervical, or endocervical), and SpecCollMethod (thin prep or sure path). A 1-M relationship from LabVisit to Specimen. A lab visit must produce at least one specimen. A specimen is associated with exactly one lab visit.