Solve the following questions using database concepts:
Problem: United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries.
- A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery.
- Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database:
Question 1. What tables would you create, and what would the table components be?
Question 2. How might the (independent) tables be related to one another?
Please show me all the workings and give me the answers of these questions.