READ THE QUESTION CAREFULLY, DON'T COPY AN EXISTING ANSWER ON THE PLATFORM

For the below database scheme, add the following constrains using MySql Workbench, provide the code necessary for that:

- if the purchased product is returned from 15-30 days later than the purchase gets place, Let the product to be classified as new or refurbished .

- an invoice should be issued if a customer selects one or more than one product/s.

- users are allowed to use different payment options, ie: cash payment option and on installments payment option, one user may have multiple invoices for a certain purchase.

- for instalment payment option : let the instalments to be for 12 months ant its interest rate to be 10%

Suppliers supplier_id INT supplier_add_id INT supplier_name VARCHAR(45) contact_name VARCHAR(45) supplier_phn VARCHAR(45) supplier_email VARCHAR(45) other_details VARCHAR(45) Customer customer_id INT customername VARCHAR(45) customer_phn VARCHAR(45) customer_email VARCHAR(45) date_bec_cust DATE other_cust_details VARCHAR(45) Indexes Addresses address_id INT line_1 VARCHAR(45) line_2 VARCHAR(45) city VARCHAR(45) zipcode VARCHAR(45) sstate_prov VARCHAR(45) country VARCHAR(45) other_address_details VARCHAR(45) Indexes # Indexes Et calender day_date INT day_number INT day_of_week VARCHAR(45) Indexes Product product_id INT product_type VARCHAR(45) supplier_id VARCHAR(45) prod_name VARCHAR(45) prod_price DOUBLE prod_desc VARCHAR(45) other_details VARCHAR(45) Suppliers_supplier_id INT Indexes HE order_items 1 order_id INT product_id INT 1-5 quantity INT Product_product_id INT Indexes customer_address customer_address_id INT customer_id INT address_id INT date_from DATE date_to DATE Customer_customer_id INT Addresses_address_id INT Indexes Employees employee_id INT employee_address_id INT employee_name VARCHAR(45) employee_phone VARCHAR(45) other_emp_details VARCHAR(45) Addresses_address_id INT Indexes > Deliveries delivery_id INT delivery_status_code INT delivered_emp_id INT order_id INT deli vary_date DATE other_delivary_details VARCHAR(45) Employees_employee_id INT order_order_id INT order_items_order_id INT calender_day_date INT Indexes u order order_id INT customer_id INT order_status_code VARCHAR(45) order_day_date VARCHAR(45) paid_for_yn VARCHAR(45) oder_details VARCHAR (45) Customer_customer_id INT Indexes