Draw ERD diagram Crows foot notation

#2

Draw an ERD containing the Patient, Physician, and Visit entity types. A patient can see multiple physicians but only one physician on any one given visit. Choose appropriate names for the relationships. Define minimum cardinalities so that patients and physicians are required on a visit, while patients don't have to be assigned to physicians (and vice versa). For the Patient entity type, add attributes PatNo, PatFirstName, PatLastName, PatStreet, PatCity, PatState, PatZip, and PatHealthPlan. For the Physician entity type, add attributes PhyNo, PhyFirstName, PhyLastName, PhySpecialty, PhyPhone, PhyEmail, PhyHospital, and PhyCertification. For the Visit entity type, add attributes for the VisitNo, VisitDate, VisitPayMethod (cash, check, or credit card), and VisitCharge. Next, add Nurse, Item, and VisitDetail entity types. On each Visit multiple details are recorded in VisitDetail by one Nurse. VisitDetail has a 1-M relationship from Visit to VisitDetail. Choose appropriate names for the relationships. Define minimum cardinalities so that a nurse can be assigned on a visit detail, an item is required for a visit detail. For the Item entity type, add attributes ItemNo, ItemDesc, ItemPrice, and ItemType. For the Nurse entity type, add attributes NurseNo, NurseFirstName, NurseLastName, NurseTitle, NursePhone, NurseSpecialty, and NursePayGrade. For the VisitDetail entity type, add attributes for the DetailNo and DetailCharge. Make sure you choose appropriate data types for the attributes based on your common knowledge. Select suitable primary keys and foreign keys. Clearly label weak entities, and identifying and non-identifying relationships.