Problem #13

Draw an ERD containing the Patient, Physician, and Visit entity types connected by 1-M relationships from Patient to Visit and Physician to Visit. Choose appropriate names for the relationships. Define minimum cardinalities so that patients and physicians are mandatory for a visit, but visits are optional for patients and physicians. For the Patient entity type, add attributes PatNo (primary key), PatFirstName, PatLastName, PatStreet, PatCity, PatState, PatZip, and PatHealthPlan. For the Physician entity type, add attributes PhyNo (primary key), PhyFirstName, PhyLastName, PhySpecialty, PhyPhone, PhyEmail, PhyHospital, and PhyCertification. For the Visit entity type, add attributes for the VisitNo (primary key), VisitDate, VisitPayMethod (cash, check, or credit card), and VisitCharge. If you are using a data modeling tool that supports data type specification, choose appropriate data types for the attributes based on your common knowledge.