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.

For the below database scheme, add the following conditions using MySql Workbench,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!