Reference no: EM131028734

Use the following information to develop a relational database model (ER diagram). (10 points total) Mom’s Gallery sells original paintings by local artists. All sales occur in the store. Sometimes customers purchase more than one painting. Individual customers must pay for purchases in full at the time of sale. Corporate customers, such as hotels, however may pay in installments if they purchase more than 10 paintings. Mom’s Gallery only purchases finished paintings (it never commissions artists). It pays each artist 50% of the agreed price at the time of purchase, and the remainder after the painting is sold. Although Mom’s Gallery has several bank accounts all sales monies are deposited intact into the main checking account, and all purchases are paid by check from Mom’s main checking account. a. Create an Entity-Relationship diagram that displays each entity and their attributes (as completed in class). As you review the attributes for each entity create any additional attributes you feel would be necessary to complete the diagram (model). b. Identify all primary and foreign keys, you must include a clear identifier. c. Identify all relationships and relationship types between key fields in each entity.