Need to do business rules for the following:
Scenario – Discuss database design:
1. Colors for models:
a. Classic red, blue, green
b. Competition: silver, black
c. RoboZid: baby blue, pink, yellow.
2. Personalizaton limits:
a. Classic: 1 line, 12 letters
b. Competition 2 lines, 8 letters
c. RoboZid: 2 lines, 5 letters
3. Cannot ship to P.O. Box
4. Manufacturing Process:
a. Order, build, paint/ personalize, mail
b. Each step takes 7 days except mail, which is the next day after personalize.
5. They want ot add calculation of shipping and tax.
6. Model numbers will always be four digits.