III. (25 points) Convert the following Enhanced Entity- Relationship diagram into a well-structured relational database design. Use a solid underline for primary key fields. Use a dashed underline for foreign key fields. Use both a dashed underline and a solid underline, or two solid underlines for a field that is both a primary key field and a foreign key field in its table. Do not draw lines or arrows from one table to another. MANUFACTURER PK Merle Address Phone MEDICINE PK Med Name Mind Co Med Type PK Med Admin Num loute ROOM De Room Num PATIENT OPK Patient Nam Name Phone Type PROCEDURE + PK Proc Nur Proc Name Date Result EQUIPMENT Pnventory Name Type | Manufacturer DOCTOR Date installed PK Doctor Num Name DEPARTMENT PK Departe De Phone Secretary Year Afiliated NURSE PK Nurse Num Nurse Mame experience NURSING SCHOOL PK school in University Auto Year Founded Floor Operating Froom Nurse Emergency Room Nurse