12. Convert the ERD from Problem 10 into a corresponding UML class diagram.

10. 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:

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

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

10 answer:

ANShIeR tables Jou toold Create Thee lable ameon ronent DAIN'TeR TR NUMBER ,PTR NAM PAINT E R pra-NUMBER, pTG-Title,MR-NUMBER CAL NUM GAL-NJUM , GAL-NAME ,GAL-ADnRess GALLERy nd PAINTER tobles The rAINTING table tus," cortin -the PTR NUMBER , t.Heh u'in be 'elata t-to-the PAINTER table ->The PA'NTING table ten" oleo -to the CALLeRy being shown twheve the ining