Case Study What are the main problems or issues of the case?

What alternatives have been attempted to resolve the problems or issues

What recommendations can be made to resolve the case?

Relevance of the issues raised in the case to real life business problems and applications

Other questions raised by the instructor

United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting is 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 painted by a single painter, but each painter can paint many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database:

a. What tables would you create, and what would the table components be?

b. How might the (independent) tables be related to one another?