United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains
ID: 3549309 • Letter: U
Question
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?
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: What tables would you create, and what would the table components be? How might the (independent) tables be related to one another?Explanation / Answer
You would create three tables:
Table name Table components
PAINTER PTR_NUMBER, PTR_NAME, PTR_PHONE
PAINTING PTG_NUMBER, PTG_TITLE, PTR_NUMBER, GAL_NUM
GALLERY GAL_NUM, GAL_NAME, GAL_ADDRESS
======================================================================
b. The PAINTING table will be related to both the GALLERY and PAINTER tables. The
PAINTING table will contain the attribute PTR_NUMBER, which will relate it to the
PAINTER table. The PAINTING table will also contain the GAL_NUM attribute, which will
relate it to the GALLERY where the painting is being shown
======================================================================
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.