Question
Using MySql workbench, assume an existing database design of a cloth store... Add the necessary code to satisfy those conditions: NOTE: YOUR CODE SHOULD BE
Using MySql workbench, assume an existing database design of a cloth store...
Add the necessary code to satisfy those conditions:
NOTE: YOUR CODE SHOULD BE ORIGINAL AND COMMENTS SHOULD BE PROVIDED FOR EVERY STEP
-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.
Step 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