3- United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small databaseto track painters, paintings, and galleries. A painting is created by a particular artist and thenexhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can beexhibited in only one gallery. Similarly, a painting is created by a single painter, but each paintercan create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relationaldatabase:a. What tables would you create, and what would the table components be?b. How might the (independent) tables be related to one another?C.Create a basic ERD.d. Convert the ERD above to a UML Class Diagram.

a. Tables and Components:PAINTER:PainterID (Primary Key)NameBirthdateNationalityContactInfo (or this…

Answered: 3- United Broke Artists (UBA) is a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

3- 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?
C.
Create a basic ERD.
d. Convert the ERD above to a UML Class Diagram.

Expert Solution

Step 1: Solution a and b):

a. Tables and Components:

PAINTER:
- PainterID (Primary Key)
- Name
- Birthdate
- Nationality
- ContactInfo (or this could be broken down into Address, Phone, Email, etc.)
PAINTING:
- PaintingID (Primary Key)
- Title
- Year
- Medium (e.g., oil on canvas)
- PainterID (Foreign Key to PAINTER)
- GalleryID (Foreign Key to GALLERY)
GALLERY:
- GalleryID (Primary Key)
- Name
- Location
- ContactInfo (or again, can be detailed further)

b. Relations between Tables:

PAINTER to PAINTING: One-to-Many relation. One painter can create many paintings, but each painting is created by a single painter. The linkage is made using PainterID as a foreign key in the PAINTING table.
GALLERY to PAINTING: One-to-Many relation. One gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. The linkage is established with GalleryID as a foreign key in the PAINTING table.

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions