PROBLEM SOLVING QUESTIONS (15 points) Create an ER Diagram for the following organization. See the example below about how to specify the elements of your ER diagram verbally. You need to write down the following information entity names, entity types (strong, weak, or associative) battributes of the entities, specify special types of attributes (composite, multivalued, derived), relationship between entities, and attributes of relationships if any. Don't forget to show identifiers. Example: entity STUDENT (strong entity), attributes: ssn (identifier), name (first name, last name), date of birth, [age] 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-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 ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) 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