Explore BrainMass

database design

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.

Solution Summary

Discuss database design