An aging shoe manufacturing company has decided to abandon the highly competitive market for low-cost mass-market shoes.
Instead, it wants to have customers order custom shoes that will be made on demand. Customers will trace or scan their feet and molds will be built specifically for each customer.
The foot information will be digitized and stored in the database so it can be retrieved and used whenever the customer orders shoes.
The firm will produce a variety of standard styles of shoes. Customers will select a style, choose a color and size, and in many cases choose a material.
The orders are sent to company factories that customize the shoe to each person. Customers can also specify minor adjustments to most shoes - such as asking for slightly wider shoes for certain tasks.
The basic information is entered on the sample form, but the company needs everything in a database.
Question :
Create the class diagram for this shoe manufacturing company based on their business rules. Pay attention to many-to-many relationships.
Pay attention to items that could be repeated
(hint: like material, and there could be more). As we discussed in class especially in this level, there is not just one answer You have to justify the decisions you made for the classes and the relationships. (25 points)
An aging shoe manufacturing company has decided to abandon the highly competitive market for low-cost mass-market shoes. Instead, it wants to have customers order custom shoes that will be made on demand. Customers will trace or scan their feet and molds will be built specifically for each customer.
The foot information will be digitized and stored in the database so it can be retrieved and used whenever the customer orders shoes.
The fum will produce a variety of standard styles of shoes. Customers will select a style, choose a color and size, and in many cases choose a material.
The orders are sent to company factories that customize the shoe to each person. Customers can also specify minor adjustments to most shoes - such as asking for slightly wider shoes for certain tasks. The basic information is entered on the sample form, but the company needs everything in a database.
|
OrderlD Order Date
Estimated Ship Date Actual Ship Date Shipping Cost
|
|
|
Customer
Last Name, First Name, Phone, Email Address, City, State, PostalCode Country
LeftFootED, RightFoodlD, Comments
|
|
|
|
Shipping Address
City, State, PostalCode Country
|
|
|
|
StyleID Description Color Material Size
|
.Adjustments
|
Price
|
|
|
|
|