Create an ER from the following requirement. Use Chen notation with cardinality and participation notation and make a separate diagram with UML notation. If you make an assumption that is not in the requirements, please note this on the ER. Send ER Diagrams to me via e-mail. Be sure to include your name and section in the attachment.
This is a database to track information for an HMO Doctor's office locations. Each office has an address, a name, and keeps track of a total patient count. Offices are either of type Express or Standard. Each office has employees which work specifically for that office. The smallest office has just one doctor and one nurse, the largest has 50 employees. We need to store the name, ssn, and 3 phone numbers for each employee. Each office also keeps track of patients it sees (offices are required to maintain a patient load between 100-5000). Patients are allowed to use up to 2 offices in the HMO system. The name, ssn, date of birth are stored for each patient. Records are kept of each patient visit (if a mom and 2 kids visit, this is considered three patient visits / records, one for each person examined) (although patients may be entered into the system before they make a visit so there may be patients without any records). The patient record consists of a date, a diagnosis code, and a fee.
Additional information: We need to be able to search by patient last names. We do need to have patient's age on occasion but do not want to store it.