How to make a relational model/relational database schema ensuring every entity links to each other with these entities:

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.

Entity: Retail Store

• Represents the physical retail stores operated by Diplo Paints.
• Attributes: Store ID (Primary Key), Location (State), Payment Options (Cash, Debit, Credit, DipPay).

Entity: Website

• Represents the online sales component of Diplo Paints.
• Attributes: Website ID (Primary Key), Shipping Options (Regular, Expedited).

Entity: Trade Centre

• Represents the trade centres where businesses can connect and trade.
• Attributes: Centre ID (Primary Key), Settlement Period.

Entity: Distribution Centre

• Represents the storage locations for paint volumes delivered by international suppliers.
• Attributes: Centre ID (Primary Key), Location

based on this as a reference: (note that every single entity has to somehow link)