Problem #14

Extend the ERD in problem 13 with the Nurse, the Item, and the VisitDetail entity types connected by 1-M relationships from Visit to VisitDetail, Nurse to VisitDetail, and Item to VisitDetail. VisitDetail is a weak entity with the 1-M relationship from Visit to VisitDetail an identifying relationship. Choose appropriate names for the relationships. Define minimum cardinalities so that a nurse is optional for a visit detail, an item is mandatory for a visit detail, and visit details are optional for nurses and items. For the Item entity type, add attributes ItemNo (primary key), ItemDesc, ItemPrice, and ItemType. For the Nurse entity type, add attributes NurseNo (primary key), NurseFirstName, NurseLastName, NurseTitle, NursePhone, NurseSpecialty, and NursePayGrade. For the VisitDetail entity type, add attributes for the DetailNo (part of the primary key) and DetailCharge. If you are a design tool that supports data type specification, choose appropriate data types for the attributes based on your common knowledge.