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 levelStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started