Question 14 11 12 19 20 26 27 Create an ER Diagram for the following organization, see the example below about how to specify the elements of your Idagram verbally. You need to write down the following information entity names, entity types trene weak, or associative). B. attributes of the entities specify special types of attributes composite multivalued, derived) c.relationship between entities and attributes of relationships if any. d. Don't forget to show identifiers. Example: entity STUDENT (strong ently attributes sen (dentifier), name (first name, last name), date of birth. Tegel entity CLUB (strong entity), attributes: name identifier), location date established There is a many to many relationship, member of relationship between STUDENT and CLUB, Student side is required. CLUB side is optional. There is one attribute of this relationship, date joined. There is also a one-to-on o-one relationship, president of relationship, between STUDENT and CLUB. Student side is required. CLUB side is optional A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee 10 (identifier Name and Phone No. Attributes of PROJECT include Project 10 (identifiers and Start Date Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date that is the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment Item need not be assigned and a given project need not be assigned either a chemist or an equipment item " 1 = = HER