If possible please use lucidchart. Having a diffcult figuring this out, especially question 2. Thank you.

The local art gallery needs a database system to help keep track of artists' work. Data needs to be kept on each artist and his or her artwork, customers, galleries and art exhibitions, orders, and rentals. Your task is to draw an ER model with the entities and attributes described here. You will then use the resulting ER model to create a dependency diagram. 1. Use the following business rules to create an ER model. Label all entities, relationships, and cardinalities. Place attributes in the appropriate tables and identify primary and foreign keys. An artist may create one or more pieces of artwork, while each piece of artwork may be created by one and only one artist. One piece of artwork must be present at one and only one art exhibition, while an art exhibition may be presenting one or more pieces of artwork. One gallery must be putting on one and only one art exhibition, and one art exhibition may be put on by one or more art galleries. One piece of artwork may be rented via one or more rentals. One rental must be agreed upon to rent one and only one piece of artwork. One piece of artwork may be ordered via one or more orders-to-buy. One order-to-buy must be agreed upon to buy one and only one piece of artwork. One rental must be a rental agreement for one and only one customer, and one customer may be renting one or more rental. One customer may be placing one or more orders-to-buy, but each order-to-buy can be placed by one and only one customer. . Attributes required: . Artist: Artist ID, Artist first name, Artist last name, Artist birth date, Artist birth place, Artist phone number, and Artist style Artwork: Art ID, Year, Title, Price, Description, and Type Customer: Customer ID, Customer first name, Customer last name, Customer phone number, and Customer address (Street, City, State, Zip, Country) Gallery: Gallery ID, Gallery name, Start Date, End Date, Country, City, State, and Zip Rental: Rental start date, Rental end date, and Rental price Order-to-Buy: Order price and Order date . . 2. Create a dependency diagram and then normalize to meet the 3NF requirements to the greatest practical extent possible