Entity: PRODUCT Prod Code (Primary Key): A unique identifier for each product. Prod Descript: Description of the product. Prod_Price: Price of the product. Prod_On_Hand: Quantity of the product available. Vend_Code (Foreign Key): A reference to the VENDOR entity to identify the vendor of the product.

Entity: VENDOR Vend Code (Primary Key): A unique identifier for each vendor. Vend_Contact: Contact information for the vendor. Vend_AreaCode: Area code of the vendor's location. Vend_Phone: Phone number of the vendor.

Entity: SALES Sale_ID (Primary Key): A unique identifier for each sale. Sale_Date: The date on which the sale occurred. Sale_Amount: The total amount of the sale. Sale_Type: Indicates the type of sale (physical retail store, online, trade center).

Entity: CUSTOMER Cust_ID (Primary Key): A unique identifier for each customer. Cust_Name: The name of the customer. Cust_Address: The address of the customer. Cust_Type: Indicates whether the customer is a business or a consumer.

Entity: PAYMENT Payment_ID (Primary Key): A unique identifier for each payment. Payment_Method: The method of payment used for the sale (cash, debit card, credit card, DigPay).

Entity: ORDER Order_ID (Primary Key): A unique identifier for each order. Order_Date: The date the order was placed. Order_Status: Indicates the status of the order (regular, expedited). Order_Quantity: The quantity of paint ordered. Prod_Code (Foreign Key): A reference to the PRODUCT entity, identifying the product in the order. Cust_ID (Foreign Key): A reference to the CUSTOMER entity, identifying the customer who placed the order.

Entity: COMPLAINT Complaint_ID (Primary Key): A unique identifier for each complaint. Complaint_Description: Description of the complaint. Complaint_Rating: Rating provided by the customer (on a 5-star scale).

Entity: MARKETING Marketing_ID (Primary Key): A unique identifier for each marketing campaign. Marketing_Description: Description of the marketing campaign. Marketing_Employee: Employee responsible for the campaign. Marketing_Emails: A list of emails of previous customers.

Based on these entities and these findings, how can a relational model/relational database schema be constructed using this notation as a reference:

and how can the final model be described in continuous text + what are any assumptions made? (diagram in draw.io or something equivalent)