For the case below, please answer the following questions:

1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys).

2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+).

An art researcher has asked you to design a database to record details of artists and the museum in which their paintings are displayed. For each painting, the researcher wants to know the size of the canvas, year painted, title, and style. The nationality, date of birth and death of each artist must be recorded. For each museum, record details of its location and specialty if it has one.

Answer as fast as you can