Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Filing And Computer Database Projects

Authors: Jeffrey Stewart

2nd Edition

007822781X, 9780078227813

More Books

Students also viewed these Databases questions