Need help with 2) Consultancy. Need an ERD

Instructions In this session, you will be drawing logical models for relational databases using ERD principles. For each scenario below draw an ERD which represents the data requirements of the Art Exhibition. - Identify and depict all entity sets and their attributes - Identify and depict all relationships between entity sets - Ensure that all primary keys and foreign keys are noted in the entity sets 1) Art exhibition An art museum owns a large volume of works of art. Each work of art is identified by an item code. Each work can be described using a title, the size - composed of height, width and weight. A work of art is developed by an artist. The artist of some works is not known. An artist is identified by an artist number and described by name, age, gender, and dod (null for living artists!). Only data about artists for works currently owned by the museum are kept in the database. A painting may be painted by more than one artist. At any time, an art work is either displayed in the museum, held in storage away from the museum as part of a travelling show, or on loan to another gallery. If on display at the museum, the location of the display within the museum is noted. A painting may be displayed in many locations in one museum over time. A travelling show is described by a show ID, city in which the show is currently appearing, and the start and dates of the show. Many of the museum art work can be part of a given show. One art work can be displayed in many shows over time. These need to be recorded for future analysis. A gallery is described by a gallery identifier, name and city. The museum wants to retain a history of all works of art loaned to another gallery. The date loaned and the date returned must be recorded and retained. A painting may be loaned to more than one gallery over time. 2) Consultancy You are working for a consulting company and want to create a very simple database. This database will be used to track problems CLIENTS are having and the consultants who are working on them. Each client can have many PROBLEMS and many clients can be facing the same problems. Each time a client reports a problem you want to track the client, what their problem is, the CONSULTANT who is working on it and the date it was logged into the system, its status and the date the problem was solved (note this is blank for pending problems). Consultants also work on many problems at any given time. For each type of problem there is one consultant who is considered the expert on this problem. A consultant can be an expert on many different types of problems