Create the ERD in your drawing tool for microsoft visio for the following problem; 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.