For the below database scheme, add the following conditions 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%

Customers Grocery Store Data Model Barry Williams Principal Consultant June 15th. 2008 DatabaseAnswers.org PK customer_id customer_name customer_phone customer_email date_became_customer other_customer_details Addresses PR address_id line_1 line_2 city zip_postcode state_province_county country other_address_details Suppliers Pk supplier_id supplier_address_id supplier_name contact_name supplier_phone supplier_email other_details Calendar | day_date day_number day_of_the_week Products product_id FK product_type FK supplier_id product_name product_price product_description other_details Orders order_id FK customer_id FK order_status_code FK order_day_date paid_for_yn order_details Customer_Addresses CHO customer_address_id FK customer_id FK address_id date_from date_to Employees Che employee_id FK employee_address_id employee_name employee_phone other_employee_details | | Deliveries Order_items PF order_id product_id quantity PF delivery_id FK delivery_status_code FK delivered_by_employee_id FK order_id delivery_date_time other_delivery_details NOTES The Ref_Calendar Table could Include derived fields called Wednesday_yn and friday_yn o simplify the logic in checking. But derived fields should not be shown in a Logical Data Model at this level