In the context of the View Rigid Gallery Database:

$1.$ Identify the fields that create the relation between the CUSTOMER, TRANS,

WORK, and ARTIST tables.

$2.$ Describe the relationship between each table pairing. For instance, when

considering the CUSTOMER and TRANS tables: a single customer can

initiate multiple transactions, yet every transaction is linked to only one

customer $(1-\backslash$infty $).$ Could you provide similar explanations for other table

combinations?

$3.$ In which table would you expect to find data about customers who have

made purchases?

$4.$ Based on the TRANS table only, is it possible to determine the name of the

Artist who created a piece of work that has been sold? Provide a brief

explanation of how you would retrieve this information."