Create Database
Link to view database
| category_id |
categoryName |
manager |
priority |
| 1 |
T-Shirt |
Michael Howard |
2 |
| 2 |
Shorts |
Jerry Anderson |
3 |
| 3 |
Sweatshirts |
David Ruth |
4 |
| 4 |
Pants |
Mary Lewis |
1 |
| dist_id |
distName |
isExclusive |
areaCode |
| 1 |
Target |
1 |
218 |
| 2 |
Amazon |
0 |
612 |
| 3 |
Kohls |
0 |
763 |
| 4 |
Walmart |
1 |
651 |
| product_id |
productName |
color |
quantity |
price |
dist_id |
category_id |
| 1 |
Style Sweatshirt |
Green |
20 |
24.99 |
4 |
2 |
| 2 |
Crew Style T |
Blue |
50 |
14.99 |
1 |
1 |
| 3 |
Striped Short |
Black |
100 |
14.99 |
2 |
1 |
| 4 |
Bucket Hat |
White |
10 |
15.99 |
3 |
4 |
Stored Procedure on PhpMyAdmin
