Question: For the below database scheme, add the following conditions using MySql Workbench, provide the code necessary for that: + Return Policy: -purchased date to be
For the below database scheme, add the following conditions using MySql Workbench, provide the code necessary for that:
+ Return Policy:
-purchased date to be stored, no returns are allowed exceeding 30 days from the purchase date.
-returns during the first 15 days after the purchase are free charged.
- returns after the first 15 days of the purchase to day number 30 are charged with 10% extra fees
-only cash purchases customers are allowed to return their purchases
- any customer is not allowed to check out with a purchase if he don't have zero balance.

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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
